Skip to main content
Microsoft Idea

Data Factory

Planned

Missing Expression option to call a Child Pipeline on a Invoke Pipeline Activity

Vote (38) Share
Erwin de Kreuk's profile image

Erwin de Kreuk on 17 Jul 2023 16:06:14

Currently, the ability to dynamically invoke a pipeline is missing in an Invoke Pipeline activity. This makes building meta data driven framework much easier. A similar option is already available for a Notebook in Azure Synapse.

Administrator on 25 Jul 2023 19:53:29

Planned. 

Comments (3)
Erwin de Kreuk's profile image Profile Picture

Bob Duffy on 18 Jul 2023 18:58:03

RE: Missing Expression option to call a Child Pipeline on a Invoke Pipeline Activity

This is essential for meta data automation and moving to a more declarative ETL Architecture.We absolutely need to be able to add pipelines (or notebooks) as run time without having to modify parent pipelines and complex hard coded switch statements.SSIS 2005 had this feature (Dynamic child packages), so its shameful that 18 years later the new stack doesnt have this feature yet. Happy to show a demo of our Frameworks and why this is so critical for our customer

Erwin de Kreuk's profile image Profile Picture

Abhishek Narain on 18 Jul 2023 00:42:17

RE: Missing Expression option to call a Child Pipeline on a Invoke Pipeline Activity

Planned in Fabric pipelines. ETA H2 CY2023.

Erwin de Kreuk's profile image Profile Picture

Marco on 17 Jul 2023 18:59:12

RE: Missing Expression option to call a Child Pipeline on a Invoke Pipeline Activity

This would be great! And should also be a feature request for Data Factory and Synapse.