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: C

Explanation:

The NULL_IF function in Snowflake is used to compare two expressions, and if they are equivalent, a SQL NULL value is returned. However, when dealing with JSON data and the goal is to convert JSON null values to SQL NULL values during ingestion, you would use the STRIP_NULL_VALUE file format option. This option can be set when creating or altering a file format used for loading JSON data, and it will remove JSON fields with null values from the ingested data, effectively treating them as SQL NULL values.