Which function is used to convert rows in a relational table to a single VARIANT column?
Which function is used to convert rows in a relational table to a single VARIANT column?
The function used to convert rows in a relational table to a single VARIANT column is ARRAY_AGG. ARRAY_AGG is an aggregation function that collects values from multiple rows into an array, which Snowflake then stores as a VARIANT data type. This allows the aggregation of row data into a single column with a VARIANT type.
D is correct. https://docs.snowflake.com/en/user-guide/data-unload-considerations