What is the default character set used when loading CSV files into Snowflake?

The correct answer is A. UTF-8. For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).

Data Loading and Unloading

Question

Options

AUTF-8
BUTF-16
CISO S859-1
DANSI_X3.A

How the community answered

(37 responses)

A
76% (28)
B
8% (3)
C
14% (5)
D
3% (1)

Explanation

For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).

Topics

#CSV loading#character set#UTF-8

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice