Google BigQuery中的查询表具有错误“访问被拒绝:BigQuery BigQuery:遍历文件模式时权限被拒绝." [英] Query table in Google BigQuery has error "Access Denied: BigQuery BigQuery: Permission denied while globbing file pattern."
问题描述
我是Google BigQuery的新手.如果我的问题有点简单，请原谅我.
I'm new with Google BigQuery. Please forgive me if my question is a little simple.
让我澄清问题的背景:
-
Account1创建一个存储桶(多区域)和外部表.
Account1 create a bucket (Multi-region) and external table.
Account1可以成功查询外部表数据.
Account1 can query the external table data successfully.
授予Account2在该项目下面的角色.
Grant Account2 below roles on the project.
BigQuery中的Account2日志可以看到该表，但无法查询数据，出现以下错误.
Account2 log in BigQuery can see the table, but can't query data, with below error.
我已经进行了一些研究并启用了BigQuery API，但问题仍然存在.
I have done some research and enable BigQuery API, issue still occurs.
推荐答案
从存储桶中读取数据时，还应授予第二个用户访问权限，以从给定存储桶中读取数据.单击存储桶，然后从菜单中选择编辑存储桶许可"，然后单击添加成员".并向第二个用户授予存储对象查看器"角色.或者，您可以使用IAM并在整个项目中授予该角色，从而授予对所有存储桶的读取访问权限.
As you are reading data from a bucket, you should also give the second user access to read the data from the given bucket. Click on the bucket and from the menu select "Edit bucket permissions", then click "Add member" and grant the second user the "Storage object viewer" role. Alternatively you can use the IAM and grant this role across the whole project and thus granting read access to all buckets.
这篇关于Google BigQuery中的查询表具有错误“访问被拒绝:BigQuery BigQuery:遍历文件模式时权限被拒绝."的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
