Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmasmnth

A table needs to be loaded.

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?

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.

Snowflake COF-C02 Summary

  • Vendor: Snowflake
  • Product: COF-C02
  • Update on: Aug 1, 2025
  • Questions: 893
Price: $52.5  $149.99
Buy Now COF-C02 PDF + Testing Engine Pack

Payments We Accept

Your purchase with ExamsVCE is safe and fast. Your products will be available for immediate download after your payment has been received.
The ExamsVCE website is protected by 256-bit SSL from McAfee, the leader in online security.

examsvce payment method