A user has enabled the STRIP_OUTER_ARRAY file format option for the COPY INTO {table} command to remove the outer array structure.
What else will this format option and command do?
A user has enabled the STRIP_OUTER_ARRAY file format option for the COPY INTO {table} command to remove the outer array structure.
What else will this format option and command do?
When the STRIP_OUTER_ARRAY file format option is enabled for the COPY INTO {table} command, it removes the outer array structure from the JSON data. This allows the individual records within the array to be treated as separate rows and loaded into the table accordingly, without the need for additional transformation. Therefore, the records will be loaded into separate table rows.
A correct - https://interworks.com/blog/chastie/2020/01/28/zero-to-snowflake-loading-and-querying-semi-structured-json-data/
correct