This is very similar to this question - I have basically the same question, and one of the commentators said that he solved it, but did not look for a solution.
- I have data on a google worksheet that I configured as a BigQuery join data source (external data source).
- I want to import this data into a cloud datalab using pandas_gbq
- When I import regular (non-federated) BigQuery tables from the same project, everything works fine in the datalab instance.
- When I try to import a federation source (from a google sheet), I get the error: "GenericGBQException: Reason: accessDenied, Message: Access Denied: BigQuery BigQuery: OAuth token with Google Drive scope not found."
I tried to follow the mattm instructions on the original question : “I had the same problem and I had to enable the Drive API for the project (in addition to the BigQuery API) and also use the BigQuery + areas. I also had to manually resolve the sheets, to allow access to the account ... @ appspot.gserviceaccount.com, my project used to access Google sheets using. "
- I have included the disk API for the project.
- , datalab, google: xxxx@developer.gserviceaccount.com
- , " BigQuery + Drive"?
- ? BigQuery Drive, , ?