Which configuration of the function PARSE_JSON( [expr] ) will retrieve a valid SQL NULL value?
Which configuration of the function PARSE_JSON( [expr] ) will retrieve a valid SQL NULL value?
If the input is NULL, the output is also NULL. However, if the input string is 'null', then it is interpreted as a JSON null value so that the result isn’t SQL NULL, but instead a valid VARIANT value containing null https://docs.snowflake.com/en/sql-reference/functions/parse_json
Tried in Snowflake myself: select NULL, parse_json(NULL);