Snowflake DBA

Storage, Tables & Micro-partitions

Question

Micro-partitions versus user-defined partitions: what differs, and when should administrators intervene?

Answer

Micro-partitions are automatic contiguous, columnar storage units created from load order. User-defined partitions are not an administrative construct for standard Snowflake tables. Intervene with clustering or search optimization when measured pruning is inadequate for a large, important workload.

This is 7 of 21 free samples for Snowflake DBA.

More Snowflake DBA topic samples