Hi there,
I have a self hosted Redash instance setup with a BigQuery connector using a service account with BigQuery Admin privileges. After setting up the datasource the test works okay and I can also load the schema.
When I want to execute a simple query it will always show a 404 error saying the job is not found, I have no idea how to debug this, I can use the same query just fine in the Google Cloud interface.
Here is the error
Error running query: { “error”: { “code”: 404, “message”: “Not found: Job myproject:job_Kbx_n7l-wNHl_DuCHXQ2IBLW57MV”, “errors”: [ { “message”: “Not found: Job myproject:job_Kbx_n7l-wNHl_DuCHXQ2IBLW57MV”, “domain”: “global”, “reason”: “notFound” } ], “status”: “NOT_FOUND” } }