The FLATTEN function is used to query which type of data in Snowflake?
The FLATTEN function is used to query which type of data in Snowflake?
The FLATTEN function in Snowflake is used to query semi-structured data. Semi-structured data often contains nested structures, such as JSON or XML, which require flattening to break the data into a more tabular form for easier querying. Structured data, on the other hand, is already in a tabular format and does not need flattening.
C is correct, see https://docs.snowflake.com/en/sql-reference/data-types-structured#label-structured-types-working-flatten
Correct answer FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by definition it shouldn't be nested.
It works for both
Works with both
Correct
B is correct
B is correct