What is the maximum compressed row size in Snowflake?
What is the maximum compressed row size in Snowflake?
The maximum compressed row size in Snowflake is 16MB. This limitation applies to both structured and semi-structured data types, ensuring consistency in how data is stored and managed within the platform.
Was on exam 20/12/2022
MAX size for compressed data for semi-structured data type is also 16 MB. That means if our table has a semi-structured data type column with 16MB data other columns will have NULL data.
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html#semi-structured-data-size-limitations 16MB per row captured in the variant field
16 Mb is the max compressed size
B.16MB
B is correct
B is correct
B is correct