'Access Denied: User does not have bigquery.jobs.create permission
Since a few days ago, I've been getting the following error when running any query on the GHTorrent and SOTorrent datasets on BigQuery:
Access Denied: Project ghtorrent-bq: User does not have bigquery.jobs.create permission in project ghtorrent-bq.
The error shows up even for the simplest queries, such as SELECT * FROM 'ghtorrent-bq.ght.issues' LIMIT 1000. The same query worked without any problems until a few days ago, and I have no idea what might cause this new behaviour.
Solution 1:[1]
Stumbled upon this answer with a slightly different problem.
If that's your case too, you might need to give the reading user not only the BigQuery Data Viewer permission but also BigQuery Job User:
Solution 2:[2]
You need to select a project, in the bottom left side of the BigQuery console
Solution 3:[3]
There's no longer a bigquery job user role. There's a metadata viewer, data viewer, data owner, data editor roles.
I granted all 4 of these to both the project and dataset and still get the error Access Denied...User does not have bigquery.datasets.create permission in project. Even though it's owner of the project!
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 | Gunar Gessner |
| Solution 2 | Abdelmalek Nouri |
| Solution 3 | Gary |