I have a simple Zap set up that runs a SQL query that returns a single number (the query is a SELECT COUNT(x) query), and then adds that value to a new row in a GSheet. When I test the GBQ query step, the query runs and produces the expected result. However, when the Zap runs on its scheduled interval, sometimes the GBQ query step in the flow generates this error:
“Error message: Nothing could be found for the search.”
The query takes about 9 seconds to run in my personal GBQ IDE and only processes ~1 GB of data (so it’s not a huge query by any means), and always runs without any errors. 5 out of the 10 days the Zap has run (once per day is the schedule), the GBQ query step runs successfully, and the other 5 days it has failed with the error message above.
Does anyone know what might be causing that error? Is it the GBQ query timing out or something?
Below is a screenshot of some of the run history:
And here is a screenshot of the error in the GBQ query run step:
