Surfalytics
All pet projects
Data Engineering beginner ⏱ 5–7 hours

BigQuery: Google Cloud Data Warehouse

Get hands-on with BigQuery — Google's serverless data warehouse. Load data, run analytical queries, and understand cost management.

BigQueryGoogle CloudSQLData Warehouse
View project on GitHub

What you’ll build

A BigQuery project with real datasets loaded from GCS, analytical queries optimized for cost and performance, and an understanding of BigQuery’s unique architecture (slot-based compute, columnar storage, partitioning).

Skills you’ll practice

  • BigQuery dataset and table management
  • Loading data from Google Cloud Storage
  • Writing performant SQL: partitioning, clustering, materialized views
  • Understanding BigQuery pricing and query cost estimation