I wanna use bigquery with redash.
but I cant find bigquery in datasource.

how do I solve it?

my virsion
v3.0.0+b3134.
google-api-python-client==1.6.4
oauth2client==4.1.2

Try following the steps mentioned here: BigQuery is not listed in datasource type since v2.0.0

1 Like

Try opening a Python shell with the same Python environment as you run Redash, and type in the following:

import apiclient.errors
from apiclient.discovery import build
from apiclient.errors import HttpError
from oauth2client.service_account import ServiceAccountCredentials
from oauth2client.contrib import gce

Does one of them fail?

I got this error so…

from oauth2client.service_account import ServiceAccountCredentials
Traceback (most recent call last):
File “”, line 1, in
File “/usr/local/lib/python2.7/dist-packages/oauth2client/service_account.py”, line 26, in
from oauth2client import crypt
File “/usr/local/lib/python2.7/dist-packages/oauth2client/crypt.py”, line 23, in
from oauth2client import _pure_python_crypt
File “/usr/local/lib/python2.7/dist-packages/oauth2client/_pure_python_crypt.py”, line 23, in
from pyasn1_modules import pem
ImportError: No module named pyasn1_modules

SO, I tried checking out if I hava “pyasn1_modules”
using tihs command “pip show pyasn1”

Name: pyasn1
Version: 0.4.2
Location: /usr/local/lib/python2.7/dist-packages
Requires:

I think I already installed

help…