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
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
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
Immutable
A. True Once a micro-partition is created in Snowflake, it cannot be modified. Micro-partitions are immutable, meaning that after data is written to them, they cannot be altered or updated directly. However, Snowflake automatically manages data storage and optimization. If data in a micro-partition needs to be updated, the system will create new micro-partitions with the updated data, and older partitions will eventually be marked for deletion during data maintenance operations like vacuuming. This immutability helps Snowflake maintain its performance and data consistency over time.
Correct, it can never be changed. They are immutable.
A is correct
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.
micro partition can be changed but not deleted.
A.True
Micro-partitions are immutable