🗄️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
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;Common mistake
Key takeaways
- 1Serverless. No machines to size or run.
- 2Pay per bytes read. On the default on-demand plan.
- 3Plain SQL. Standard SQL over huge tables.