'Access Denied: BigQuery BigQuery: Permission denied while opening file
When trying to perform a simple query in BigQuery I am getting this error:
Access Denied: BigQuery BigQuery: Permission denied while opening file.
I am using an IAM user with a BigQuery admin role. I can view the datasets and tables just not any data.
I have authorised the dataset too.
Solution 1:[1]
You might be missing a storage permission. (storage.objects.get). Try running a gsutil -D 1, check output for any 403 errors.
Solution 2:[2]
Open your GCP console (Logs Explorer) and filter on the service you want (GCS here). It will give you the service account/account which need access + rights missing on the target ressource.
If you can recreate the error, do it and then refresh the log explorer.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Moe |
| Solution 2 | Jonito |