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

What is the recommended file sizing for data loading using Snowpipe?
A . A compressed file size greater than 100 MB, and up to 250 MB
B . A compressed file size greater than 100 GB, and up to 250 GB
C . A compressed file size greater than 10 MB, and up to 100 MB
D . A compressed file size greater than 1 GB, and up to 2 GB

View Answer

Answer: C

Explanation:

For data loading using Snowpipe, the recommended file size is a compressed file greater than 10 MB and up to 100 MB. This size range is optimal for Snowpipe’s continuous, micro-batch loading process, allowing for efficient and timely data ingestion without overwhelming the system with files that are too large or too small.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Snowpipe1