bq查询与目标表的定价 [英] Pricing of bq query with destination table

问题描述

我正在用目标表运行bigquery命令行查询

像bq查询--destination_table与src表中的一些select语句。

这是否会被视为加载数据或查询数据？

因为加载数据是免费的，查询数据将付出代价。

我的意图是通过对src字段的某些操作将一些数据从src移动到目标。所以bq查询与目的地看起来完全适合这一点。

解决方案

如果您正在运行查询，那么您需要为查询花费。您是否指定了目标表并不重要。如果你想避免查询的代价，你需要提取数据，执行你想要的任何转换，然后重新加载。

Im running bigquery command line query with destination table

like bq query --destination_table with some select statements from src table.

Whether this will be considered as loading data or querying data ?

Because, loading data is free and query data is going to cost.

My intention is to move some data from src to destination with some manipulations on src fields . So bq query with destination looks a perfect fit for this .

解决方案

If you are running a query, then you are billed for the cost of the query. It doesn't matter whether you have specified a destination table. If you want to avoid the cost of querying, you need to extract the data, perform whatever transformation you want, and then load it again.

这篇关于bq查询与目标表的定价的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！