SnowPro Advanced Architect

For a multi-column Snowflake clustering key, columns should generally be ordered from lowest to highest cardinality. C_DATE has 110 distinct values, followed by A_ID with 11 K and NAME with 300 K. The EVENT_ACT columns have extremely high cardinality relative to the table’s 1.5 M micro-partitions, so they are poor direct candidates. Snowflake also advises against directly clustering on very high-cardinality columns.