What function should be used to convert JSON NULL values to SQL NULL values when loading data into a Snowflake table?
What function should be used to convert JSON NULL values to SQL NULL values when loading data into a Snowflake table?
B is correct
When loading JSON data into a Snowflake table, the PARSE_JSON function can be used to convert JSON NULL values to SQL NULL values. This function parses a string containing JSON data into a Snowflake JSON data type (VARIANT). During this parsing process, JSON null values are interpreted as SQL NULL values.
SELECT STRIP_NULL_VALUE(PARSE_JSON('{"a": 1, "b": null, "c": "value"}'));