Question 105782 in Azure Question posted in
The official documentation to get you started can be found here.

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

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.

Tags:

2

Answers


  1. 0

    There are 2 options:

    1. 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

    2. 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)

    Login or Signup to reply.
  2. 0

    1. Create a tumbling window trigger for both pipelines.

    2. While creating a tumbling window trigger for the second pipeline, you can add a dependency trigger under Advance property and select pipeline1 trigger.

    3. The second trigger runs only upon completion of the dependency trigger.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search