What columns are returned when performing a FLATTEN command on semi-structured data? (Choose two.)
What columns are returned when performing a FLATTEN command on semi-structured data? (Choose two.)
When performing a FLATTEN command on semi-structured data, the columns that are returned typically include KEY and VALUE. These columns represent the key-value pairs in the flattened structure. The KEY column contains the keys from the original structure, and the VALUE column contains the corresponding values. This provides a simplified view of the hierarchical data in a tabular format.
https://docs.snowflake.com/en/sql-reference/functions/flatten.html#output
+-----+------+------+-------+-------+------+ | SEQ | KEY | PATH | INDEX | VALUE | THIS | |-----+------+------+-------+-------+------|
https://docs.snowflake.com/en/sql-reference/functions/flatten.html#output
Ac are correct
Correct