创建公共数据集（或：在两个项目之间拆分存储成本和计算成本） [英] Creating a public dataset (or: split storage costs and compute costs across two projects)

问题描述

我想使用BigQuery来托管其他人可以查询的数据集，而不会对我的项目造成处理费用。我明白，当我将数据集上载到项目时，存储成本与项目相关联。我希望其他人能够发现我的数据集，通过他们的项目/帐户（最好不需要我的干预）访问它，并根据他们选择支付的数量运行尽可能多的查询。因此，存储成本将交给我，但计算成本将交给运行查询的人。

I would like to use BigQuery to host datasets that others can query without incurring processing charges against my project. I understand that when I upload a dataset to a project, the storage costs are associated with the project. I want others to be able to discover my dataset, access it via their project/account (preferably without my intervention), and run as many queries on it as they choose to pay for. So, storage costs would go to me, but compute costs would go to those who run the queries.

有没有在BigQuery中执行此操作的方法？我通过Google Cloud企业销售网络表单询问了此问题，但未收到回复。

Is there a way to do this in BigQuery? I asked this via the Google Cloud enterprise sales web form but did not get a response.

推荐答案

当然！您当然可以公开数据集以供其他项目查询，甚至可以将数据集与特定的域，组或用户共享。

Absolutely! You can certainly make a dataset public to be queried from other projects, or even share your dataset only with a specific domain, group or user.

在这个模型中，用户会对自己的项目ID进行查询时收取费用，而您的项目涵盖数据集的存储成本。请注意，如果在不同项目中运行查询的用户想要从其查询结果中存储结果表，他们当然会自己支付此存储空间。

In this model, users would be charged for queries to their own Project IDs, while your project covers the storage costs of the datasets. Note that if the users running queries in a different project want to store their resulting tables from their query results, they would of course pay for this storage themselves.

BigQuery目前不支持不提供公共数据集发现的机制。您必须自己分享项目公共数据集的详细信息。 GitHub Archive 项目就是一个很好的例子。

BigQuery currently doesn't provide a mechanism for public dataset discovery. You would have to share the details of your project's public dataset(s) yourself. The GitHub Archive project has a good example of this.

这篇关于创建公共数据集（或：在两个项目之间拆分存储成本和计算成本）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！