Strip outer array from a JSON in Snowflake
Imagine that you want to load semi-structured data in the form of JSON into Snowflake. If the JSON contains an outer array and if you did not strip it, the entire dataset would be loaded into a single row in the target table. Sometimes that is acceptable and you can process the data in a…