Can't connect to Google BigQuery with 500 error

Issue Summary

I tried to connect BigQuery but it does not allow me to connect using Service Account. I tested with different clients, such as DataGrip or Postico, and it does work fine on that.
The error message that I get is

server_1     | Traceback (most recent call last):
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2463, in __call__
server_1     |     return self.wsgi_app(environ, start_response)
server_1     |   File "/usr/local/lib/python3.7/site-packages/werkzeug/middleware/proxy_fix.py", line 232, in __call__
server_1     |     return self.app(environ, start_response)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2449, in wsgi_app
server_1     |     response = self.handle_exception(e)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask_restful/__init__.py", line 269, in error_router
server_1     |     return original_handler(e)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1866, in handle_exception
server_1     |     reraise(exc_type, exc_value, tb)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask/_compat.py", line 38, in reraise
server_1     |     raise value.with_traceback(tb)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app
server_1     |     response = self.full_dispatch_request()
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request
server_1     |     rv = self.handle_user_exception(e)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask_restful/__init__.py", line 269, in error_router
server_1     |     return original_handler(e)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception
server_1     |     reraise(exc_type, exc_value, tb)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask/_compat.py", line 38, in reraise
server_1     |     raise value.with_traceback(tb)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request
server_1     |     rv = self.dispatch_request()
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request
server_1     |     return self.view_functions[rule.endpoint](**req.view_args)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask_restful/__init__.py", line 458, in wrapper
server_1     |     resp = resource(*args, **kwargs)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask_login/utils.py", line 261, in decorated_view
server_1     |     return func(*args, **kwargs)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask/views.py", line 89, in view
server_1     |     return self.dispatch_request(*args, **kwargs)
server_1     |   File "/app/redash/handlers/base.py", line 33, in dispatch_request
server_1     |     return super(BaseResource, self).dispatch_request(*args, **kwargs)
server_1     |   File "/usr/local/lib/python3.7/site-packages/flask_restful/__init__.py", line 573, in dispatch_request
server_1     |     resp = meth(*args, **kwargs)
server_1     |   File "/app/redash/handlers/query_results.py", line 462, in get
server_1     |     job = Job.fetch(job_id)
server_1     |   File "/usr/local/lib/python3.7/site-packages/rq/job.py", line 299, in fetch
server_1     |     job.refresh()
server_1     |   File "/usr/local/lib/python3.7/site-packages/rq/job.py", line 518, in refresh
server_1     |     raise NoSuchJobError('No such job: {0}'.format(self.key))
server_1     | rq.exceptions.NoSuchJobError: No such job: b'rq:job:9e3e92ef-f01b-4983-a2a8-37edeb82d6c6'

Does anyone have any ideas? what could be the issue?
I checked the issue here Redash can't connect any datasource and I already restarted the radis but it’s not loading.

Thank you for your helps.

Technical details:

  • Redash Version:10.1.0
  • Browser/OS:Chrome/MacOS (M1 silicon)
  • How did you install Redash:Docker

Are you able to create and run queries against any data source? You can use the Query Results Data Source as a control just to be certain.

Quickly tested with CSV data source and it’s also failing. Any suggested options that I can try?