Valid COF-C02 Dumps shared by ExamDiscuss.com for Helping Passing COF-C02 Exam! ExamDiscuss.com now offer the newest COF-C02 exam dumps, the ExamDiscuss.com COF-C02 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com COF-C02 dumps with Test Engine here:
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed: COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON) The load failed with this error: Max LOB size (16777216) exceeded, actual size of parsed column is 17894470. How can this issue be resolved?
Correct Answer: B
The error "Max LOB size (16777216) exceeded" indicates that the size of the parsed column exceeds the maximum size allowed for a single column value in Snowflake, which is 16 MB. To resolve this issue, the file should be split into multiple smaller files that are within the recommended size range of 100 MB to 250 MB. This will ensure that each JSON document within the files is smaller than the maximum LOB size allowed. Compressing the file, using a larger-sized warehouse, or setting STRIP_OUTER_ARRAY=TRUE will not resolve the issue of the column size exceeding the maximum allowed. References: COPY INTO Error during Structured Data Load: "Max LOB size (16777216) exceeded..."