拒绝访问:用户没有bigquery.jobs.create权限 [英] Access Denied: User does not have bigquery.jobs.create permission
问题描述
从几天前开始，在 SOTorrent 数据集BigQuery:
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.
即使对于最简单的查询，也会显示错误，例如 SELECT * FROM'ghtorrent-bq.ght.issues'LIMIT 1000 .直到几天前，相同的查询一直没有任何问题，并且我不知道是什么原因导致了这种新行为.
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.
推荐答案
** ghtorrent-bq ** 和 ** sotorrent-org ** 是具有以下内容的项目公开数据集.因此，只要您符合数据集权限，就应该能够访问其数据.您可以按以下方式进行检查(在示例中，我将使用 ghtorrent-bq 项目和 ght 数据集):
The **ghtorrent-bq** and **sotorrent-org** are projects with public datasets. Therefore, you should be able to access its data as long as you are compliant with the dataset permissions. You can check it as follows (in the example I will be using the ghtorrent-bq project and ght dataset):
-
单击BigQuery控制台左下方的项目
Click at the project, in the bottom left side of the BigQuery console
选择数据集，在这种情况下，我选择了 ght
Select the dataset, in this case I selected ght
在查询编辑器下方，单击共享数据集
Below the query editor, click SHARE DATASET
现在，在数据集权限标签下，您可以看到授权的成员和每个角色
Now, under the tab DATASET PERMISSIONS you can see the authorised menmber and each role
单击 BigQuery Data Viewer 角色，您可以看到成员之一是 allAuthenticatedUsers
Click the BigQuery Data Viewer role, you can see that one of the members is allAuthenticatedUsers
因此，如果您通过使用BigQuery的Google帐户进行了身份验证，则应该能够看到数据集中的数据.
Therefore, if you are authenticated with a google account using BigQuery, you should be able to see the data within the dataset.
下一步，也是该错误的常见原因，应检查是否选择了项目.未选择项目时，我能够重现您的错误.在BigQuery控制台内部，在屏幕的右上方，确认是否选择了一个项目-如果未选中，则将其写为 Select Project .选择项目后，您应该有权对这些数据集中的数据运行查询.
The next point, and usual cause of this error, you should check if you selected the project. I was able to reproduce your error when not selecting the project. Inside the BigQuery Console, on the upper right side of the screen, confirm if there is a project selected -if not, it will be written Select Project. After selecting the project, you should have the permission to run a query against the data within these datasets.
这篇关于拒绝访问:用户没有bigquery.jobs.create权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
