Execute Transfer in Google Bigquery - PERMISSION_DENIED: No OAuth token with Google Drive scope was found

Question

I am trying the new 'Transfers' function in google BigQuery.

I am using the option: 'Scheduled Query'

It works with a simple query, but when I am trying another query that is normally working based on a view, that is based on a join between two tables (on table based on a google sheet shared with me) none of the more complicated Transfers I created are working.

I get the following error message:

Failed to start job for table 'xxx' with error PERMISSION_DENIED: Access Denied: BigQuery BigQuery: No OAuth token with Google Drive scope was found.

Is it because one of the source tables is based on a google sheet?

I tried to copy the source table to another table, but when I do this BigQuery automatically deletes this table.

Any ideas?

Answer 1

The problem is with the view which queries Google Drive data. In order to resolve your problem you need to request Google Drive scopes. Quoting directly from documentation:

Accessing data hosted within Google Drive requires an additional OAuth scope, both when defining the federated source as well as during query execution.

In the documentation page linked above you'll also find ways to do this via command line, api and web UI.