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

Question

Joseph Lewis · Accepted Answer

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

Joseph Lewis · Answer

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

Joseph Lewis · Answer

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

Joseph Lewis · Answer

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

List of questions