47% OFFYearly Pro
$30/mo$16/mobilled yearlyGet Pro
Masterclass

GCP analytics masterclass

GCS to BigQuery to dbt star schema, hosted on Cloud Run, scheduled by Airflow, deployed by Cloud Build, provisioned by Terraform.

Start this masterclass

Still deciding? Ask first.

Message a mentor about fit, prerequisites, or where to start. Replies come on WhatsApp, usually within a day.

  • Curriculum fit, prerequisites, or where to start
  • Honest answer, no pressure to enroll

Engineers are learning here from

NVIDIAMICROSOFTGRABWISEPIPEDRIVEBOLTGLIA

Outcome

What you'll be able to do.

Operate a GCP analytics stack end to end. Defend BigQuery and dbt against the obvious alternatives. Ship a dbt project on every push to main.

  • Pick BigQuery on-demand versus slot reservations on technical merit
  • Author a dbt project with sources, freshness, stg cleaning, marts star schema, and BI aggregates
  • Host the dbt runner on Cloud Run with a Flask /run_transformation endpoint
  • Secure the runner behind Cloud Run IAM with identity tokens
  • Trigger the build from Airflow with proper service account auth
  • Wire Cloud Build for push-to-deploy and Terraform for the foundation

Projects you build

Portfolio pieces you can demo.

Each project ships as real code you run locally, not slides you watch. Walk into your next review with something on screen.

01Project

A versioned dbt project on BigQuery, hosted on Cloud Run

Take the Olist e-commerce dataset from raw CSVs to a star schema with BI-ready aggregate views. Wrap dbt in a Flask app, ship to Cloud Run, schedule with Airflow.

BigQuerydbtCloud RunCloud BuildGCSAirflowTerraform

You ship: A working pipeline where a git push redeploys the dbt runner and a scheduled DAG triggers builds that land curated marts in BigQuery.

Curriculum

What's inside.

  1. 01

    GCP analytics with BigQuery, dbt, and Cloud Run

    GCS to BigQuery to dbt star schema, with Cloud Run hosting the dbt runner and Cloud Build deploying on push. Airflow schedules the run. Terraform owns the infra.

Who it's for

Is this for you?

Analytics engineers

maintaining a pile of one-off SQL queries in BigQuery and wanting a real dbt project with version control and tests

Data engineers

asked to build a GCP analytics stack and looking for a reference end-to-end pattern instead of a tutorial-of-the-week

Backend engineers

inheriting a Cloud Run dbt runner and needing to understand how Flask, dbt, identity tokens, and Cloud Build cooperate

Platform engineers

wiring Cloud Build, Cloud Run, Artifact Registry, and IAM for the first time

What you'll earn

Ship it, earn it.

BigQuery picker

Defend BigQuery against the alternatives

dbt author

Ship a star schema with sources and tests

Cloud Run operator

Host dbt with identity-token auth

GCP analytics engineer

Complete the GCP analytics masterclass

Pricing

Pick the path that fits.

Self-paced forever, or mentor-led when you want live feedback.

FAQ

Frequently Asked Questions

Do I need a real GCP project to take this masterclass?
No. The smoke test runs locally with a dbt-duckdb shim profile, the Flask app boots without GCP credentials, and Terraform validate works without a real backend. Deployment chapters show the GCP Console for when you want to deploy.
Why Cloud Run instead of Cloud Functions or Composer?
Cloud Run runs containers, so you ship the exact dbt image you tested locally. Cloud Functions is too restrictive for the dbt runtime. Composer is overkill (and expensive) for a single dbt job. Cloud Run is the goldilocks middle.
Will the dbt patterns transfer to Snowflake or Postgres?
Yes. dbt is engine-agnostic. The course uses BigQuery-specific features (partitioning syntax) but the project structure, source freshness, and star schema patterns are identical across adapters.
Do I need prior BigQuery or dbt experience?
No. The course assumes Python and SQL fluency, which the medallion foundations course provides. BigQuery and dbt are introduced from first principles, including pricing models and project anatomy.

Pick your next step.

GCS to BigQuery to dbt star schema, hosted on Cloud Run, scheduled by Airflow, deployed by Cloud Build, provisioned by Terraform.

Start this masterclass

GCP analytics masterclass

Self-paced masterclass

Enroll