Answer-first summary for fast verification
Answer: Split the file into multiple files in the recommended size range (100 MB - 250 MB).
The error 'Max LOB size (16777216) exceeded' indicates that a single JSON document within the file exceeds Snowflake's 16 MB limit for VARIANT columns. While option D (STRIP_OUTER_ARRAY=TRUE) is useful for JSON files wrapped in an outer array structure, it doesn't address the core issue of individual documents exceeding the size limit. The most effective solution is option B - splitting the file into multiple smaller files (100-250 MB range), as this ensures no single JSON document exceeds the 16 MB LOB limit. Option A (compression) won't help since the limit applies to uncompressed data size. Option C (larger warehouse) is irrelevant as warehouse size doesn't affect the 16 MB LOB limit. The community discussion shows strong support for B, with detailed explanations that splitting files addresses the root cause of individual documents being too large.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A table is being loaded from a 3 GB JSON file that is a concatenation of multiple JSON documents, using a size S warehouse. The COPY INTO command COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON) failed with the error "Max LOB size (16777216) exceeded, actual size of parsed column is 17894470." How can this issue be resolved?
A
Compress the file and load the compressed file.
B
Split the file into multiple files in the recommended size range (100 MB - 250 MB).
C
Use a larger-sized warehouse.
D
Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.