Micro-partitions in Snowflake are immutable objects, which means once they are written, they cannot be modified. This immutability supports the use of Time Travel, allowing users to access historical data within a defined period. Additionally, micro-partitions can significantly reduce the amount of I/O from object storage to virtual warehouses. This is because Snowflake’s query optimizer can skipover micro-partitions that do not contain relevant data for a query, thus reducing the amount of data that needs to be scanned and transferred.
[References: [COF-C02] SnowPro Core Certification Exam Study Guide, , https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html, , , ]
Submit