← Google Cloud Platform learning pathGoogle Cloud Platform · Module 7 of 10
Data analytics with BigQuery
Analyse huge datasets with serverless SQL.
📖 Key ideas
- BigQuery is a serverless data warehouse.
- Query terabytes with standard SQL in seconds.
- Pricing by bytes scanned (on-demand) or slots (capacity).
- Partition and cluster tables to reduce cost.
- Public datasets are available to practise.
💡 Real-life example: BigQuery is a super-librarian who reads millions of books in seconds, charging per page read.
BigQueryServerless data warehouse
Bytes scannedData read by a query, used for pricing
Partitioned tableTable split by date/column
Public datasetsFree datasets to query