While choosing a cluster key, what is recommended by snowflake?

While choosing a cluster key, what is recommended by snowflake?
A . Cluster columns that are most actively used in selective filters
B. If there is room for additional cluster keys, then consider columns frequently used in join predicates
C. Choose a key with high cardinality

View Answer

Answer: A,B

Explanation:

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. For event tables, event type might be a good choice, if there are a large number of different event types. (If your table has only a small number of different event types, then see the comments on cardinality below before choosing an event column as a clustering key.)

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".