What is a fundamental characteristic of Snowflake micro-partitions?
What is a fundamental characteristic of Snowflake micro-partitions?
Snowflake micro‑partitions are immutable, contiguous units of storage that, once written, are never modified in place—any updates or deletes result in new micro‑partitions being created and the old ones retained (e.g., for Time Travel). This immutability underpins Snowflake’s architecture, enabling reliable metadata management, efficient pruning, and snapshot isolation.