Tag: Data Engineering
All the articles with the tag "Data Engineering".
-
dbt macro resolution order: a real-world debugging story
A Compilation Error in a Tuva Project model revealed the exact resolution order dbt uses when looking up macros — and why that order matters when you're three packages deep.
-
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.
-
From raw claims to RAF: what the data pipeline actually looks like
The path from a raw Medicare claim file to a patient's Risk Adjustment Factor score involves five distinct transformation layers. This is what each layer does and where the dbt models fit in.
-
HCC suspecting explained from a data engineering perspective
HCC suspecting is about identifying conditions documented in prior years that haven't appeared in claims yet this year. This is what the data pipeline looks like and what the Tuva mart actually produces.
-
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.
-
The limit_zero macro bug: how dbt resolves macros across packages
A missing limit_zero macro in a Tuva Project run turned into a detailed lesson on how dbt resolves macros across package namespaces, adapter dispatch, and why the fix is a two-line local macro.
-
What 167k synthetic Medicare claims taught me about US healthcare data
Running the Tuva Project on 167k synthetic Medicare claims reveals the structural complexity of US healthcare data — before you've dealt with a single real data quality issue.
-
What is the Tuva Project and why should data engineers care
The Tuva Project is an open-source dbt package that transforms raw healthcare claims into analytics-ready mart tables covering HEDIS, HCC, CCSR, readmissions, and data quality. This is what it actually does and why it matters.