dbt without the warehouse (or the bill): DuckDB end to end
Somewhere along the way we all agreed that transforming a few gigabytes of data requires renting a distributed system by the second. Every dbt run becomes a round-trip you didn't need to take: slow, metered, and queued behind your colleagues' CI jobs. If your whole project fits in a few hundred GB, this is a strange way to live, and you can stop. DuckDB is a free, MIT-licensed, in-process analytical database — no server, no account, no invoice — and it now runs in public beta on the dbt Fusion engine. That means sub-second model iteration on your laptop, full-project CI in seconds on a plain GitHub runner, and Python models that run in-process without your data going anywhere. Add DuckDB's native readers for Parquet, Iceberg, and Postgres, DuckLake for publishing your output tables in open formats, and DuckDB-WASM for querying them straight from the browser, and the warehouse becomes optional at every stage — not just development. You'll see a real dbt project developed, tested, deployed, and served entirely on DuckDB, live on stage, on more data than you'd think reasonable. Your data is not that big. Your bill doesn't have to be either.
Check out more sessions
- Breakout session
From DML soup to dbt structure: Ecolab's migration story
Tomasz Kaczmarek / EcolabChiel Fernhout / DatafoldView session - Breakout session
The next wave of data infrastructure is in the Lake
Russell Christopher / dbt LabsCasey Karst / FivetranView session - Lightning talk
Your dbt models deserve better data
Niraj Vora / FivetranView session
