Which system functions does Snowflake offer to monitor clustering information in a table?
SYSTEM$CLUSTERING_INFORMATION returns clustering details for a table, including average clustering depth and micro-partition overlap information. SYSTEM$CLUSTERING_DEPTH computes the table’s average clustering depth, a measure used to assess clustering quality.
SYSTEM$CLUSTERING_INFORMATION
SYSTEM$CLUSTERING_DEPTH
Community Discussion