What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?
What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?
When creating a CSV file format where the columns are wrapped by single quotes or double quotes, the correct option to use is FIELD_OPTIONALLY_ENCLOSED_BY. This option specifies a character that optionally encloses fields. If this option is set, fields may be enclosed by the character specified.
C correct Leave string fields unenclosed by setting the FIELD_OPTIONALLY_ENCLOSED_BY option to NONE (default) https://docs.snowflake.com/en/user-guide/data-unload-considerations#empty-strings-and-null-values
C correct - https://community.snowflake.com/s/article/Escaping-double-quotes-from-source-file