Which function should be used to insert JSON formatted string data into a VARIANT field?
Which function should be used to insert JSON formatted string data into a VARIANT field?
To insert JSON formatted string data into a VARIANT field, the TO_VARIANT function should be used. This function explicitly converts data, including JSON, to the VARIANT data type, which can store semi-structured data such as JSON, XML, Avro, etc.
The correct answer is C. PARSE_JSON https://docs.snowflake.com/en/sql-reference/functions/parse_json
C correct - https://docs.snowflake.com/en/sql-reference/functions/to_json
correct link - https://docs.snowflake.com/en/sql-reference/functions/parse_json