BigQuery for Data Warehousing: Managed Data Analysis in the Google Cloud

© Mark Mucchetti 2020

M. MucchettiBigQuery for Data Warehousinghttps://doi.org/10.1007/978-1-4842-6186-6_4

4. Managing BigQuery Costs

Mark Mucchetti¹ 

(1)

Santa Monica, CA, USA

 

One of the most difficult questions to answer when building out a BigQuery implementation is how much it will cost. In a traditional model, you would answer questions about scale and storage before you began provisioning the system. With BigQuery, as we saw in Chapter 1, you can start loading and querying immediately without even understanding the cost model.

Managed, serverless models have different pricing models than regular cloud compute resources. Most prominently, you only pay for what you use. This means that your costs scale linearly with respect to your usage. You won’t ...