问题描述
我正在测试BigQuery表,并且我看到我可以修改maximumBillingTier以便需要大量资源来处理每个字节的源数据,但是我不清楚该如何修改这个字段。
你能举一个例子吗?我该如何修改这个字段?
可以更改每个查询的这个值吗?如所述
我还可以在WEB UI上更改吗?我发现没有任何文件显示如何完成这项工作。 解决方案
我正在测试BigQuery表,并且我看到我可以修改maximumBillingTier以便需要大量资源来处理每个字节的源数据,但是我不清楚该如何修改这个字段。
你能举一个例子吗?我该如何修改这个字段?
可以更改每个查询的这个值吗?如所述
我还可以在WEB UI上更改吗?我发现没有任何文件显示如何完成这项工作。 解决方案
maximumBillingTier
作为查询请求的一部分,与通过其他属性相同的方式
例如
请注意:maximumBillingTier是一个正整数,用作每TB 5美元的基本价格的乘数。请访问
了解详情
如果您想在bq命令行中使用它 -
USAGE:bq.py [--global_flags]< command> [--command_flags] [args]
尝试玩下面的全球旗帜
I am testing BigQuery tables and I saw that I can modify the maximumBillingTier in order to require a large amount of resources to process per byte of source data but it is not clear to me how can I modify this filed.
Can you show an example? how can I modify this field?
It is possible to change this value per query? as mentioned here
Can I also change in on WEB UI? I found no document showing how can this be accomplished
To run the query at a higher pricing tier, pass a new value for maximumBillingTier
as part of the query request, the same way as you pass other propertieshttps://cloud.google.com/bigquery/docs/reference/v2/jobs#configuration.query
like below for example
Please note: The maximumBillingTier is a positive integer that serves as a multiplier of the basic price of $5 per TB. see more at
https://cloud.google.com/bigquery/pricing#high-compute
if you want to make it from within bq command line -
USAGE: bq.py [--global_flags] <command> [--command_flags] [args]
try to play with below global flag
这篇关于我怎样才能改变maximumBillingTier?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!