Mozilla Automation TeamWill Lachance2 min readintermediate
Glean Dictionary + DuckDB
Summary
A short post describing how the Mozilla Glean Dictionary JSON can be exported into a DuckDB file via a simple ETL script, enabling SQL queries and notebook‑driven analysis of metric types and growth over time.
- Exporting static JSON docs to DuckDB is a one‑step ETL that produces a portable, queryable data product.
- SQL queries can quickly surface metric type counts (e.g., 20k counters, 7k events).
- A Marimo notebook can track metric count trends, showing a notable jump in 2024 when Firefox Desktop adopted Glean.
Treating documentation as data lets teams can reuse the same source for dashboards, analytics, or custom UI without re‑parsing JSON each time, leveraging DuckDB’s low‑overhead, server‑less SQL engine.
5/10
