Azure Data Factory Parametrization

Highlight

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.

Intro

In this video I will cover basics of Data Factory Parametrization using common Blob to SQL loading scenario.

Agenda

In today episode I will cover

1. Azure Data Factory Parametrization Overview
2. Common Scenarios
3. Data Factory BLOB to SQL with CSV files loading demo with parametrization

Video

Final thoughts

Next steps for you after watching the video

1. Check data factory docs
   • https://docs.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions?WT.mc_id=AZ-MVP-5003556
2. Linked service parametrization example
   • https://docs.microsoft.com/en-us/azure/data-factory/parameterize-linked-services?WT.mc_id=AZ-MVP-5003556
3. System variables
   • https://docs.microsoft.com/en-us/azure/data-factory/control-flow-system-variables?WT.mc_id=AZ-MVP-5003556