Execute a Collection of Child Pipelines from Metadata in Data Factory

Andy Leonard continues a series on design patterns:

In this post, I clone and modify the dynamic parent pipeline from the previous post to retrieve metadata from an Azure SQL database table for several child pipelines, and then call each child pipeline from a parent pipeline.

When we’re done, this pipeline will:

1. Read pipeline metadata from a table in an Azure SQL database
2. Store some of the metadata (a collection of pipelineID values) in the (existing) pipelineIdArray variable
3. Iterate the pipelineIdArray variable’s collection of pipelineID values
4. Execute each child pipeline represented by each pipelineID value stored in the pipelineIdArray variable

Read on to learn how.