SQL to dbt
Practical guides to moving data off old systems and into the cloud: step by step migrations, errors and how to fix them, legacy file formats, and SQL to dbt. Every guide is tested on real databases and cites the official documentation.
All · Migration guide · Tip · File rescue · SQL to dbt · Error fixed · Comparison
- SQL to dbtNovember 13, 2026
dbt Incremental: Merge vs Delete+InsertOn Postgres, dbt merge updates rows in place, delete+insert deletes and re-inserts them, append duplicates them. None removes rows deleted in the source.
- SQL to dbtNovember 6, 2026
dbt Incremental Models, Shown with Real RunsHow dbt incremental models work, run by run on Postgres: is_incremental(), {{ this }}, unique_key, late rows and lookback, --full-refresh, on_schema_change.
- SQL to dbtOctober 30, 2026
SQL to dbt: One Query Becomes One ModelConvert a SQL query to a dbt model: sources, CTEs, ref(), a var for now(), tests, and an EXCEPT check proving the same rows come back.
- SQL to dbtOctober 12, 2026
Convert a Stored Procedure to dbt ModelsTurn each INSERT, UPDATE, DELETE and MERGE in a stored procedure into a dbt SELECT, then prove parity with EXCEPT. Shown on a real PL/pgSQL run.