True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
A . True
B . False

View Answer

Answer: B

Explanation:

Snowflake does not require source data files to be no larger than 16MB. In fact, Snowflake recommends that for optimal load performance, data files should be roughly 100-250 MB in size when compressed. However, it is not recommended to load very large files (e.g., 100 GB or larger) due to potential delays and wasted credits if errors occur. Smaller files should be aggregated to minimize processing overhead, and larger files should be split to distribute the load among compute resources in an active warehouse.

Reference: Preparing your data files | Snowflake Documentation