Forum Discussion
Trigger Data Pipeline
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.
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
3 Replies
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
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?
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
