Forum Discussion

bjadav's avatar
bjadav
New Contributor II
5 years ago
Solved

Running Child Pipeline if Parent Pipeline is Successful

I have a child pipeline which depends on successful execution of other parent pipeline. In parent pipeline, I am updating some MySQL tables from external source. Then in child pipeline, this updated ...
pipeline
  • tlikarish's avatar
    tlikarish
    5 years ago

    Here’s an example project of what I was thinking of. In this project, there is a parent pipeline with 3 Pipeline Execute snaps. Each Pipeline Execute will execute child pipelines: step 1, step 2, and step 3. The parent will execute step 1, but step 2 is designed to fail. Notice that since it failed, the Pipeline Execute called step 3 is not executed. Is this a helpful example of what I had proposed?

    projects_exe-on-success.zip (3.5 KB)

bjadav's avatar
bjadav
New Contributor II
5 years ago

@tlikarish Thank you for the suggestion. Would it be possible for you provide one example which will help me understand better what you are suggesting?

tlikarish's avatar
tlikarish
Employee
5 years ago

Here’s an example project of what I was thinking of. In this project, there is a parent pipeline with 3 Pipeline Execute snaps. Each Pipeline Execute will execute child pipelines: step 1, step 2, and step 3. The parent will execute step 1, but step 2 is designed to fail. Notice that since it failed, the Pipeline Execute called step 3 is not executed. Is this a helpful example of what I had proposed?

projects_exe-on-success.zip (3.5 KB)

  • bjadav's avatar
    bjadav
    New Contributor II
    5 years ago

    @tlikarish Thank you for the example! It is working as expected. The only thing I need to make sure is that there are not open input or output in the child pipelines

  • bjadav's avatar
    bjadav
    New Contributor II
    5 years ago

    @tlikarish for this to work, we need to have no open inputs or output in pipeline. But there are snaps which do not have optional input/ouput. In such case do you know of the dummy snap that I can use to close of the open output of the snap in a pipeline?
    Currently, I am using MySQL Execute snap with SQL statement as SELECT 1; but this is not efficient as this still makes connection to a database hence I am looking to replace this with some dummy snap to close of the output.