STRIP_OUTER_ARRAY is a Snowflake COPY option for loading structured JSON files whose outer array contains multiple objects. It removes that wrapper and loads each object as a separate target-table row. section 4.2
Use it when the ingestion pipeline encounters these conditions:
- The input is JSON containing an outer array of similarly structured objects. section 4.2
- A single document would exceed Snowflake’s 16 MB VARIANT size limit. section 4.2
- The provider can produce structured files with multiple same-structure objects per document. section 4.2
Array-to-row ingestion
A JSON document containing an array of order objects can be loaded so that each order object becomes its own row in the target table, rather than remaining inside one VARIANT value. section 4.2
