โ04-16-2021 07:17 AM
Newbie with Snap Logic.
Iโm attempting to build an integration that will run once a day.
The input is coming from a SQL Server database.
There will be days when there will be no data to process.
Iโm looking for best practices for determining if there is no data and exiting the pipeline graciously.
I have a SQL Server Execute Snap followed by a Mapper Snap. The Pipeline current fails on the Mapper.
Is it best practice to run a โpre-queryโ to determine if there are any rows to process and use the โExitโ snap to kill the pipeline? This seems wasteful.
Or use a Data Validator Snap? Not sure how to check the row count.
Or is there another pattern I havenโt found yet?
Thanks for you input.
Solved! Go to Solution.
โ04-16-2021 07:41 AM
โ04-16-2021 07:41 AM
โ04-16-2021 02:20 PM
I clearly did not understand how the โIgnore empty resultโ setting workd, but this did fix the problem. Thank you.
โ04-16-2021 07:41 AM
You can try a Router Snap as shown in Performing an Action when there is no data .