True or False: Once created, a micro-partition will never be changed.
True or False: Once created, a micro-partition will never be changed.
False. A micro-partition, once created, can be affected by operations such as reclustering, which may reorganize the data into new micro-partitions. This indicates that while the original data within a micro-partition is immutable, the structure and organization of micro-partitions themselves can change.
While True, it is important to note new micro-partitions are created when new data is uploaded or data is transformed. Additional old micro-paritions are stored for time-travel support purposes
Immutable
The immutability of micro partition it means that there could be changes in relation to the status of the data in micro partition, so it could be updated or deleted but this is kept as information. But the data itself cannot be changed.Even if update with the clustering key it will add new micropartitions with the changes
The answer is correct as How did they do this? Let’s break down how Snowflake stores data: in Snowflake, all data is stored in micro-partitions, which are contiguous units of storage that are immutable. Immutability means that once a micro-partition is written, it will never be changed
A.True
micro partition can be changed but not deleted.
How can we say a micro-partition can't be changed if using clustering keys we're literally changing how micro-partitions are organized? I think it's B, can't find these "immutable" references from the other answers anywhere. https://community.snowflake.com/s/article/understanding-micro-partitions-and-data-clustering
In reclustering context, reorganizing doesn't mean that anything changes in existing micro-partitions' structure - instead the new micro-partitions are created with the same keys as in old micro-partitions before reclustering but reorganized to fit the clustering requirements. Check this article for a reference: https://docs.snowflake.com/en/user-guide/tables-clustering-keys#reclustering Check the diagram from a provided example. New micro-partitions are called "new" for a reason, also the new numbering (micro-partition 5, 6, 7, 8) should give you a clue.
A is correct
Correct, it can never be changed. They are immutable.