What is the purpose of the STRIP_NULL_VALUES file format option when loading semi-structured data files into Snowflake?
What is the purpose of the STRIP_NULL_VALUES file format option when loading semi-structured data files into Snowflake?
The STRIP_NULL_VALUES file format option in Snowflake is used to remove elements containing null values from objects or arrays when loading semi-structured data files. This ensures that any object or array elements that contain null values are stripped out during the loading process.
"This option removes OBJECT elements or ARRAY elements containing “null” values."
Alternatively, if the “null” values in your files indicate missing values and have no other special meaning, we recommend setting the file format option STRIP_NULL_VALUES to TRUE when you load the semi-structured data files. This option removes OBJECT elements or ARRAY elements containing “null” values. https://docs.snowflake.com/en/user-guide/semistructured-considerations#label-variant-null