Overture Member Summit 2026

DuckDB is rapidly becoming the FOSS tool of choice for fast, local analytics. Beyond being the onboarding tool for many to explore Overture data, DuckDB can also be used to build more powerful analytical tools. In this talk, we will discuss our experience at Fused using DuckDB and open source extensions like h3-duckdb to perform interactive cross-filtering and aggregation.

H3, an open source project originally developed by Uber, enables efficient entity conflation through fast spatial indexing for identity matching and deduplication, especially when combined with DuckDB for scalable local joins. This pairs naturally with Overture data and Overture’s Global Entity Reference System (GERS)—reducing reliance on brittle string matching and custom reconciliation pipelines.

In this talk, we describe the preprocessing and partitioning of Overture data, SQL analytics using DuckDB, and developing interactive and beautiful dashboards in the browser—highlighting how open, accessible entity IDs via Overture’s GERS and H3 make joining, sharing, and onboarding datasets dramatically easier.