Tag: DuckDB
All the articles with the tag "DuckDB".
-
Synthea vs SynPUF: picking synthetic healthcare data for pipeline tests
Synthea simulates coherent patients and exports FHIR; SynPUF is perturbed Medicare claims. When to use each, and how to turn Synthea into a messy roster.
-
Migrating from SFTP to a roster API: dual-run and reconciliation
Cut over from CSV-over-SFTP to a FHIR roster API without a big bang: phased dual-run, DuckDB reconciliation of CSV vs NDJSON, and exit criteria.
-
The limit_zero macro bug: how dbt resolves macro names across packages
· UpdatedWhy a Tuva demo project failed with 'limit_zero' is undefined on DuckDB: bare macro names don't cross packages, dispatch is a second lookup, and the fix.
-
Connecting Streamlit to DuckDB: read-only mode and the lock problem
A Streamlit app reading from a DuckDB file while dbt might be writing to it requires read-only mode and careful connection handling. Here's the pattern that works.
-
dbt + DuckDB: the good, the bad, and the workarounds
Running dbt 1.11 with DuckDB 1.10 on a 167k-row dataset is fast and free, but the combination has real rough edges. An honest assessment after a full Tuva Project run.
-
DuckDB concurrency in 2026: why you can't run dbt and DBeaver at the same time
DuckDB's single-writer model means that opening a .duckdb file in DBeaver blocks dbt from acquiring its write connection. Here's the exact error, why it happens, and the right fix.
-
Running the Tuva Project on DuckDB — what breaks and how to fix it
Tuva 0.17.2 on DuckDB 1.10 with dbt 1.11 produces three distinct failure modes. This is what actually broke and how each one was fixed.