Skip to main content
Skip table of contents

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

OPTION
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):

OPTION
STORAGE.AUTO_CLUSTERING_SUSPEND: true

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

SQL
ALTER TABLE publish.F_TRIP SUSPEND RECLUSTER; 
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.