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:
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;