谁在BigQuery中为多个用户的数据集支付查询费用? [英] Who pays query costs on datasets across multiple users in BigQuery?

问题描述

我已在"IAM&管理员"部分.

I've granted an internal user permission to query datasets in our Project, under the 'IAM & admin' section.

当用户查询表时，是否将运行查询的费用记入项目帐户?理想情况下，与运行查询的用户相关的任何费用都应记入一个中央帐户. 还是会向用户收取他们自己的单独账单?

When the user queries the tables, will the cost of running the queries be billed to the Project's account? Ideally any costs associated with a user running a query would be charged to one central account. Or will the user be charged on their own separate bill?

使用共享数据集"选项而不是在IAM部分下添加用户，计费方式是否一样?像这样，共享数据集的用户电子邮件将对项目所有者的帐户或他们自己的帐户应用任何相关的查询费用吗?

Does billing work the same using the 'Share Dataset' option instead of adding a user under the IAM section? As in, the user email whom the dataset is shared with will have any related query costs applied to the project owner's account or their own account?

推荐答案

BigQuery 存储费用是通过数据所在项目的计费帐户计费的

BigQuery storage costs are billed to the billing account attached to the project where data resides

同时，与BigQuery作业相关的查询费用会从用户运行作业(查询)的项目所附加的计费帐户中结算.

Meantime, query charges associated with BigQuery jobs are billed to the billing account attached to the project from which the user runs jobs (query).

如果用户使用 BigQuery UI -您(用户)在顶部的项目列表选择器中看到的项目将针对其中执行的所有查询计费，无论在哪里查询数据实际居住.

If a user uses the BigQuery UI - the project you (user) see in the project list selector on top gets billed for all queries executed within it, no matter where the data that is being queried actually resides.

如果用户使用 API 或任何客户端库-所谓的计费项目是用户需要提供的相应API或客户端方法的一部分

If a user uses API or any client library - so called billing project is a part of respective API or client's method that needs to be provided by user

要使项目有资格让用户从中运行查询并将其用作计费项目，则用户必须在IAM中设置bigquery.jobs.create权限.
在此处查看有关角色和权限的更多信息- https://cloud.google.com/bigquery/docs/access-control#permissions_and_roles

For project to be qualified for a user to run queries from, and thus to use it as a billing project, the user must have bigquery.jobs.create permission set in IAM.
See more about roles and permissions here - https://cloud.google.com/bigquery/docs/access-control#permissions_and_roles

使用共享数据集" 选项仅授予用户特定权限以访问各自的数据集

Using the 'Share Dataset' option just gives a user specific permission to have access to respective dataset

希望这可以解决您的问题

Hope this clears your question

这篇关于谁在BigQuery中为多个用户的数据集支付查询费用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！