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.