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?

0 Answers