What Snowflake system functions are used to view and or monitor the clustering metadata for a table? (Select TWO).
Effective pruning in Snowflake relies on the organization of data within micro-partitions. By using an ORDER BY clause with clustering keys when loading data into the reporting tables, Snowflake can better organize the data within micro-partitions. This organization allows Snowflake to skip over irrelevant micro-partitions during a query, thus improving query performance and reducing the amount of data scanned12.
* Snowflake Documentation on micro-partitions and data clustering2
* Community article on recognizing unsatisfactory pruning and improving it1
Linn
1 months agoGerald
1 months agoBettina
13 days agoLashawn
1 months agoJuliann
18 days agoDaren
1 months agoYen
1 months agoTish
2 months agoNina
12 days agoDorcas
1 months agoShawn
1 months agoEugene
2 months agoLashunda
2 months agoChi
3 months ago