What is the default file size when unloading data from Snowflake using the COPY command?

The correct answer is C. 16 MB. When using the COPY INTO <location> command to unload data to a stage, Snowflake splits the output into multiple files with a default maximum size of 16 MB per file. This behavior can be overridden using the MAX_FILE_SIZE parameter to produce larger or smaller files as needed…

Data Loading and Unloading

Question

Options

A5 MB
B8 GB
C16 MB
D32 MB

How the community answered

(16 responses)

A
6% (1)
C
88% (14)
D
6% (1)

Explanation

When using the COPY INTO <location> command to unload data to a stage, Snowflake splits the output into multiple files with a default maximum size of 16 MB per file. This behavior can be overridden using the MAX_FILE_SIZE parameter to produce larger or smaller files as needed. The 16 MB default is designed to facilitate efficient parallel uploads and downstream processing.

Topics

#COPY command#Data unloading#File size#Default settings

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice