What is the only supported character set for loading and unloading data from all supported file formats?
What is the only supported character set for loading and unloading data from all supported file formats?
UTF-8 is the only supported character set for loading and unloading data from all supported file formats. It is a widely-used encoding that can represent any character in the Unicode standard and is compatible with many systems and protocols. Thus, it is the universal choice for data interchange.
For loading data from delimited files (CSV, TSV, etc.), UTF-8 is the default. For loading data from all other supported file formats (JSON, Avro, etc.), as well as unloading data, UTF-8 is the only supported character set.
A. https://docs.snowflake.com/en/sql-reference/sql/create-file-format