Some general indicators that can help determine whether to define a clustering key for a table include:
Queries on the table are running slower than expected or have noticeably degraded over time.
The clustering depth for the table is large.
https://docs.snowflake.com/en/user-guide/tables-clustering-keys
A column with very low cardinality might yield only minimal pruning, such as a column named IS_NEW_CUSTOMER that contains only Boolean values.
In other words, very low cardinality columns may not be worth clustering (the way I read it).
DE
Queries on the table are running slower than expected or have noticeably degraded over time.
The clustering depth for the table is large.
https://docs.snowflake.com/en/user-guide/tables-clustering-keys#label-considerations-for-choosing-clustering
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.
halol
Highly Voted 2 years, 5 months agoKate0204
Highly Voted 2 years, 5 months agoMallikharjuna452
Most Recent 9 months, 3 weeks ago_yyukta
1 year, 2 months agoe_l_i_a_s
1 year, 3 months agoMarge23
1 year, 7 months agov1tjkee
1 year, 7 months ago0e504b5
1 year, 3 months agoMultiCloudIronMan
1 year, 10 months agogirgir
2 years, 2 months agofahfouhi94
2 years, 3 months agoAlexbDku
2 years, 4 months ago