Which function will convert semi-structured data to a relational data representation'?
PARSE_JSON
FLATTEN
OBJECT_CONSTRUCT
OBJECT AGG
The FLATTEN function converts semi-structured data (e.g., JSON or XML) into a relational representation by expanding nested structures into rows.
Example:
SELECT FLATTEN(INPUT => PARSE_JSON('[{"key": "value1"}, {"key": "value2"}]'));
References:
Snowflake Documentation: FLATTEN Function
Snowflake Semi-Structured Data Handling
Which table function will identify data that was loaded using COPY INTO
