How is table data compressed in Snowflake?
How is table data compressed in Snowflake?
Each column is compressed as it is stored in a micro-partition. Snowflake uses a columnar format for storing data, and it optimizes and compresses each column individually within the micro-partitions. Snowflake automatically determines the most efficient compression algorithm for the columns in each micro-partition, ensuring efficient storage and quick retrieval of data.
Answer is A
COLUMNAR FORMAT When data is loaded into Snowflake, Snowflake reorganizes that data into its internal optimized, compressed, columnar format. Snowflake stores this optimized data in cloud storage. Snowflake manages all aspects of how this data is stored — the organization, file size, structure, compression, metadata, statistics, and other aspects of data storage are handled by Snowflake. The data objects stored by Snowflake are not directly visible nor accessible by customers; they are only accessible through SQL query operations run using Snowflake.
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions
shoul be A. Snowflake automatically determines the most efficient compression algorithm for the columns in each micro-partition. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions#what-are-micro-partitions
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions#what-are-micro-partitions