To convert JSON null value to SQL null value, you will use

To convert JSON null value to SQL null value, you will use
A . STRIP_NULL_VALUE
B. IS_NULL_VALUE
C. NULL_IF

View Answer

Answer: A

Explanation:

STRIP_NULL_VALUE

Converts a JSON “null” value to a SQL NULL value. All other variant values are passed unchanged.

Please remember this is semi structured data function and is different from the STRIP_NULL_VALUES = TRUE | FALSE used during loading data into table from stage

Also, please try the below hands-on exercise

create or replace table mytable

(

src variant

);

insert into mytable

select parse_json(column1)

from values

(‘{

"a": "1",

"b": "2",

"c": null

}’)

, (‘{ "a": "1", "b": "2", "c": "3" }’);

select strip_null_value(src:c) from mytable;

https://docs.snowflake.com/en/sql-reference/functions/strip_null_value.html#strip-null-value