Capstone: apply, push, run, query

You built every layer. The capstone wires them together. Terraform applies. Push to main triggers Cloud Build. Cloud Build deploys Cloud Run. Airflow triggers /run_transformation. dbt builds the marts. BigQuery returns the latest row. End to end.

The full GCP analytics loop

Every layer wired. Every commit visible. Every dashboard fresh.

Validation checklist: Capstone checklist

Loading practice…

Checkpoint: Course-wide checkpoint

Loading practice…

You now own a working GCP analytics stack: GCS, BigQuery, dbt, Cloud Run, Airflow, Cloud Build, Terraform. The same shape with engine swaps gives you Snowflake plus dbt, Redshift plus dbt, or Postgres plus dbt. The pattern transfers; the engines are the easy part.