使用Web UI更改项目层？ [英] Changing project tier using web UI?
问题描述
有两个问题：
- 可以使用Web UI更改我的层级吗？
- 更一般地说，什么是阶层？
- 阶层和定价之间的关系是什么？
$
上下文
我试图执行一个查询，以下错误：
错误：查询超出第1层资源限制。需要第292层或更高
。 （错误代码：billingTierLimitExceeded）
这是一个资源密集型查询，但它不是一项大工作。根据bq：
有效：此查询在运行时将处理433 MB。
BQ文档在 JOBS 部分。
但我不确定如何在使用WebUI时调整Tier。
错误代码：billingTierLimitExceeded未说明在排查错误页面
我检查了我的GCP控制台（API，配额等）的每个可以想到的角落，并且找不到任何可能表明我正在对我的帐户设置限制的任何内容。
定价页面没有列出有关层级和如何切换层级的任何信息。
我真的很感谢您的帮助。
早在十一月，谷歌宣布他们正在逐步淘汰针对高计算查询的选择性收费计费层。所有100岁以下的查询现在都计为1.因此，他们已从用户界面中删除了计费层选项。您可以在发布说明中阅读更多信息。我强烈建议查看您的查询并调整它以提高性能。您会惊讶的发现，根据BigQuery最佳做法进行的一些小改动会对计费层产生重大影响。
Two questions:
- Can I change my Tier using Web UI?
- And, more generally, what is "Tier"?
- What is the relation between "Tier" and "pricing" ?
Context
I am trying to execute a query but getting the following error:
Error: Query exceeded resource limits for tier 1. Tier 292 or higher required. (error code: billingTierLimitExceeded)
It is a resource intense query, but it is not a large job. According to bq:
Valid: This query will process 433 MB when run.
BQ Documentation mentions Billing Tier in the JOBS section. But I am not sure how to adjust Tier when using WebUI.
error code:billingTierLimitExceeded is not described on Troubleshooting Errors page
I have checked every conceivable corner of my GCP console (api, quotas etc) and could not find anything that would indicate that I am hitting a limit on my account.
Pricing page does not list anything about Tiers and how to switch Tiers.
I would really appreciate your help.
Back in November, Google announced that they were phasing out the opt-in billing tier for high-compute queries. All queries under 100 are now billed at 1. As such, they've removed the billing tier option from the UI. You can read more about it here in the release notes. I'd strongly recommended reviewing your query and tweaking it to improve performance. You'd be surprised that just a few small changes as per the BigQuery best practices can have a significant impact on the billing tier.
这篇关于使用Web UI更改项目层？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
