What is the default File Format used in the COPY command if one is not specified?

The correct answer is A. CSV. CSV (Comma-Separated Values) is the default file format for Snowflake's COPY INTO command when no FILE_FORMAT option is specified. If you run COPY INTO <table> FROM @<stage> without specifying a format, Snowflake assumes the files are CSV with default delimiters…

Data Loading and Unloading

Question

Options

ACSV
BJSON
CParquet
DXML

How the community answered

(54 responses)

A
87% (47)
B
2% (1)
C
4% (2)
D
7% (4)

Explanation

CSV (Comma-Separated Values) is the default file format for Snowflake's COPY INTO command when no FILE_FORMAT option is specified. If you run COPY INTO <table> FROM @<stage> without specifying a format, Snowflake assumes the files are CSV with default delimiters (comma-separated, newline-terminated records). To load JSON, Parquet, XML, or other formats, you must explicitly specify FILE_FORMAT = (TYPE = 'JSON') or reference a named file format object. This default behavior makes CSV the simplest format to load without additional configuration.

Topics

#COPY command#File formats#Default behavior#Data loading

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice