Tech Talk Thursday: How to Use Switch Activity Within Azure Synapse Analytics

Using Switch Activity in Azure Synapse Analytics, located in “Activities” under “Iterations and Conditionals,” will provide you with the same functionality as using a switch statement in most programming languages. 

Switch Activities, built in Synapse Studio, will evaluate a set of activities corresponding to a created “case” that matches the condition evaluation you defined in your switch statement. This will enable you to execute different pipelines, scripts, etc., at runtime based on changes that may have occurred in your data.  

Don’t miss this tech tip if you have pipeline data that requires conditional evaluation and analytics.