Q: 2
What is the default character set used when loading CSV files into Snowflake?
Options
Discussion
B had something like this in a mock. Not totally sure but I recall UTF-16 being set by default sometimes for CSVs.
Not B, it's A. Snowflake loads CSVs as UTF-8 unless you specify a different encoding in the file format. Saw this in the docs and on practice tests too, but happy to be corrected if I'm missing a corner case.
Probably A since Snowflake defaults to UTF-8 when loading CSV files, unless you set a different encoding in your file format. Seen this in the docs and matches what I’ve used before, but let me know if anyone’s run into something else.
A
B makes sense too if you consider some systems export CSVs as UTF-16 by default, so not sure it’s always A unless docs say otherwise. Anyone else see B used as a default in practice?
A tbh
Option A is right, it's UTF-8 by default for CSV loads into Snowflake. Pretty standard for handling various languages and symbols out of the box. Don't think any of the others are even supported as defaults. Let me know if anyone's seen different behavior though.
A all the way, default is UTF-8 for CSV loads. Saw this in docs and pretty sure most practice tests mention it. If you're reviewing, check the official Snowflake guide and try loading a sample file in lab to confirm.
A
B. not sure since I remember some CSV tools export UTF-16 by default unless specified otherwise.
Be respectful. No spam.
