本文介绍了我怎样才能改变maximumBillingTier?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在测试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?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-01 21:29