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
11 months agoClaribel
9 months agoJolanda
9 months agoThora
9 months agoRoslyn
11 months agoLavonna
10 months agoArt
10 months agoKara
11 months agoMalcom
11 months agoRory
11 months agoAlease
11 months agoLeatha
11 months agoCyril
11 months agoDiane
12 months agoMammie
12 months agoLeslie
12 months agoRosita
11 months agoDusti
11 months agoJesus
11 months agoMoon
12 months agoWilford
12 months ago