Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?
Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?
The function that interprets an input string as a JSON document, producing a VARIANT value, is PARSE_JSON. This function is specifically designed to convert JSON string data into Snowflake's VARIANT type, which can hold semi-structured data.
PARSE_JSON Interprets an input string as a JSON document, producing a VARIANT value.
A https://docs.snowflake.com/en/sql-reference/functions/parse_json