Trigger Data Pipeline

[abpgupta]

Hi All

Is it possible to run a query using Data Pipeline and get output value to decide to trigger next steps or not?

Thanks for any inputs.

[NandanHegde]

nCan you please provide some additional details as to what you mean by run a query? Do you wish to run a query on a database? If yes,then you can leverage lookup/script activity to query the database and leverage that output within an IF activity to determine to trigger other aspects if the condition matches

[abpgupta]

Thank you @NandanHegde  for response!

Yes, I have a control table to check when a load is finished in Database and would like to query to check if load is done for day and then based on value compared to trigger time of pipeline, I would like to invoke next steps. 

is there any example to refer to for setting up this?

[NandanHegde · Accepted solution]

Above would be the flow wherein you would query the control table from the database via lookup activity

Then leverage IF activity and do your comparison from the lookup activity output

and based on true/false output add the necessray actions within IF activity