From the documentation at ( https://docs.snowflake.com/en/user-guide/tables-clustering-keys ):
Snowflake recommends prioritizing keys in the order below:
Cluster columns that are most actively used in selective filters. For many fact tables involved in date-based queries (for example “WHERE invoice_date > x AND invoice date <= y”), choosing the date column is a good idea.[...]
If there is room for additional cluster keys, then consider columns frequently used in join predicates, for example “FROM table1 JOIN table2 ON table2.column_A = table1.column_B”.
While ORDER BY (A) and GROUP BY (C) operations can sometimes benefit from clustering, the most significant improvements are generally seen with WHERE and JOIN operations. AGGREGATE (D) operations are not as directly impacted by clustering as the other two.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
18527ec
2 days, 14 hours agoywan1600
2 months agoViniJsr
2 months, 1 week ago9df430d
2 months, 2 weeks ago