SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ117

Design and Manage Snowflake Resources and Performance

A Data Engineer has a table that has no clustering key defined. The Engineer wants to analyze the distribution of micro-partitions by using system functions.

To determine the best clustering key for the table, the Engineer runs the following query:

SELECT SYSTEM$CLUSTERING_INFORMATION('table1');

What is the result of this query?

Explanation

For a table without a defined clustering key, SYSTEM$CLUSTERING_INFORMATION requires a second argument specifying the column expression or expressions to evaluate. Omitting it causes an error because Snowflake has no clustering key on which to base the information.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!