CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquerydrive
tazy7
tazy7

Reputation: 68

How to access to Google Sheets Doc via Google BigQuery External Table via Service account

I have a BigQuery table that references a Google Sheet document that my service account can't access. Currently getting

"Error: Not found: Files /gdrive/id/xxxx"

I'm using the NodeJs 3.0.0 client library to access the BigQuery API.

The service user account has Data Editor, Job User and User rights on BigQuery and I have explicitly shared the google sheet to the service account.

For clarity, the user account has no issues querying other tables that it has access to, just a bunch of these external tables.

Any thoughts on what else I might need to do?

Upvotes: 1

Views: 1049

Answers (1)

tazy7
tazy7

Reputation: 68

After going back through this from the start it turns out the issue was due to Google Doc editor being disabled at an organisation level. This affects both normal users and service accounts. Also ensuring that Domain-wide delegation was in place heped resolved this.

Upvotes: 1

Related Questions