When unloading data to an external stage, what is the MAXIMUM file size supported?

The correct answer is B. 5 GB. When using the COPY INTO <location> command to unload data to an external stage (e.g., Amazon S3, Azure Blob Storage, or Google Cloud Storage), the maximum individual file size Snowflake supports is 5 GB. This limit is driven by the underlying cloud storage provider's…

Data Loading and Unloading

Question

Options

A1 GB
B5 GB
C10 GB
D16 GB

How the community answered

(50 responses)

A
2% (1)
B
92% (46)
C
4% (2)
D
2% (1)

Explanation

When using the COPY INTO <location> command to unload data to an external stage (e.g., Amazon S3, Azure Blob Storage, or Google Cloud Storage), the maximum individual file size Snowflake supports is 5 GB. This limit is driven by the underlying cloud storage provider's single-part upload constraints. To manage large datasets, Snowflake supports the MAX_FILE_SIZE parameter to split output into multiple files, each under the 5 GB limit.

Topics

#Data Unloading#External Stage#File Size Limit

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice