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

希望这能解决您的问题

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