When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

The correct answer is B. 100-250 MB. Snowflake recommends a compressed file size of 100–250 MB per file when using Snowpipe for continuous data ingestion. This range balances parallelism and efficiency: files that are too small (e.g., 10–50 MB) result in excessive overhead from managing many small files and…

Data Loading and Unloading

Question

Options

A10-50 MB
B100-250 MB
C300-500 MB
D1000-1500 MB

How the community answered

(46 responses)

A
2% (1)
B
87% (40)
C
9% (4)
D
2% (1)

Explanation

Snowflake recommends a compressed file size of 100–250 MB per file when using Snowpipe for continuous data ingestion. This range balances parallelism and efficiency: files that are too small (e.g., 10–50 MB) result in excessive overhead from managing many small files and underutilize Snowpipe's parallelism, while files that are too large (e.g., 300–500 MB or larger) take longer to process and reduce throughput. The 100–250 MB range optimizes ingestion speed, cost, and Snowpipe queue efficiency. This recommendation aligns with Snowflake's broader best practice for staged file sizes during bulk loading as well.

Topics

#Snowpipe#Data Loading#File Size#Best Practices

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice