What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Question

Peter Keijer · Accepted Answer

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Peter Keijer · Answer

Data is hashed by the cluster key to facilitate fast searches for common data values

Peter Keijer · Answer

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Peter Keijer · Answer

Smaller micro-partitions are created for common data values to allow for more parallelism

List of questions