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屋!