Forum Discussion

robert_parks's avatar
robert_parks
New Contributor III
8 years ago

How to check if Query returns empty?

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