STORAGE.SEARCH_OPTIMIZATION

Target database: Snowflake

STORAGE.SEARCH_OPTIMIZATION option enables Snowflake Search Optimization Service for an entity. Search optimization is aimed to improve performance of selective point lookup queries on large tables.

See also:

• Understanding the Search Optimization Service (Snowflake documentation)

• CONFIG_ENTITY_DEFAULTS

Usage

STORAGE.SEARCH_OPTIMIZATION: Boolean

Default: false

Notes

Search optimization is available in Snowflake Enterprise Edition (or higher).

Search optimization can be enabled for tables.

Examples

Enabling Search Optimization for a table

Setting STORAGE.SEARCH_OPTIMIZATION to true for a table (e.g. F_TRIP):

STORAGE.SEARCH_OPTIMIZATION: true

DDL generated by Agile Data Engine:

ALTER TABLE publish.F_TRIP ADD SEARCH OPTIMIZATION;