CODEWITHSUNDEEP
google-bigquery
aravindderajan
aravindderajan

Reputation: 77

How to set the right Billing Tier in Google BigQuery?

Please let me know how to calculate and set the right billing tier in Google BigQuery.

I have built queries. Some of them will process 3 tables of each 50 GB and other queries process the tables of each 100-200 GB.

I don't prefer to run the smaller queries with high billing tier.

Upvotes: 0

Views: 1491

Answers (1)

Willian Fuks
Willian Fuks

Reputation: 11797

As stated in the docs, you don't actually set directly which billing tier you'll be running a query but rather you set the maximum tier you allow BigQuery to reach for finishing a given job.

As you can see in the job resource definition, you can define for the query method the parameter maximumBillingTier that sets how much your costs can potentially rise for the query to complete successfully.

Still, keep in mind that many high-compute queries can be greatly optimized by changing a few techniques in the query, such as using analytical functions, arrays and structs, subqueries and so on.

Given that you are working with relatively small data for BigQuery, you probably can find great ways to optimize your query and not have it processing as a high-computing query.

Upvotes: 1

Related Questions