How To Use Switch Statement in Azure Data Factory Pipeline

Tech Zero
3 min readSep 14, 2021

This article explains how to use switch statement in ADF pipeline instead of multiple if-else activities.

As a Data Engineer, I have had many use cases wherein I needed to use multiple if-else conditions as part of my data pipeline. What I found was that ADF doesn’t support nested if-else statements as well as I’d have imagined/assumed. You can either use many if-else conditions or use one switch activity. Here, I will give you a practical example that uses switch activity.

Use Case:
Multiple datasets

--

--

Tech Zero

Data Engineering Manager | Azure, Databricks and Snowflake stack | Here to share my knowledge with everyone