Writing

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.

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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