Build log
Notes written while building AZIMUTH: what each phase set out to do, what the data turned out to support, and what changed along the way. Also available as an RSS feed.
- November 13, 2026 · AZIMUTH
Moving the daily refresh off Databricks
Databricks Free Edition stopped starting compute for the scheduled refresh. The same pipeline now runs every day on DuckDB inside GitHub Actions, with identical results.
Read the post - October 2026 · AZIMUTH
Phases 5 to 7: Daily refresh, the app and Ask AZIMUTH
The data now refreshes itself every day, the app is live, and you can ask it questions. How each part works and how it was tested.
Read the post - October 2026 · AZIMUTH
Phase 4: Analysis layer
What counts as one vehicle, reliability with confidence intervals, two pre-launch failures, and a model that was tested and not used.
Read the post - August 2026 · AZIMUTH
Phase 3: Gold layer
The star schema, a "Not published" row for launches with no orbit, six more Moon launches, and the same float bug again.
Read the post - August 2026 · AZIMUTH
Phase 2: Silver layer, and a scope change
dbt, the first silver model, tests and CI. Also: 7% of launches have no orbit, which changed how orbital launches are defined.
Read the post - August 2026 · AZIMUTH
Phase 1: Bronze ingestion
All 7,598 launches from the Launch Library 2 API into a Delta table, and the problems along the way.
Read the post - August 2026 · AZIMUTH
Phase 0: Scope
What the Launch Library 2 data can support, and the decisions written down before building anything.
Read the post