Errors: No OAuth token with Google Drive scope was found. Pandas_: Reason: 400 Error while reading table: _name_changes_2013, error message: Failed to read the spreadsheet. Raise GenericGBQException("Reason: ".format(ex)) Schema, rows = n_query(query, **kwargs)įile "/Users/inglesp/.pyenv/versions/openprescribing/lib/python2.7/site-packages/pandas_gbq/gbq.py", line 545, in run_queryįile "/Users/inglesp/.pyenv/versions/openprescribing/lib/python2.7/site-packages/pandas_gbq/gbq.py", line 455, in process_http_error GSuite tokens differ from GCP Tokens I'll read the provided article. Funny, as I already have a Google OAuth Token with BigQuery. > df = pd.read_gbq('SELECT * FROM _name_changes_2013', 'ebmdatalab', dialect='standard')įile "/Users/inglesp/.pyenv/versions/openprescribing/lib/python2.7/site-packages/pandas/io/gbq.py", line 149, in read_gbqĬredentials=credentials, verbose=verbose, private_key=private_key)įile "/Users/inglesp/.pyenv/versions/openprescribing/lib/python2.7/site-packages/pandas_gbq/gbq.py", line 827, in read_gbq Simiar problem occur when trying to read Google sheet directly from Power BI : Works fine with a public access GSheet, but fails if authentication is required. Please include a function to add the Google Drive View scope so that external tables can be visualized in Tableau. This is because when authenticating with Google, Tableau does not ask for the Google Drive View scope, but only BigQuery scopes. a service accounts authentication information, so no further setup is required. Now Tableau cannot connect to external tables in BigQuery using Google Drive as the underlying datasource. ![]() ![]() Querying it fails with "No OAuth token with Google Drive scope was found". gcloud auth uses the cloud-platform scope when getting an access token. _name_changes_2013 is a table with a Google Sheets external data source.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |