The FLATEEN function is used to query which type of data in Snowflake?

The FLATEEN function is used to query which type of data in Snowflake?
A . Structured data
B. Semi-structured data
C. Both of the above
D. None of the above

View Answer

Answer: B

Explanation:

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

FLATTEN is used to unnest semi-structured data. Don’t see an application for structured data as by definition it shouldn’t be nested.