When unloading the data for file format type specified (TYPE = 'CSV'), SQL NULL can be converted to string ‘null’ using which file format option?
When unloading the data for file format type specified (TYPE = 'CSV'), SQL NULL can be converted to string ‘null’ using which file format option?
The correct file format option to convert SQL NULL to the string 'null' when unloading data in CSV format is NULL_IF. This option specifies which string sequences should be interpreted as NULL when loading or unloading data, allowing 'null' to be used as a representation of SQL NULL.
C correct NULL_IF https://docs.snowflake.com/en/user-guide/data-unload-considerations#empty-strings-and-null-values
C correct - https://docs.snowflake.com/en/user-guide/data-unload-considerations