在BigQuery中划分日期表是否产生成本?

时间:2022-05-24 15:27:14

BigQuery quotes this command for creating a partition from existing tables:

BigQuery引用此命令从现有表创建分区:

bq partition mydataset.sharded_ mydataset.partitioned

(see partitioned tables)

(见分区表)

But when I run this, I see that the data is actually getting moved. Since selecting data from raw large tables is very expensive, I wonder how Google applies billing for this situation.

但是当我运行这个时,我看到数据实际上在移动。由于从原始大表中选择数据非常昂贵,我想知道谷歌是如何针对这种情况应用计费的。

1 个解决方案

#1


2  

The bq partition CLI command leverages copy jobs rather than queries, which don't incur execution costs (but you do still get charged for the persisted storage that it may generate).

bq分区CLI命令利用复制作业而不是查询,这不会导致执行成本(但您仍然需要为它可能生成的持久存储付费)。

If you're using the CLI, copy jobs can be specified using the bq cp command.

如果使用CLI,可以使用bq cp命令指定复制作业。

#1


2  

The bq partition CLI command leverages copy jobs rather than queries, which don't incur execution costs (but you do still get charged for the persisted storage that it may generate).

bq分区CLI命令利用复制作业而不是查询,这不会导致执行成本(但您仍然需要为它可能生成的持久存储付费)。

If you're using the CLI, copy jobs can be specified using the bq cp command.

如果使用CLI,可以使用bq cp命令指定复制作业。