Please try this:
`select * from RUNS;`

Instead of
'select * from RUNS;'

Can you verify this SQL query also return results independent of Cribl?

If all of the above checks .. and you still do not get results .. try:

• Last time I saw this issue the customer upgraded the Leader to a version that supports Postgres, but not the Workers
• Make sure you commit and deploy

also check for any errors in the logs in cribl and/or auth errors in the postgres db logs.

the issue lied in the syntax itself, so instead of
select * from RUNS ;
it should have been
select * from "RUNS" ;