Knowledge Drop
Last tested: Jan 21, 2019
This error can pop up when connecting to/querying from google sheets, and possibly means the sheets file isn’t shared with the service account.
Below are some steps you can follow to check for this:
- Go to IAM & Admin
- Copy the Service Account Email you use for the BigQuery connection (should look something like ****@.iam.gserviceaccount.com)
- Share the spreadsheet with the above service account email
Source:
https://help.looker.com/hc/en-us/articles/360023623234-Live-Spreadsheets-in-Databases