Capstone: apply, run, query

You have built every layer. Time to wire them: terraform apply provisions, push to main updates, Airflow triggers, Lambda extracts, Glue writes Iceberg, Snowflake reads. End to end. The capstone is one Airflow run plus one Snowflake query that returns the row you just produced.

The full lakehouse loop

Every layer wired. Every commit visible. Every read consistent.

Validation checklist: Capstone checklist

Loading practice…

Checkpoint: Course-wide checkpoint

Loading practice…

You now own a working AWS lakehouse: Lambda, S3, Glue Iceberg, Snowflake, Airflow, Terraform, CodeBuild. The same shape works on Databricks Unity Catalog, on Polaris, on Tabular. Pick the engines, swap the writers, the Iceberg storage layer stays the same. Next stop: the GCP analytics course.