[ SQL Runner Not Returning Results (But Queries Ru...
# general
k
[ 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.
1
p
👋 Thanks for your message - someone from the Lightdash support team will get back to you asap. Feel free to add any additional context to the thread here in the meantime (screenshots, app version if you're self-hosting etc.).
k
Finally got everything running. Thanks a lot.
o
Glad to hear it! What worked for you in the end? If you encounter any other issues please let me know!
thank you 1