Avoiding Defaultcredentialserror When Using Google Bigquery Api

I'm trying to execute an SQL query on some bigquery table. I keep getting a DefaultCredentialsError when trying to instantiate a bigquery client object. For example by doing this:

Solution 1:

You are most likely hitting a bug with using the from_service_account_json method.

Instead, try using the recommended way of authenticating by exporting the GOOGLE_APPLICATION_CREDENTIALS environment variable as decribed here.