Good vs Poor Clustering Key Candidates

The Snowy Peak data team is reviewing their largest tables and deciding which columns are worth defining as clustering keys. A good candidate has moderate cardinality and is frequently used in WHERE filters. A poor one either has too few distinct values to create meaningful partition boundaries, or too many to group rows usefully.