◮
Modelith
drift
The model and the warehouse, always in lockstep.
mdl — ibor
$
mdl drift -m model --manifest …/manifest.json
no drift detected
# a teammate adds a broker_code column to the warehouse
$
mdl drift … --check
drift vs target
'duckdb_dev'
:
[additive] 1
- column transaction.broker_code exists in dbt but not the model
$
mdl drift … --reconcile
reconciled 1 delta(s); skipped 0 breaking
+
add column transaction.broker_code
$
mdl drift -m model --manifest …/manifest.json
no drift detected
$
model
transaction
🔑 transaction_id
string
trade_date
date
amount
decimal
portfolio_code
FK
string
counterparty_id
FK
bigint
broker_code
string
warehouse (dbt)
transaction
🔑 transaction_id
string
trade_date
date
amount
decimal
portfolio_code
FK
string
counterparty_id
FK
bigint
" data-cls="whBroker" data-clsbase="drow
">
broker_code
string
+ additive
✓ reconciled — nothing lost