What is the recommended compressed file size range for continuous data loads using Snowpipe?

The correct answer is D. 100-250 MB. Snowflake recommends that files staged for continuous loading via Snowpipe be between 100 MB and 250 MB in compressed size. This range balances ingestion latency and throughput efficiency. Files that are too small cause excessive overhead from frequent micro-partition…

Data Loading and Unloading

Question

Options

A8-16 MB
B16-24 MB
C10-99 MB
D100-250 MB

How the community answered

(19 responses)

B
5% (1)
C
5% (1)
D
89% (17)

Explanation

Snowflake recommends that files staged for continuous loading via Snowpipe be between 100 MB and 250 MB in compressed size. This range balances ingestion latency and throughput efficiency. Files that are too small cause excessive overhead from frequent micro-partition operations, while files that are too large delay the availability of data. Staying in the 100–250 MB range ensures Snowpipe can process data incrementally and efficiently without excessive resource consumption.

Topics

#Snowpipe#Continuous Data Loading#File Size Best Practices#Performance Optimization

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice