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

Adam Marczak - Azure for Everyone April 21, 2020
Video Thumbnail
Adam Marczak - Azure for Everyone Logo

Adam Marczak - Azure for Everyone

@adammarczakyt

About

No channel description available.

Video Description

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. 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. Next steps for you after watching the video 1. ADF bulk copy scenario - https://docs.microsoft.com/en-us/azure/data-factory/tutorial-bulk-copy-portal?WT.mc_id=AZ-MVP-5003556 2. Lookup Activity docs - https://docs.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity?WT.mc_id=AZ-MVP-5003556 3. ForEach Activity docs - https://docs.microsoft.com/en-us/azure/data-factory/control-flow-for-each-activity?WT.mc_id=AZ-MVP-5003556 ### Want to connect? - Blog https://marczak.io/ - Twitter https://twitter.com/MarczakIO - Facebook https://www.facebook.com/MarczakIO - LinkedIn https://www.linkedin.com/in/adam-marczak/ - Site https://azure4everyone.com

Upgrade Your Workspace Now

AI-recommended products based on this video

Loading...
CAHAYA Portable Sheet Music Stand: Dual Use Desktop Book Holder Folding Lightweight Extra Stable Reinforced with Carrying Bag and Clip for Students Musicians Height Adjustable up to 54.3" CMS0204
Best Seller

CAHAYA Portable Sheet Music Stand: Dual Use Desktop Book Holder Folding Lightweight Extra Stable Reinforced with Carrying Bag and Clip for Students Musicians Height Adjustable up to 54.3" CMS0204

(13,595)
$14.99$14.84
FREE delivery Thu, Sep 4 on $35 of items shipped by Amazon
5K+ bought in past month
Loading...
Husky Liners Weatherbeater Floor Mats | Fits Various 2007-2014 Cadillac Escalade & ESV, GMC Yukon, Chevrolet Suburban 1500, Tahoe, Silverado/Sierra (See Description) | Front Row, 2-pc Tan - 18203

Husky Liners Weatherbeater Floor Mats | Fits Various 2007-2014 Cadillac Escalade & ESV, GMC Yukon, Chevrolet Suburban 1500, Tahoe, Silverado/Sierra (See Description) | Front Row, 2-pc Tan - 18203

(110)
80.99
PrimeFREE delivery Saturday, June 14
Loading...
ZealSound Gaming Microphone Kit,Podcast Condenser USB Mic with Boom Arm,Supercardioid Microphone with Mute Button,Echo Volume Gain Knob,Adjust Monitor for Phone PC Computer (Black)

ZealSound Gaming Microphone Kit,Podcast Condenser USB Mic with Boom Arm,Supercardioid Microphone with Mute Button,Echo Volume Gain Knob,Adjust Monitor for Phone PC Computer (Black)

(770)
41.99
PrimeFREE delivery Saturday, June 14
200+ bought in past month
Loading...
100 Pcs Nylon Universal Cable Tie Buckle - New Multifunctional Nylon Zip Ties With Pin & Button Design Plastic Cable Ties Tool Fasteners Car Body UV Resistant Zipties for Car Daily Repair Bumper Clips

100 Pcs Nylon Universal Cable Tie Buckle - New Multifunctional Nylon Zip Ties With Pin & Button Design Plastic Cable Ties Tool Fasteners Car Body UV Resistant Zipties for Car Daily Repair Bumper Clips

(294)
$8.89
FREE delivery Fri, Oct 3 on $35 of items shipped by Amazon
6K+ bought in past month
Loading...
Ozeino Gaming Headset for PC, Ps4, Ps5, Xbox Headset with 7.1 Surround Sound Gaming Headphones with Noise Canceling Mic, LED Light Over Ear Headphones for Switch, Xbox Series X/S, Laptop, Mobile White

Ozeino Gaming Headset for PC, Ps4, Ps5, Xbox Headset with 7.1 Surround Sound Gaming Headphones with Noise Canceling Mic, LED Light Over Ear Headphones for Switch, Xbox Series X/S, Laptop, Mobile White

(26,227)
$16.14
FREE delivery Sat, Nov 29 on $35 of items shipped by Amazon
7K+ bought in past month
Loading...
6-Pack A19 LED Light Bulbs,60 Watt Equivalent Daylight 5000K with E26 Base,Efficient 9W,800 Lumens Non-Dimmable LED Bulbs,15000 Hours, Ideal for Bedroom Living Room

6-Pack A19 LED Light Bulbs,60 Watt Equivalent Daylight 5000K with E26 Base,Efficient 9W,800 Lumens Non-Dimmable LED Bulbs,15000 Hours, Ideal for Bedroom Living Room

(2,127)
$7.89
FREE delivery Fri, Nov 14 on $35 of items shipped by Amazon
10K+ bought in past month
Loading...
LIGHTAILING Light for Lego-75379 R2-D2 - Led Lighting Kit Compatible with Lego Building Blocks Model - NOT Included The Model Set

LIGHTAILING Light for Lego-75379 R2-D2 - Led Lighting Kit Compatible with Lego Building Blocks Model - NOT Included The Model Set

(27)
22.94
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35