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

Snowflake COF-C02 Question Answer

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

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

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

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

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

COF-C02 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"