View the original community article here
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