Cathrine Wilhelmsen

Information & Communications Technology

Business Intelligence Data Warehousing Data Integration ETL Azure Data Platform Azure Data Factory Microsoft Data Platform SQL Server Integration Services SSIS Biml BimlScript SQL Server SQL

Oslo, Norway

Building Dynamic Data Pipelines in Azure Data Factory

You already know how to build, orchestrate, and monitor data pipelines in Azure Data Factory. But how do you go from basic, hardcoded data pipelines to making your solution dynamic and reusable?

In this session, we will dive straight into some of the more advanced features of Azure Data Factory. How do you parameterize your linked services, datasets, and pipelines? What is the difference between parameters and variables, and when should you use them? And how does the expression language and built-in functions really work?

We will answer these questions by going through an existing solution step-by-step and gradually making it dynamic and reusable. Along the way, we will cover best practices and lessons learned.

Additional Information
Session Level: 300 / Intermediate
Session Length: 45-75 minutes
Prerequisites: Must have experience with Azure Data Factory development.


Cathrine Wilhelmsen

Senior BI Consultant at Inmeta | Data Platform MVP

Cathrine loves teaching and sharing knowledge. She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she's active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.


Cathrine is based in Norway, but loves traveling and speaking internationally.

Cathrine's full speaker profile