Azure Data Factory | Copy multiple tables in Bulk with Lookup & ForEach

With Azure Data Factory Lookup and ForEach activities you can perform dynamic copies of your data tables in bulk within a single pipeline.

In this episode I will show you how to perform bulk copies with ADF.

In this episode live demo of ADF lookup activity in SQL to Blob export scenario and how to control this using metadata table.

Next steps for you after watching the video
1. ADF bulk copy scenario
2. Lookup Activity docs
3. ForEach Activity docs

### Want to connect?

[rapchak]

Cannot thank you enough for your incredibly well laid out, thorough explanations. The world needs more folks like you :)

[quyenpn]

I really really like how you guide step by step like this, it is quite easy to understand. You are the best “trainner” I’ve seen, really appreciated for your time on creating those useful videos.

[albertoarellano]

You're the best Adam! Thanks for all the help, been watching your tutorials on ADF and they're very helpful. Keep them coming!

[satishutnal]

You are the example for how teaching should be. Just awesome 👍

[genniferlyon]

Thank you Adam! I had been trying to follow some other written content to do exactly what you showed with no success. Your precise steps and explanation of the process were so helpful. I am successful now.

[ahmedroberts]

Excellent, Excellent video. This has truly cemented the concepts and processes you are explaining in my brain. You are awesome, Adam!

[apogeeaor]

Thank you, Adam. I rewatch this video at least twice a year, Thank you for all you do.

[shaileshsondawale]

What a wonderful content you have place in social media.. What a world class personality you... People certainly fall in love with your teaching..

[markdransfield]

Brilliant teaching style Adam. Very watchable. I particularly like how you explain the background. I've subscribed and will watch more of your videos.

[gunturulaxmi]

Videos are very much clear to the people who would like to learn and practice.Thanks alot.your hard work is appreciated.

[rajanarora]

Awesome explanation, the way you teach assuming in layman terms is pretty great, thanks!!

[pratibhaverma]

Your videos are great. This is the best channel on Youtube platform to learn about ADF. THANKS 🙏😊

[hollmanalu]

Adam, thanks for all your great video's! I appreciate your work very much! Keep up your great work!

[AVADHKISHORE]

Thank you Adam!! These videos are really very helpful and builds the foundation to understand ADF.

[elisehunter]

Brilliant tutorial. Easy to follow and it all works like a charm. Thank you!!

[priyankapatel]

You have depth knowledge in every service. I learn from scratch using your channel. Keep posting Thanks you and God bless you.

[maimemphahlele]

Hi Adam

Ur videos are just too brilliant. This is subscription I wouldn’t mind paying to support. Ur lessons are invaluable to learning.

[anacarrizo]

THANK YOU SO MUCH for this! The step-by-step really helped with what I needed to do.

[deoroopnarine]

Your videos are awesome man. Gave me a firm grasp and encouraged me to get an azure subscription and play around some more.

[anderschristoffersen]

Great and simple walk through, good job Adam