What does a table with a clustering depth of 1 mean in Snowflake?
What does a table with a clustering depth of 1 mean in Snowflake?
In Snowflake, a table with a clustering depth of 1 means that the table has no overlapping micro-partitions. Clustering depth measures how well sorted the data is within the micro-partitions and a depth of 1 indicates that each micro-partition is distinct and not intersecting with another.
C is correct. The document diagram show clustering level as 1 has no overlapping. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions
Higher the overlap micro partition, higher is the overlap depth. Overlap depth=1 means there are no overlap
C correct
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.
Refer to this diagram: https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions#clustering-depth-illustrated
C is the Correct Answer according to the documentation
B https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions
C https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions https://docs.snowflake.com/en/sql-reference/functions/system_clustering_depth
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions