[ SQL Runner Not Returning Results (But Queries Run on BigQuery) – Lightdash on Cloud Run ]
Hi team
I’m running Lightdash on Cloud Run, connected to BigQuery using a service account with sufficient permissions. When I use the SQL Runner in Lightdash (e.g., running SELECT 1 AS mycol;), no results are returned in the UI. However, I can confirm that the queries are being executed in BigQuery (I see them in the job history, run by the Lightdash service account).
The service account has bigquery.dataViewer and bigquery.jobUser roles.
My Lightdash user has developer/admin access.
The correct service account is attached to the Cloud Run service.
I’ve checked connection settings and tried restarting the service.
Is there anything else I should check, or is this a known issue? Any guidance would be appreciated!
Thanks in advance.