{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 孤傲高冷的网名 的问题《Changing project tier using web UI?》','https://www.manongdao.com/q-1024903.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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.