BigQuery is serverless and fully managed; it is also one of the most cost-effective offerings of GCP. This is probably also because BigQuery is often the first GCP service that prospective customers try out and getting the pricing on this right is very important to drive adoption.
Pricing details change pretty quickly, and the information here is current as of March 2018. Despite the ever-changing nature of cloud pricing, we have chosen to include this, because it shows, broadly, how BigQuery is priced and why it is such a cost-effective competitor in the data warehousing space.
Action |
Cost |
Storage |
$0.02/GB/month (first 10 GB/month free) |
Long-term storage (no edits for 90 days) |
$0.01/GB/month (first 10 GB/month free) |
Queries |
$5/TB (first 1 TB/month is free) |
Flat-rate for 2,000 slots |
$40,000/month |
Loading data |
Free |
Copying... |