dbtBuilt for dbt teams

AutoDBTTM

Half your dbt code is dead.

We bury it safely.

For data leaders who know something's wrong, but can't quantify it yet.

Start nowSee how it works
github.com/loyalty-co/dbt · PR #1842
Open

Merge fct_orders_enriched into fct_orders

zingle-bot opened 2 minutes ago · cleanup/merge-fct-orders → main

+47-132·7 readers verified·95% SQL matchsaves $3,200/mo
Equivalence report100% row match across 12.84M rows
Blast radius17 readers verified · all preserved
Backfill planidempotent · 60s rollback if needed
CI · dbt buildpassed in 4m 12s

$47k

average monthly warehouse spend recovered

per team, in first 90 days

40%

of dbt models are never read after 90 days

sitting in your repo right now, costing money

minutes

from connecting your repo to your first PR

not days. AutoDBT scans and acts immediately

Find the debt

See the debt in your repo.
Ranked by what it costs you.

Near-duplicate models

fct_orders_enriched

$3.2k/mo
97% SQL match

fct_orders

$2.8k/mo
97% SQL match
filter scope differs · merge safe

Duplicate models

95% the same. One different filter. That is why your numbers do not tie. AutoDBT finds every near-duplicate and ranks them by cost overlap.

Logic drift detected

mart_revenueupdated 2d ago
stg_revenue_v1stale · 14d
stg_revenue_v2stale · 14d
2 siblings out of sync

Logic drift

One model updates. Siblings do not. AutoDBT flags every stale copy before the inconsistency hits a dashboard.

Zero reads · 90+ days

4 models · $2.1k/mo
stg_old_events180d$890/mo
fct_legacy_orders120d$650/mo
dim_deprecated_users90d$340/mo
mart_v1_revenue90d$220/mo

Dead code

Zero reads in 90 days. AutoDBT lists every unused model, macro, and source, sorted by what it costs you to keep running it.

This month

$4,218

Recoverable

63%

Top cost drivers

fct_session_agg$312/mo
stg_order_events$221/mo
mart_revenue_daily$134/mo

Cost attribution

Warehouse spend, model by model. The expensive ones are usually the ones nobody owns. Now you know exactly what to fix first.

Ship it safely

Every change comes with proof.
Your team decides what merges.

Row-level equivalence

12.84M rows
100%match

Tolerance

0.01%

Scope

mart_orders

Regions

all · passed

Runtime

4m 12s

Equivalence testing

Row-level diff before every merge. Configurable tolerance. If output drifts by even 0.01%, the PR is blocked automatically.

Downstream readers · all preserved

Looker dashboards3 boards
Hightouch syncs2 syncs
ML feature store1 model
Hex notebooks4 owners

Blast radius

Looker. Hightouch. Notebooks. ML. AutoDBT maps every downstream reader before you change anything. Nothing is a surprise.

Merge fct_orders_enriched

cleanup/fct-orders → main

Open
Zzingle-bot · 2m agoPR #1842
Assigned to @data-eng-team via CODEOWNERS
Awaiting 1 reviewer approval

PR authorship

AutoDBT opens the PR with reasoning, proof, and context. Reviewers are picked from your CODEOWNERS file. You own the merge.

Soft-deleted · 30d quarantine

stg_old_events

ExpiresJun 22, 202623d remaining

One-command rollback

zingle restore stg_old_events

Nobody has objected in 7d

Quarantine

Soft-delete first. 30-day window. Anyone shouts, restore in one click. Nobody shouts in 30 days? It is gone for good.

Book a demo

See what is hiding in your repo.

Point us at your dbt project. We will show you the rest.

Start now