Hello Team,
I want to transfer data from Source to Destination from Multiple tables .Is it possible to do in single copy activity.
Thanks in Advance
RK
Hello Team,
I want to transfer data from Source to Destination from Multiple tables .Is it possible to do in single copy activity.
Thanks in Advance
RK
Hello @RohitKulkarni-6062,
Just checking in to see if the below answer provided by @NandanHegde-7720 helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Hello @RohitKulkarni-6062,
Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.
Take care & stay safe!
Hey,
Yes.It is possible based on the combination of foreach and copy activity.
https://www.google.com/amp/s/www.modern-dataengineering.com/amp/how-to-copy-multiple-tables-in-azure-data-factory
This will be for whole tables in the schema.
Example. If there are 10 tables in One schema. I need to transfer the data only 6 tables then.
Thanks in advance
RK
Hey, you can create a parameter of type array with all the table names which you want to copy and use it in for each activity.
The above link is just a reference link ☺️
Hope this clarifies your query!
Hello Nandan,
I got clarified transferring data from Multiple tables.
If we upload multiple tables there will be impact on slow performance of uploading the data. So what is the best practice for the configuration of Azure SQL DB
example. How much it must be DTU.
Thanks in advance
Regards
RK
6 people are following this question.