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

Highlight

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

Intro

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

Source code for demos: https://github.com/MarczakIO/azure4everyone-samples/tree/master/azure-data-factory-lookup-activity

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

Video

Next steps for you after watching the video

ADF bulk copy scenario
- https://docs.microsoft.com/en-us/azure/data-factory/tutorial-bulk-copy-portal?WT.mc_id=AZ-MVP-5003556
Lookup Activity docs
- https://docs.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity?WT.mc_id=AZ-MVP-5003556
ForEach Activity docs
- https://docs.microsoft.com/en-us/azure/data-factory/control-flow-for-each-activity?WT.mc_id=AZ-MVP-5003556

Adam Marczak

Programmer, architect, trainer, blogger, evangelist are just a few of many titles. What I really am, is a passionate technology enthusiast. I take great pleasure in learning new technologies and finding ways in which it can aid people every day. My latest passion is running an Azure 4 Everyone YouTube channel, where I show that Azure really is for everyone!