How to set the dependency between two trigger pipelines in azure synapse Analytics

Question

I have a two trigger synapse pipelines one which is scheduled at 03 am cst , What I'm looking now is the Second pipeline should trigger after the completion of the first pipeline i.e after 03 am cst.

Is there a way i can create this dependency in the synapse. If yes please suggest.

score 2 · Answer 1 · answered Jul 12 '22 at 03:55

2

There are 2 options:

Create an event trigger for the 2nd pipeline and add a copy file activity at the end of 1st pipeline. So whenever the 1st pipeline gets completed, it would generate a file and trigger the 2nd pipeline
Use execute pipeline activity at the end of 1st pipeline and trigger the 2nd pipeline ( you can even use web activity but there would be additional efforts for it)

answered Jul 12 '22 at 03:55

Nandan

3,939
2
8
21

Can we create a tumbling trigger depdendency? – Never_Give_Up Jul 12 '22 at 15:21

score 1 · Answer 2 · answered Jul 13 '22 at 08:13

Create a tumbling window trigger for both pipelines.
While creating a tumbling window trigger for the second pipeline, you can add a dependency trigger under Advance property and select pipeline1 trigger.
The second trigger runs only upon completion of the dependency trigger.

How to set the dependency between two trigger pipelines in azure synapse Analytics

2 Answers2