Understand any inherited dbt model in seconds and know exactly what tests are missing.
Paste an existing dbt model and get a plain-English explanation, test coverage score, naming audit, complexity assessment and ready-to-add test YAML.
Free tier: 3 model audits per month · or unlock forever for $4.99
fct_orders — audited
No unique test on order_id
missing-unique-test
Model missing schema.yml description
no-description
SELECT * in staging CTE
select-star
Passed checks
✓ Uses {{ ref() }} correctly · ✓ No hardcoded schemas
Illustrative — actual issues depend on your model SQL and schema.yml.
Every card is something members actually do inside Datamata — not a vague promise.
Plain-English summary of what the model computes, where it reads from and who depends on it downstream.
Test coverage scored by column — not_null and unique gaps called out with ready-to-paste YAML fixes.
Convention violations and CTE complexity flagged before they become tech debt in a 200-model project.
Plain-English summary of what the model does and who depends on it
Feature deep-dives
See it work
Plain-English summary of what the model computes, where it reads from and who depends on it downstream.
Try dbt Auditorfct_orders — audited
No unique test on order_id
missing-unique-test
Model missing schema.yml description
no-description
SELECT * in staging CTE
select-star
Passed checks
✓ Uses {{ ref() }} correctly · ✓ No hardcoded schemas
Illustrative — actual issues depend on your model SQL and schema.yml.
Go deeper
Test coverage scored by column — not_null and unique gaps called out with ready-to-paste YAML fixes.
Browse all premium toolsIn practice
Convention violations and CTE complexity flagged before they become tech debt in a 200-model project.
Try dbt AuditorBuilt for Premium outcomes
Real decisions, not generic templates. Every workflow runs on live market data so your moves are backed by what employers are asking for now.
Plain-English summary of what the model does and who depends on it
Test coverage score with specific gaps called out by column
Naming convention audit against dbt and warehouse best practices
Quick start guide
Paste the model SQL and optionally the schema.yml to get a full audit including existing test coverage.
Drop in the SQL — CTEs, subqueries and Jinja macros all parse correctly.
Tip: Include the schema.yml block if you have it — the coverage score is more accurate with existing tests visible.
Review the plain-English summary, test gaps and naming flags in order of severity.
The generated schema.yml block is ready to paste into your project — review PK and column names first.
Tip: Add accepted_values tests manually for status and type columns — the auditor flags them but you know the valid set.
Run the dbt Model Generator for new tables and the Auditor for existing ones — same workflow, different starting point.
What's included
Plain-English summary of what the model does and who depends on it
Test coverage score with specific gaps called out by column
Naming convention audit against dbt and warehouse best practices
Ready-to-paste schema.yml test blocks for every flagged gap
Start free, upgrade when you need more.
Pro
$9.99/moUnlimited audits with full test generation and lineage hints
All 47 premium tools · Cancel anytime
Get ProDatamata Premium
Full depth across tools, higher limits where they apply and a single member hub tied to the same live posting engine.
Get Pro — $9.99/moCancel anytime · No lock-in
Salary, skills, employers and the Match Engine all read the same live posting feed — so you are not comparing a benchmark from 2022 against jobs from this week.
Get started free
Open the tool in your browser — no setup, no credit card. Upgrade to Pro when you want full depth across every Datamata tool.