Azure Data Factory Parametrization Tutorial

Parametrization in Azure Data Factory is essential to achieve good design and reusability as well as low cost of solution maintenance. Using parameters also speeds up implementation of new features in your pipelines.
In this video I will cover basics of Data Factory Parametrization using common Blob to SQL loading scenario.
Source: github.com/MarczakIO/azure4ev...
Want to connect?
- Blog marczak.io/
- Twitter / marczakio
- Facebook / marczakio
- LinkedIn / adam-marczak
- Site azure4everyone.com
more to come..
Next steps for you after watching the video
1. Check data factory docs docs.microsoft.com/en-us/azur...
2. Linked service parametrization example
docs.microsoft.com/en-us/azur...
3. System variables
docs.microsoft.com/en-us/azur...
See you next time!

[@raviv5109]

Are you real? You really explain and show demo in such a flawless manner. Thanks you so much, your Azure videos are happy at every step.

[@AdamMarczakYT]

Thank you so much :)

[@rajdeepmandal1470]

The quarantine days wouldn't be this useful without your teaching :) thank you Adam. You are the best!!!

[@AdamMarczakYT]

Wow, thank you! :)

[@nikhilpatil2021]

Thank you Adam, this is the best tutorial on Azure Data Factory I have seen! I am definitely going to try these demos. Thank you!

[@AdamMarczakYT]

Great to hear! Cheers!

[@tatianebrandao5487]

I'm just starting with Synapse/DF and I found your video extremely helpful for beginners. I managed to go through your video, complete the exercise on my own and everything made so much sense! Your way of explaining is very clear! Thank you very much for creating the video :)

[@nicholasgregory4774]

Another great one Adam, consider me a new student! Short enough in length while fitting all the relevant information in + easy to digest, without overly complicating things. Your PowerPoints with your explanations are second to none.

[@AdamMarczakYT]

Awesome, thank you!

[@eerosiljander4622]

Thanks Adam for these hands on videos. Best wishes,ES, Data engineer & Scientist.

[@nupoorsingh3323]

It's great support for people like me who do not have a mentor. Thanks for uploading these videos and helping me to understand the workflow and survive.

[@carl33p]

Demos are the best way to learn, and your demo is as good as it gets. Build, run, build, run- the incremental style allows viewer to understand slowly.

[@AdamMarczakYT]

Couldn't agree more! Thanks!

[@johnd3601]

Thanks this is a big help, its amazing how much you don't know you know. This has opened up a lot of possible automation and saved me loads of time once I manage to apply this to my situation.

[@ghay3]

My goto UA-cam channel for anything Azure - you are doing the greatest service by sharing your knowledge and responding to all the queries! many thanks, Adam. Hope you can also enlighten the community on AWS :)

[@AdamMarczakYT]

Wow, thank you! glad to help!

[@lehai9172]

Fantastic tutorials, I've learned a lot from your videos. Thank you for sharing your experiences, Adam.

[@AdamMarczakYT]

My pleasure!

[@santanughosal9785]

Awesome, simple and hands on video to understand the concept. Thank you

[@barryjohnson8915]

Really excellent tutorials. Very simply explained, easy to follow, fantastic stuff.

[@AdamMarczakYT]

Thanks Barry :) Glad to have you here.

[@mashagalitskaia8642]

Thanks a ton for this video! It helped me a lot. Very precise and detailed, I had no questions left:)

[@joshiabhinav]

Man you are awesome. you present so well and explain so well. Love the way you teach !

[@AdamMarczakYT]

I appreciate that!

[@sankaji20]

You are doing great job ADAM, 20-30 minutes videos of your's is equal to 60minuts of others. And quality of your vdo is un match-able. Now I am GCP guy but also very much interested in learning azure from your videos only.. keep uploading azure videos. Thanks so much.. doing wonderful job for learners.. you will get a lot of blessings.. Thumbs-up for you..

[@AdamMarczakYT]

Wow, thanks! Appreciated!

[@mayur6816]

Thanks, Adam. This is the best tutorial on ADF.

[@AdamMarczakYT]

Glad you think so! Thanks!

[@IntelliCloudTech]

Clearly explained at every point. thanks for the video.

[@iChrisBirch]

Great tutorial, answered my questions as I had them, great logical flow.

[@TeymurRzayev]

Actually liked it before watching the video ;) Brilliant content, perfect explanation!

[@SuperSanjays]

Great information you have shared Adam. It helps me a lot.

[@igiq]

Keep it up Adam, your videos are very helpful !

[@AdamMarczakYT]

Thanks! will do!

[@ashishjuneja6574]

Super awesome !! Great going Adam.

[@eatingnetwork6474]

great video, once again very clear and concise, thanks Adam

[@AdamMarczakYT]

Thanks 👍

[@checomax1980]

Thank you Adam,
Excellent tutorial.

[@AdamMarczakYT]

Glad you enjoyed it!

[@srinivasreddysankasani5140]

Thank you Adam for your videos. your explanation is really awesome. looking for more videos

[@AdamMarczakYT]

Glad you like them!

[@jagadishparale8632]

Hey Adam,It was excellent tutorial.I would like you to do more videos on deployment of Azure Data Factory pipelines when we use parameters

[@AdamMarczakYT]

Thanks! You are in luck, new video tomorrow is also on ADF, stay tuned!

[@sraoarjun]

One word - FANTASTIC !! ... Thank you Adam , keep up the good work in educating several people .Also request you to put some videos on Synapse analytics ...

[@AdamMarczakYT]

Thanks! Will do!

[@sazidaanjumsheikh6817]

Thank you Adam, in a very short video you made me understand the ADF with a demo instead of Theory.. Nice content... :-)

[@arnabmondal5596]

Awesome clip. Currently, better content than many available now.

[@AdamMarczakYT]

Thank you so much :) glad that you enjoyed it.

[@dabay200]

This is a really amazing video, so much better than Microsoft's tutorials.

[@AdamMarczakYT]

Thanks again Dinal. You are too kind :).

[@angelamessina7187]

Thanks a lot Adam this will be realy helpful for my today's task. Be blessed

[@AdamMarczakYT]

Great! Thanks Angela, stay safe!

[@jayong2370]

Awesome tutorial! Thank you.

[@MarkDiamond]

Excellent content, thank you so much for the effort!

[@docondelta]

This is really amazing tutorial .. Thank you

[@AdamMarczakYT]

Cheers! Always happy to help!

[@baladenmark]

Wow. Thank you Adam. I really can't thank you enough.

[@AdamMarczakYT]

Glad I could help!

[@snmailist1470]

Thank you Adam. I'm very appreciate your effort 👍👍👍👍
You give me a description what's going on the cloud.

[@AdamMarczakYT]

Glad to hear it , thank you!

[@asrarhaq3234]

Wonderful - practical and useful- Thank you

[@AdamMarczakYT]

Thanks! Glad you like it.

[@kalangarahouse]

nice tutorial...please continue making such videos

[@venkataramakrishnamagapu7645]

Excellent content. Simple and informative.

[@AdamMarczakYT]

Much appreciated!

[@fsfehico]

Very well structured content. Thank you

[@AdamMarczakYT]

Thank you, glad you enjoy it :)

[@joseantonioestebanrodrigue448]

Perfect explanation!

[@pavankumar-nm9yu]

Thank You Adam, Amazing Explanation...!!!

[@AdamMarczakYT]

My pleasure!

[@ricardorocha7882]

Simplesmente incrível esse vídeo. Vai me ajudar bastante.

[@soumenchandra7633]

What a fascinating presentation !!!

[@AdamMarczakYT]

Thank you! :)

[@Bubu020174]

Thank u so much to you that you have share this valuable information !

[@sagarnegi]

Great explanation. I understood everything.

[@AdamMarczakYT]

Excellent

[@BojackCartman]

nice tutorial, very clear and concise

[@AdamMarczakYT]

Glad you think so!

[@malayku8781]

Very nicely explained Adam!

[@AdamMarczakYT]

Thank you kindly! :)

[@GhernieM]

Thanks Adam! Very helpful

[@AdamMarczakYT]

My pleasure!

[@vishwanathr3507]

Hi Adam
Thank you for excellent Tutorial and your time. Good luck
Cheers!
Vishwanath

[@AdamMarczakYT]

Glad you liked it! :)

[@jayantKadam100]

This is really wonderful tutorial and very useful thanks

[@AdamMarczakYT]

Thank you! :)

[@MrVoltelen]

Thanks for the great explanation

[@AdamMarczakYT]

My pleasure!

[@oscararmandocisnerosruvalc8503]

Your videos are amazing bro !!!!!

[@ambrishl9273]

Thanks a lot, This was very helpful!!!

[@AdamMarczakYT]

Thank you :)

[@RohkeaNox]

Very helpful, thank you :) !

[@oscarsalas6271]

Excelente video, me ayudo mucho

[@_indrid_cold_]

Best content! Thank you so much!

[@AdamMarczakYT]

Awesome, cheers!

[@Unbox747]

I love your videos!

[@lorenzodelsoldato6899]

Thank you, really good content

[@shaileshsondawale2811]

Great work...!!!!

[@luisabaiano8689]

Thank you! From Italy

[@AdamMarczakYT]

And thank You for watching Luisa :)

[@TheSQLPro]

Great tutorial!

[@AdamMarczakYT]

Thank you!

[@danceandmanymorewithprisha5599]

great explanation !

[@AdamMarczakYT]

Thank you!

[@devopsexpert9906]

Excellent Video, Best tutoring.......

[@AdamMarczakYT]

Many many thanks

[@leonkriner3744]

very helpful. Thank you!

[@AdamMarczakYT]

Glad you liked it!

[@ivanovdenys]

Thanks a lot !!! Really really good !!

[@AdamMarczakYT]

Thanks! And thank you for watching Denys :)

[@priyankapatel9461]

Really very helpful!

[@AdamMarczakYT]

Thanks!

[@kannan114]

Thanks Adam for the great video. I have a question: how do we put this entire pipeline in loop? Let's say I create a list of source files and destination tables and run this pipeline for each set of values in that list. That way I don't want to enter the value manually during every run/debug. Is this something that can be done at trigger? Any suggestions on that?

[@bookko2377]

Thank you From Thailand

[@AdamMarczakYT]

My pleasure! :)

[@tarvinder91]

very informative and helpful video

[@AdamMarczakYT]

Glad it was helpful!

[@amitsingh8412]

Thanks Adam.

[@AdamMarczakYT]

My pleasure!

[@Peter-cd9rp]

cool dude. Especially pipeline parameters! :)I can easily start pipelines with logic apps! :D Wohoo

[@AdamMarczakYT]

Glad you liked it!

[@rishikabapat6737]

Thank you Adam for such great videos! I'm not sure if you have covered this in any video, but my question is around transformation of the csv before its loaded into the SQL DB. For example I have a csv file with years as columns and I need to translate them into data fields. Is there any way to do that using Data Factory, or is the only way to re-format in excel before I load it?

[@AdamMarczakYT]

Yes, absolutely! Check out my video on Data Factory Mapping Data Flows it shows exactly what you need ;) thanks for watching!

[@geethamca88]

Excellent

[@sumashree6351]

Thank you very much good explanation.i have one dout which parameter used to improve the performance of the company for the past 6 years

[@julianramirezvasquez3164]

Hi Adam, great video as always! I have a question, is there a way to configure Data Factory in order to send files automatically from a Blob storage and then transform the files automatically as well? if that's possible, how can I do that? Thank you so much!

[@chen5576]

Hi Adam! This was a great tutorial! Do we always need to pre-define a table in SQL before moving data from blob? Could we create a new table if the target sink name does not exist inside the pipeline?

[@AdamMarczakYT]

Thanks! For the table, you can select checkbox on the copy activity to create table if it doesn't exist. Just make sure that the schema mapping is there, otherwise your table schema will be pretty bad. Although this option is not recommended as you should change your DB schema in more controlled manner.

[@mumair1979]

Hi Adam, This is fantastic. How can we take parameters from a SQL table, by using a stored procedure, instead of putting them in each time into the Datasources ?? can you please advise.. Thanks

[@sonamkori8169]

Thank You Sir

[@Viqram1]

Hi Adam, Thank you for making such informative videos. I was trying to follow the instructions that you've mentioned in the video. However I wasn't able to load both the files using parameterisation.
When I try to load cars.csv, it loads properly, and then when I try to load planes.csv, it throws an error saying column's not found. In order to reolve it, I just clicked on "Import Schemas" under sink tab and I was able to load planes.csv.
Why do I have to import schemas while changing source files?

[@sameerdongare1113]

Awesome video

[@AdamMarczakYT]

Thaaaanks :)

[@tanmoybhattacharjee4966]

thank you, amazing tutorials , really helpful

[@AdamMarczakYT]

Thanks! :)

[@samama1975]

Hi Adam, thank you for throwing light into the world of Azure. I enjoy following your tutorials. Question though, Could you please point me to where I can download the PowerPoint doc you used for this tutorial? It's simply the road map that is needed to guide you as you navigate your project. Thank you

[@AdamMarczakYT]

Thank you for watching and commenting. Unfortunately while the source code and samples are open source on github, entire content are free, I decided that at this point in time I'm not sharing PowerPoint presentations as I want to maintain copyright over my materials. Thank you for understanding.

[@maxgobel]

HI Adam, thanks for the great tutorial, was very helpful. Would I be able to follow this procedure with a dataflow instead of a copy example? I am struggling with implementing this between a rawinputBlob and a cleanedOutputBlob

[@AdamMarczakYT]

It's a little different but mapping data flows support parametrization too: docs.microsoft.com/en-us/azure/data-factory/parameters-data-flow?WT.mc_id=AZ-MVP-5003556 thanks for stopping by!

[@alfredsfutterkiste7534]

Love it

[@srinivasareddy3336]

Hi Adam, thanks for the great video tutorial. May I know how to pass variable values from one pipeline to another pipeline in Azure Data Factory.

[@mahendramanchekar]

Thank you

[@kavishv.8101]

Do we have to always create individual table in SQL database for every csv file we copy from blob to database? Also, you've an amazing content, Thank you!

[@mrboloban25]

Great video Adam, thanks. If I am able to get the schema and table list from a db with a Lookup, how could I export this to a csv file? Thanks.

[@jonahnio5642]

Thanks alot Adam for the video. WOuld you be able to show me how I can pass variables across different pipelines? Thanks very much

[@AdamMarczakYT]

Thanks. Check out MS blog entry on that cloudblogs.microsoft.com/industry-blog/en-gb/technetuk/2020/03/19/enterprise-wide-orchestration-using-multiple-data-factories/

[@atulsalunke6675]

Awesome content and delivery Adam !! Thanks!!
Please if possible add real Project based content using ADF

[@AdamMarczakYT]

Great suggestion! I do plan to have few videos on actual implementations :)

[@rajexpert8544]

Hi Adam,
Nice tutorial. How can I parameterize the pipeline if I want to loop through all the containers in blob storage and with the corresponding sql table name?
I don't want to enter parameter values manually at run time

[@H2B-World]

Hi Adam, it looks flawless but I have a doubt in the present scenario. Without passing names manually in parameters while can't it read the file one by one and process accordingly?

[@sarveshpandey1125]

You saved a lot of my time . Thank you! can you please clarify one thing, what's the use case for using pipeline variables?

[@AdamMarczakYT]

Thanks! Parameters are for entry input, variables are for intermediate results and temporary or calculated values that change during pipeline run. They have many use cases.

[@krishnakoirala2088]

Adam Thanks for all those great videos. A question: I have a parameterized stored procedure as an activity and I am passing parameter values with in ADF. I want to capture value of one parameter dynamically that is passed on the stored procedure, how do I do that? I need to capture this value within databricks notebook via widget. I have defined a Base parameters in databricks notebook activity something like this (@activity('DeleteDaysBack').output), here DeleteDaysBack is the stored procedure and parameter of which I am trying to capture in databrick activity. Only the Input has that parameter, but ADF does not support Input, throws an error. Any insight would be helpful, thanks in advance.

[@yyy168-wt1zq]

Hi Adam, thanks for the video, that's a clear explanation, can I ask what if I want to put Cars and Planes into a variable array, then Pipeline can have a for loop execution of doing the copy of Cars and then Planes. Is it possible?

[@blse2000]

awesome bro

[@AdamMarczakYT]

Thank you! Happy and joyful x-mas!

[@juliestudy1475]

This is great! Instead of typing in the source and destination one at a time, is there a way to simply loop through the files folder, pick up the filenames and pass them as input (filename) parameters and use them again as output (tablename) parameter?

[@Go_Bremerhaven]

What a great video. One question though. Does the Copy Data Activity automatically map the columns of the csv to the columns of the sql table automatically based on the column names? What is if the column names are different between the csv and sql tables?

[@AdamMarczakYT]

Thanks! If they are different it will throw error, but as a workaround you can create SQL view with the right column names. SQL server allows to perform inserts on the view :)

[@sougatasil6064]

Thanks for the demo. But what to do in case of scheduled execution , because it is not possible to change the parameters manually during scheduled execution. Is there a way to pass the parameter dynamically so that , once it is scheduled for car and next time scheduled for plane without manual intervention