Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
The Snowflake function that interprets an input string as a JSON document and produces a VARIANT value is parse_json(). This function takes a string containing JSON data and converts it into a VARIANT data type, which can store semi-structured data.
https://docs.snowflake.com/en/sql-reference/functions/parse_json.html
The correct answer is A
This should A for sure
Was on exam Dec 31st 2022
The correct answer is A.
parse_json
Interprets an input string as a JSON document, producing a VARIANT value. Syntax PARSE_JSON( <expr> )
A is correct
A is the answer. https://docs.snowflake.com/en/sql-reference/functions/parse_json
correct
A parse_json()
Correct Answer: B
Correct Answer: A
parse_json()