Which TABLE function helps to convert semi-structured data to a relational representation?
Which TABLE function helps to convert semi-structured data to a relational representation?
The TABLE function that helps to convert semi-structured data to a relational representation is FLATTEN. This function is used to transform nested semi-structured data (such as JSON) into a flat relational format, making it easier to work with in a relational database context.
Answer : C https://docs.snowflake.com/en/sql-reference/functions/flatten.html
It should be C
C - FLATTEN
C is correct
FLATTEN can be used to convert semi-structured data to a relational representation
correct
C - FLATTEN