SQL Server Stored Procedure Snap
Hello,
SQL Server Stored Procedure snap has 2 outputs, one for output parameters and another for result set. I am only interested in the resultset, how do I make sure the “output parameter” view is...
Forum Discussion
With the Data Validator Snap (and the constraint that you've put), if no rows are returned, the snap (Data validator) will throw an error and the pipeline will fail. - or maybe that's the behavior that you want to achieve. 🙂
Another option that you can check is Filter Snap. If the filter expression evaluates to true, the document is passed through. If the filter expression evaluates to false, the document is dropped in the stream.
BR,
Spiro
Yes, sorry could've made that clearer - I only want the pipeline to execute if there is data, because the second phase sends a Slack notification, and I only want that notification sent if the data is present (error logs).
I like the filter recommendation - thank you!
Hello @alchemiz ,
Thanks for the approach and It works.
Hi Sir Mohammed,
Good day, for polling you can always use the file poller then set a trigger file in SLDB
Attached PoC pipeline and a trigger file
poller.txt (36 Bytes)
canvas 001_2023_01_10.slp (8.9 KB)
Thanks,
EmEm
