CODEWITHSUNDEEP
google-bigquerygoogle-cloud-platform
Joe Scotto
Joe Scotto

Reputation: 10887

Change maximumBillingTier for BigQuery API?

I'm currently running a query that requires billing tier 4. When running my post request to the query endpoint, I'm setting "maximumBillingTier":4. I'm able to run the query successfully within the BigQuery console but not from my actual application with the API. My projects default billing tier is Tier 1.

Upvotes: 1

Views: 144

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 173106

if there is a way to change the billing tier for my project

You can submit the BigQuery High-Compute queries form to set a project-wide default

Update:

As per November 14, 2017 Release Notes -

High compute queries are being phased out so you are no longer required to opt-in. All high compute queries under tier 100 are billed as tier 1. Running a high compute query does not require setting a threshold flag.

All queries above tier 100 will fail with a RESOURCES_EXCEEDED_PER_BYTE error unless the query is running in a reserved instance. Existing users who have run a high compute query higher than tier 100 in the last 30 days retain the ability to run queries at the higher billing tier until October 31, 2018.

Upvotes: 1

Related Questions