SQL Server No Rows Control Flow

Designing Pipelines
#1

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.

#2

Hi @bigdogz

You can use the checkbox “Igonore Empty Result”.

Answer330

1 Like
#3

You can try a Router Snap as shown in Performing an Action when there is no data .

#4

I clearly did not understand how the “Ignore empty result” setting workd, but this did fix the problem. Thank you.

1 Like