What is the recommended file sizing for data loading using Snowpipe?

The correct answer is C. A compressed file size greater than 10 MB, and up to 100 MB. Snowflake recommends that files loaded via Snowpipe be between 10 MB and 100 MB in compressed size. Files in this range balance the overhead cost of initiating a Snowpipe load (which spins up serverless compute) against the throughput benefit of loading larger batches. Files…

Data Loading and Unloading

Question

Options

AA compressed file size greater than 100 MB, and up to 250 MB
BA compressed file size greater than 100 GB, and up to 250 GB
CA compressed file size greater than 10 MB, and up to 100 MB
DA compressed file size greater than 1 GB, and up to 2 GB

How the community answered

(28 responses)

A
7% (2)
B
4% (1)
C
86% (24)
D
4% (1)

Explanation

Snowflake recommends that files loaded via Snowpipe be between 10 MB and 100 MB in compressed size. Files in this range balance the overhead cost of initiating a Snowpipe load (which spins up serverless compute) against the throughput benefit of loading larger batches. Files smaller than 10 MB result in high per-file overhead relative to data volume. Files larger than 100 MB are better suited for bulk loading with COPY INTO rather than continuous micro-batch loading with Snowpipe. Options A, B, and D all have incorrect size thresholds.

Topics

#Snowpipe#Data loading#File sizing#Best practices

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice