Free Preparation Discussions
MENU
Snowflake Exam ARA-R01 Topic 4 Question 16 Discussion
Topic #: 4
An Architect has designed a data pipeline that Is receiving small CSV files from multiple sources. All of the files are landing in one location. Specific files are filtered for loading into Snowflake tables using the copy command. The loading performance is poor.
What changes can be made to Improve the data loading performance?
According to the Snowflake documentation, the data loading performance can be improved by following some best practices and guidelines for preparing and staging the data files. One of the recommendations is to aim for data files that are roughly 100-250 MB (or larger) in size compressed, as this will optimize the number of parallel operations for a load. Smaller files should be aggregated and larger files should be split to achieve this size range. Another recommendation is to use a multi-cluster warehouse for loading, as this will allow for scaling up or out the compute resources depending on the load demand. A single-cluster warehouse may not be able to handle the load concurrency and throughput efficiently. Therefore, by creating a multi-cluster warehouse and merging smaller files to create bigger files, the data loading performance can be improved.Reference:
Shayne
2 months agoClaribel
1 months agoJolanda
1 months agoThora
1 months agoRoslyn
2 months agoLavonna
2 months agoArt
2 months agoKara
2 months agoMalcom
3 months agoRory
2 months agoAlease
2 months agoLeatha
2 months agoCyril
3 months agoDiane
3 months agoMammie
3 months agoLeslie
3 months agoRosita
3 months agoDusti
3 months agoJesus
3 months agoMoon
4 months agoWilford
4 months ago