Which clustering indicator will show if a large table in Snowflake will benefit from explicitly defining a clustering key?
Which clustering indicator will show if a large table in Snowflake will benefit from explicitly defining a clustering key?
In Snowflake, clustering depth indicates the average depth of the overlapping micro-partitions for specified columns in a table. A lower average depth signifies that the table is better clustered with respect to the specified columns. Monitoring clustering depth can help in assessing the clustering health of a large table and determining if it would benefit from explicitly defining a clustering key.
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html#label-clustering-depth
Clustering Depth The clustering depth for a populated table measures the average depth (1 or greater) of the overlapping micro-partitions for specified columns in a table. The smaller the average depth, the better clustered the table is with regards to the specified columns. Clustering depth can be used for a variety of purposes, including: Monitoring the clustering “health” of a large table, particularly over time as DML is performed on the table. Determining whether a large table would benefit from explicitly defining a clustering key.
B. Depth
Correct
Verified