STORAGE.AUTO_CLUSTERING_SUSPEND

Target database: Snowflake

STORAGE.AUTO_CLUSTERING_SUSPEND option can be used to disable Snowflake automatic clustering service for an entity where a SORT_KEY (clustering key) has been defined.

See also:

• SORT_KEY

• Automatic Clustering (Snowflake documentation)

• Clustering Keys & Clustered Tables (Snowflake documentation)

• CONFIG_ENTITY_DEFAULTS

Usage

STORAGE.AUTO_CLUSTERING_SUSPEND: Boolean

Default: false

Notes

STORAGE.AUTO_CLUSTERING_SUSPEND assumes that a SORT_KEY (clustering key) has been defined for the entity.

Examples

Suspending automatic clustering for a table

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

STORAGE.AUTO_CLUSTERING_SUSPEND: true

Agile Data Engine will execute the following DDL on deployment to disable automatic clustering:

ALTER TABLE publish.F_TRIP SUSPEND RECLUSTER;