
Ultimate access to all questions.
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.