Notifications
Clear all
Topic starter
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
Suggested 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.
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.
Posted : 29/01/2023 1:06 am