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

Question

Ahmed Alghadeer · Accepted Answer

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

Ahmed Alghadeer · Answer

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

Ahmed Alghadeer · Answer

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

Ahmed Alghadeer · Answer

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

List of questions