Skip to content
BENIBIX Learn

Google BigQuery

Also known as BigQuery, BQ

Google's warehouse with no servers to run. You pay for the data each query reads.

Think of it like

It is like a taxi instead of your own car. You never park it or fix it. You pay for each trip.

Example

A startup with no data team loads its app events into BigQuery. Its first month of queries costs less than a dinner out.

Why it matters

It removes the work of running a warehouse. Small teams can start with SQL on day one.

Definition

BigQuery is Google Cloud's data warehouse. It is serverless, so there are no machines to set up or size. You load data or point it at files, then query it with SQL. On the default plan you pay for how many bytes each query reads. Storage is billed on its own.

Example code

sql
SELECT name, SUM(number) AS total
FROM `bigquery-public-data.usa_names.usa_1910_current`
GROUP BY name
ORDER BY total DESC
LIMIT 3;
A query over a public table of US baby names. No server was set up first.

Common mistake

Running SELECT * on a huge table. You pay for every column read, so pick only the ones you need.

Key takeaways

  1. 1
    Serverless. No machines to size or run.
  2. 2
    Pay per bytes read. On the default on-demand plan.
  3. 3
    Plain SQL. Standard SQL over huge tables.