We recommend files at least above 10 MB on average, with files in the 100 to 250 MB range offering the best cost-to-performance ratio.
https://www.snowflake.com/blog/best-practices-for-data-ingestion
To optimize the number of parallel operations for a load, we recommend aiming to produce data files roughly 100MB to 250MB in size, compressed. Splitting large files into a greater number of smaller files distributes the load among the servers in an active warehouse and increases performance.
https://community.snowflake.com/s/article/faq-does-snowflake-have-a-recommended-file-size-for-loading
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Mallikharjuna452
4 months ago_yyukta
8 months, 4 weeks agoMultiCloudIronMan
1 year, 4 months agoEmiB
1 year, 8 months agonewbie2020
2 years ago