Copy Activity

Rohit Kulkarni 731

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

PRADEEPCHEEKATLA 91,866 Reputation points

2021-05-20T12:08:31.597+00:00

Hello @Rohit Kulkarni ,
Just checking in to see if the below answer provided by @Nandan Hegde 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.
PRADEEPCHEEKATLA 91,866 Reputation points

2021-05-21T10:04:26.013+00:00

Hello @Rohit Kulkarni ,

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!

1 answer

Nandan Hegde 36,886 Reputation points MVP Volunteer Moderator

2021-05-17T15:34:05.877+00:00

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
Was this answer helpful?
Rohit Kulkarni 731 Reputation points

2021-05-17T17:10:05.45+00:00

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

Nandan Hegde 36,886 Reputation points MVP Volunteer Moderator

2021-05-17T17:42:33.51+00:00

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!

Rohit Kulkarni 731 Reputation points

2021-05-18T07:15:22.033+00:00

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

Nandan Hegde 36,886 Reputation points MVP Volunteer Moderator

2021-05-18T16:26:54.613+00:00

Hey, there are multiple factors that needs to be considered:
The amount of data or whether the data load is sequential or parallel or whether it is a partial load or SCD etc.
So there is no exact configuration mapping but it is build/upgrade as you see any performance issues. This is the benefit of Azure Paas.

Please upvote and mark it as answer if the answer was helpful.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer