The Snowflake system functions used to view and monitor the clustering metadata for a table are:
* SYSTEM$CLUSTERING_INFORMATION
* SYSTEM$CLUSTERING_DEPTH
Comprehensive But Short Explanation:
* The SYSTEM$CLUSTERING_INFORMATION function in Snowflake returns a variety of clustering information for a specified table. This information includes the average clustering depth, total number of micro-partitions, total constant partition count, average overlaps, average depth, and a partition depth histogram. This function allows you to specify either one or multiple columns for which the clustering information is returned, and it returns this data in JSON format.
* The SYSTEM$CLUSTERING_DEPTH function computes the average depth of a table based on specified columns or the clustering key defined for the table. A lower average depth indicates that the table is better clustered with respect to the specified columns. This function also allows specifying columns to calculate the depth, and the values need to be enclosed in single quotes.
References:
* SYSTEM$CLUSTERING_INFORMATION: Snowflake Documentation
* SYSTEM$CLUSTERING_DEPTH: Snowflake Documentation