BigQuery.
BigQuery is Google Cloud's serverless data warehouse. There is no cluster to size or manage; queries are charged mostly by the volume of data they scan, which makes table design and partitioning a direct cost decision rather than only a performance one.
Where BigQuery fits on a long engagement.
The serverless model removes most operational work and replaces it with a design discipline. A query selecting every column from an unpartitioned table is correct, fast enough, and costs many times what the same result needed. Partitioning and clustering are the two decisions that most affect the monthly figure.
BigQuery is frequently the default for teams already in Google Cloud, particularly where analytics data arrives from GA4 or Firebase. That convenience is genuine, and it makes it more likely the warehouse grows without anyone explicitly owning its shape.
What an assigned team does with BigQuery.
Because BigQuery charges for bytes scanned, its cost curve is set by decisions made once, early, by whoever happened to create the table. Partitioning chosen in week two determines the bill in year two, and by then changing it means rewriting everything that reads from it.
Where the analytics estate has grown without an owner, the first assignment is usually inventory rather than building — and where the work turns out to be modelling rather than infrastructure, it moves toward data science capacity instead.
What we use BigQuery for.
- Analytics data at event granularity Raw event exports queried directly, rather than relying on a reporting UI's aggregation decisions.
- Cutting query spend Partitioning, clustering and materialised results applied to the queries that actually run, identified from usage rather than guessed.
- A warehouse without a platform team Central analytical storage for an organisation that has no appetite to operate a cluster.
How BigQuery capacity is assigned.
BigQuery work is assigned under data engineering outsourcing, working in your own project and billing account.
Tell us what your roadmap needs BigQuery for.
A service delivery manager replies with the disciplines we would assign, the monthly capacity and what the first month looks like.
Loading the contact form… You can also email hello@azendo.co.
We reply within one working day. No obligation, and no newsletter.