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

You May Also Like

Upgrade Your Workspace Now

AI-recommended products based on this video

Loading...
Small Standing Desk Adjustable Height, Mobile Stand Up Desk with Wheels, 32 Inch Portable Rolling Desks for Walking Pad Treadmill Wood Rustic

Small Standing Desk Adjustable Height, Mobile Stand Up Desk with Wheels, 32 Inch Portable Rolling Desks for Walking Pad Treadmill Wood Rustic

(1,020)
$92.99
FREE delivery Mon, Feb 16
Loading...
ERGOMAKER 55-inch Electric Standing Desk, Adjustable Height Stand Desk, Sit Stand Desk with Computer Workstation, Rustic Brown

ERGOMAKER 55-inch Electric Standing Desk, Adjustable Height Stand Desk, Sit Stand Desk with Computer Workstation, Rustic Brown

(369)
$199.99
FREE delivery Thu, Jun 26
Loading...
Portable Rolling Desk on Wheels Small Standing Desk Adjustable Height Desks with Wheels for Small Spaces, 32" Computer Desk with Storage Shelves for Home Office Study,Rustic

Portable Rolling Desk on Wheels Small Standing Desk Adjustable Height Desks with Wheels for Small Spaces, 32" Computer Desk with Storage Shelves for Home Office Study,Rustic

(25)
$89.99
FREE delivery Thu, Jun 26
200+ bought in past month
Loading...
SHW 55 x 28 Inches Electric Height Adjustable Standing Desk with Drawer and Memory Preset, 140 x 71 cm, Maple

SHW 55 x 28 Inches Electric Height Adjustable Standing Desk with Drawer and Memory Preset, 140 x 71 cm, Maple

(20,343)
$289.87
FREE delivery Thu, Jun 26
50+ bought in past month
Loading...
TP-Link USB WiFi Adapter for Desktop PC (Archer T3U Plus) - AC1300Mbps USB 3.0 WiFi Dual Band Network Adapter with 2.4GHz/5GHz High Gain Antenna, MU-MIMO, Windows 11/10/8.1/8/7/XP, Mac OS 10.9-10.15
Amazon's Choice

TP-Link USB WiFi Adapter for Desktop PC (Archer T3U Plus) - AC1300Mbps USB 3.0 WiFi Dual Band Network Adapter with 2.4GHz/5GHz High Gain Antenna, MU-MIMO, Windows 11/10/8.1/8/7/XP, Mac OS 10.9-10.15

(16,318)
$19.99$17.99
FREE delivery Sun, Jun 22 on your first order
1K+ bought in past month
Loading...
Dell E-Port Plus Advanced Port Replicator with USB 3.0 for E Series Latitudes, 130W AC

Dell E-Port Plus Advanced Port Replicator with USB 3.0 for E Series Latitudes, 130W AC

(557)
$97.87$55.29
$11.22 delivery Mon, Aug 25
Loading...
Monster Shock Plus Bluetooth Speaker,Portable Speaker with 30W Loud Stereo Sound, Bluetooth 6.0, TWS Pairing, 15H Playtime, Support AUX/TF Card, IPX6 Waterproof Wireless Speaker for Outdoor Home

Monster Shock Plus Bluetooth Speaker,Portable Speaker with 30W Loud Stereo Sound, Bluetooth 6.0, TWS Pairing, 15H Playtime, Support AUX/TF Card, IPX6 Waterproof Wireless Speaker for Outdoor Home

(13)
$39.98
FREE delivery Sat, Nov 22
Loading...
Monster Shock Plus Bluetooth Speaker, Portable Speaker with 30W Loud Stereo Sound, Bluetooth 5.4, TWS Pairing, 15H Playtime, Support AUX/TF Card, IPX6 Waterproof Wireless Speakers for Home Party

Monster Shock Plus Bluetooth Speaker, Portable Speaker with 30W Loud Stereo Sound, Bluetooth 5.4, TWS Pairing, 15H Playtime, Support AUX/TF Card, IPX6 Waterproof Wireless Speakers for Home Party

(12)
$199.99
FREE delivery Mon, Sep 1
Loading...
Small Standing Desk Adjustable Height, Mobile Stand Up Desk with Wheels, 32 Inch Portable Rolling Desks for Walking Pad Treadmill Wood Rustic

Small Standing Desk Adjustable Height, Mobile Stand Up Desk with Wheels, 32 Inch Portable Rolling Desks for Walking Pad Treadmill Wood Rustic

(1,020)
$92.99
FREE delivery Mon, Feb 16
Loading...
ERGOMAKER 55-inch Electric Standing Desk, Adjustable Height Stand Desk, Sit Stand Desk with Computer Workstation, Rustic Brown

ERGOMAKER 55-inch Electric Standing Desk, Adjustable Height Stand Desk, Sit Stand Desk with Computer Workstation, Rustic Brown

(369)
$199.99
FREE delivery Thu, Jun 26
Loading...
BEXEVUE Standing Desk, Height Adjustable Electric Desk, 48 x 24 Inches Adjustable Desk, Small Computer Home Office Desk with Splice Board (White)
Best Seller

BEXEVUE Standing Desk, Height Adjustable Electric Desk, 48 x 24 Inches Adjustable Desk, Small Computer Home Office Desk with Splice Board (White)

(268)
$149.99
FREE delivery Thu, Jun 26
200+ bought in past month
Loading...
Portable Rolling Desk on Wheels Small Standing Desk Adjustable Height Desks with Wheels for Small Spaces, 32" Computer Desk with Storage Shelves for Home Office Study,Rustic

Portable Rolling Desk on Wheels Small Standing Desk Adjustable Height Desks with Wheels for Small Spaces, 32" Computer Desk with Storage Shelves for Home Office Study,Rustic

(25)
$89.99
FREE delivery Thu, Jun 26
200+ bought in past month
Loading...
ZGEHCO Queen Bed Frame No Box Spring Need, 6 Inch Low Profile Bed Frame Queen Size Metal Platform Floor Bed Frames with Heavy Duty Steel Slats,Noise Free Mattress Foundation,Black Bed Base

ZGEHCO Queen Bed Frame No Box Spring Need, 6 Inch Low Profile Bed Frame Queen Size Metal Platform Floor Bed Frames with Heavy Duty Steel Slats,Noise Free Mattress Foundation,Black Bed Base

(3)
$129.99
FREE delivery Tue, Jun 17
Loading...
MSI MAG MT201D - Premium Heavy Duty Dual Monitor Stand Arms, 17-45" Support, VESA Compatible, Adjustable Spring Mount, 44 lbs per Screen, Clamp & Grommet, Quick Release Plate - Black

MSI MAG MT201D - Premium Heavy Duty Dual Monitor Stand Arms, 17-45" Support, VESA Compatible, Adjustable Spring Mount, 44 lbs per Screen, Clamp & Grommet, Quick Release Plate - Black

(168)
$124.99
FREE delivery Wed, Jan 14
50+ bought in past month
Loading...
VIVO 81cm Desk Converter, K Series, Height Adjustable Sit to Stand Riser, Dual Monitor and Laptop Workstation with Wide Keyboard Tray, Black, DESK-V000K

VIVO 81cm Desk Converter, K Series, Height Adjustable Sit to Stand Riser, Dual Monitor and Laptop Workstation with Wide Keyboard Tray, Black, DESK-V000K

(13,797)
$139.99$103.20
FREE delivery Thu, Jun 26
200+ bought in past month
Loading...
VIVO 15.6 inch Portable Monitor with Laptop Screen Extender Holder, Fits Laptops up to 18.5 inches, Black, STAND-PM01M

VIVO 15.6 inch Portable Monitor with Laptop Screen Extender Holder, Fits Laptops up to 18.5 inches, Black, STAND-PM01M

(13)
$169.99
FREE delivery Sun, Aug 10
Loading...
6-Pack + 1 Base Magnetic and Adhesive Cable Organizer - 8mm Slot for Phone, USB, HDMI, and Power Cords. Cable Clips Suitable for use on Office desks, Home Tables, nightstands, and in Cars (White).

6-Pack + 1 Base Magnetic and Adhesive Cable Organizer - 8mm Slot for Phone, USB, HDMI, and Power Cords. Cable Clips Suitable for use on Office desks, Home Tables, nightstands, and in Cars (White).

(47)
$9.59
FREE delivery Mon, Sep 1 on your first order
200+ bought in past month
Loading...
LED Desk Lamp with Dual Heads, Height Adjustable, USB Charging Port, 5 Light Modes & Dimmable Brightness, Bedside Lamp for Reading, Crafting, Work, Study (White, 15W)

LED Desk Lamp with Dual Heads, Height Adjustable, USB Charging Port, 5 Light Modes & Dimmable Brightness, Bedside Lamp for Reading, Crafting, Work, Study (White, 15W)

(3,090)
$20.99
FREE delivery Sat, Jun 14 on your first order
Loading...
Large Hydroponics Growing System 14 Pods, Indoor Herb Garden with LED Grow Light, 5L Water Tank, Hydroponic Grow Kit with 3 Auto-Timers, Rotatable Light Panel and Child Lock for Home School Gardening

Large Hydroponics Growing System 14 Pods, Indoor Herb Garden with LED Grow Light, 5L Water Tank, Hydroponic Grow Kit with 3 Auto-Timers, Rotatable Light Panel and Child Lock for Home School Gardening

(119)
$167.81
FREE delivery Jun 16 - 20
Loading...
iDOO 20Pods Indoor Herb Garden, LED Grow Light for Indoor Plant with 4 Removable Water Tank, Free Timing Setting Hydroponics Growing System, 26.77in Adjustable Height (Black)

iDOO 20Pods Indoor Herb Garden, LED Grow Light for Indoor Plant with 4 Removable Water Tank, Free Timing Setting Hydroponics Growing System, 26.77in Adjustable Height (Black)

(1,006)
$159.99
PrimeFREE delivery Sat, Jun 14
Loading...
Jhua Solar Fountain for Bird Bath Pump with Led Lights 3W Solar Powered Water Fountain Pump Kit with 7 Nozzles Floating Solar Water Fountain for Outdoor Garden Ponds Pool Fish Tank Aquarium

Jhua Solar Fountain for Bird Bath Pump with Led Lights 3W Solar Powered Water Fountain Pump Kit with 7 Nozzles Floating Solar Water Fountain for Outdoor Garden Ponds Pool Fish Tank Aquarium

(0)
$26.99
FREE delivery Sat, Jun 14 on your first order