How to set the right Billing Tier in Google BigQuery? -
please let me know how calculate , set right billing tier in google bigquery. i have built queries. of them process 3 tables of each 50 gb , other queries process tables of each 100-200 gb. i don't prefer run smaller queries high billing tier. as stated in docs , don't set directly billing tier you'll running query rather set maximum tier allow bigquery reach finishing given job. as can see in job resource definition, can define query method parameter maximumbillingtier sets how costs can potentially rise query complete successfully. still, keep in mind many high-compute queries can optimized changing few techniques in query, such using analytical functions, arrays , structs, subqueries , on. given working relatively small data bigquery, can find great ways optimize query , not have processing high-computing query.