Historically, this limit for many of these "large object" (LOB) types was 16 MB (compressed). However, Snowflake has increased these limits in recent updates (BCR Bundles).
Current (or recently increased) limits for individual column values:
128 MB for VARCHAR, VARIANT, ARRAY, and OBJECT.
64 MB for BINARY, GEOGRAPHY, and GEOMETRY.
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
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
RichMelbourne
Highly Voted 2 years, 7 months ago7b52dde
Most Recent 2 weeks, 4 days agojeny12138
4 months, 1 week agoMallikharjuna452
1 year ago_yyukta
1 year, 5 months agoMayuri917233
2 years, 3 months agoAtulRaje
2 years, 7 months agoTapasgup007
2 years, 8 months agoSundarr
3 years, 6 months agoarpit_dataguy
3 years, 6 months ago