cancel
Showing results for 
Search instead for 
Did you mean: 

How to check if Query returns empty?

robert_parks
New Contributor III

Hi,

I have a sql execute snap that can return no values.
I have the pipeline continuing if there is no values.
What is the best way to identify if the query returns empty?
I have added a “select count(*)…” off of the query before running the main query but that seems foolish.

Any thoughts?

Bob

2 REPLIES 2

aleung
Contributor III

Doing the select count seem to be the only way for now.

robert_parks
New Contributor III

Meh.

Thanks!