What to know when working with Google’s Data Warehouse
Best Practices when working with Google’s BigQuery
How to optimize Usage and Costs
6 min readAug 24, 2021
BigQuery is a SaaS (Software as a Service) Data Warehouse technology and will charge you in a pay for what you use pricing model. In this short article, I want to show you what the prices are and how you can optimize your use.
Which Actions do actually cost money?
The good thing first — a few actions within BigQuery are for free, like:
- Load Data (From a Bucket e.g)
- Extract Data (To a Google Sheet e.g)
- Copy Data (To a new table e.g)
- Delete Tables, Views and Datasets
- Cluster and Partition Tables
But you can probably guess that the most common activities such as storage and querying do cost some money. Especially the last function is the one that Google uses for earning money. For more details visit Googles BigQuery pricing [1].
How much do the Actions cost?
The common overview will give you a first insight of what the costs of the most common tasks in BigQuery look like:
