igrigorik/gharchive.org

BigQuery Access Denied Error

emalgorithm opened this issue · 5 comments

emalgorithm commented

When following the instructions in https://www.gharchive.org/#bigquery and run the example query, I get the error:
"Access Denied: Project githubarchive: User does not have bigquery.jobs.create permission in project githubarchive."

Any suggestions? Thanks

issue-label-bot commented

Issue Label Bot is not confident enough to auto-label this issue. See dashboard for more details.

igrigorik commented

You cannot execute queries on behalf of the project, you need to create own project in GCP console and then run queries against the public dataset through that.

  • 👍2
emalgorithm commented

It works, thanks!

rodrigolece commented

You cannot execute queries on behalf of the project, you need to create own project in GCP console and then run queries against the public dataset through that.

How do you do that?! God, BigQuery is so unintituitive! For the life of me I don't know what to enter to query the public dataset as opposed to the project...

rodrigolece commented

Ok found it! It turns out that I can run the snippets of code as they are if I select my own project on the top left of BigQuery. So confusing...

  • 👍2