A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file…

Data Size Limitations

The VARIANT data type imposes a 16 MB size limit on individual rows.

For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation

of multiple documents. The JSON output from some software is composed of a single huge array

containing multiple records. There is no need to separate the documents with line breaks or

commas, though both are supported.

If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO

copy into

from @~/.json

file_format = (type = 'JSON' strip_outer_array = true);

https://docs.snowflake.com/en/user-guide/semistructured-considerations.html