COF-C02 · Question #659
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
The correct answer is B. False. 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…
Question
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
Options
- ATrue
- BFalse
How the community answered
(39 responses)- A5% (2)
- B95% (37)
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.
Topics
Community Discussion
No community discussion yet for this question.