在BigQuery中运行查询而无需成为项目用户 [英] Running queries in BigQuery without being a project User

问题描述

看来，共享数据集以使其他人可以对数据集中的表进行查询的唯一方法是使该人成为Project的用户.请参见权限

It seems the only way to share a dataset so that another person can run queries on the tables from the dataset is to make that person a Project user. See permissions

这意味着用户将有权访问项目中的所有数据集.在我看来这是非常不便的.我想念什么吗?

This means that the user would have access to all the datasets on the project. This seems to me that is is highly inconvenient. Am I missing something?

推荐答案

用户要运行查询-用户需要具有 bigquery.jobs.create 权限

For user to run query - user need to have bigquery.jobs.create permission

如果您的用户已经在任何其他项目中拥有此权限-您可以使用可以查看访问级别"直接与该用户共享数据集

If your user already has this permission in any other project - you can just simply share your dataset with this user with Can View Access Level

如果该用户是新用户，并且在任何其他项目中还没有bigquery.jobs.create，则仅可以将此用户添加到您的项目中，但必须具有此权限.

If user is new and does not have yet bigquery.jobs.create in any other project - you can just add this user to your project with this permission only.

仍然需要为此将该用户添加到ACL中 特定数据集

And still you need add this user to ACL for that specific dataset

重要:也请注意-如果您授予用户在项目中创建作业的权限-您将在相应查询中为billed.
如果用户拥有其自己的"项目并且仅具有对您数据的查看权限-在这种情况下，帐单将转到用户的项目

Important: Please also note - if you give user permission to create jobs in your project - you will be billed for respective queries.
If user has its "own" project and only has view access to you data - in this case bill goes to user's project

这篇关于在BigQuery中运行查询而无需成为项目用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！