Hello! This is the fourth video in a series of videos that will be posted on Azure Data Factory! Feel free to follow this series and other videos I post on YouTube! Remember to  like, subscribe and encourage me to keep posting new videos!

• Azure Data Factory – Metadata Activity (Part 1)
• Azure Data Factory – Stored Procedure Activity (Part 2)
• Azure Data Factory – Lookup and If Condition activities (Part 3)

This video in the series leverages and explores the filter activity and foreach activity within Azure Data Factory. Please take a look at a quick overview below and then watch the video! Enjoy!

Filter Activity in Azure Data Factory

The filter activity in ADF is used in a control flow to filter down an existing array. The filter activity will take an input array and then output a separate array that has the filtered results. Each row of the input array is evaluated using the expression language within Azure Data Factory.

Foreach Activity in Azure Data Factory

The foreach activity iterates over an array performing an action or set of actions on each item within that list. In this video each item in the array is passed into a stored procedure activity, which then loads specific metadata information into a table in an Azure SQL Database.

Video on YouTube:

If you like what you see and want more structured end to end training then check out the training offerings for Pragmatic Works! https://pragmaticworks.com/training