Engagement · Paid Audit
Warehouse Audit
“Tell me what's wrong with my warehouse and what to fix first.”
A read-only read of the whole warehouse, and a prioritised list of what to fix in what order. We change nothing — that is the point, and it is why it is easy to say yes to.
In scope:
- A complete read of every model, table and dependency we can reach
- A prioritised fix map — what is worth fixing, in what order, and what to leave alone
- Metric sprawl named specifically: where the same number is defined more than once, and which definitions disagree
- Column-level lineage for the domains in scope
- A cost picture: which models burn the most, and what that implies for a rebuild
- A working session with a founder to walk the findings, not a PDF over email
What we need
- Read-only warehouse credentials
- Your dbt project, a folder of SQL, or a Glue catalog
- One named person who can answer questions about intent
How long
Out of scope:
- Any change to your warehouse — this engagement is read-only by design
- Rebuilding anything. That is the Medallion Rebuild
- Access to systems we do not need to see
What we mean when we say tested.
We generate the models, run them against your Snowflake or Athena connection, and check that each one returns rows, that its primary key is unique, that no column comes back completely empty, and that the types are what we said they'd be. On top of that we run dbt's own generic tests — not-null, unique, accepted values, and foreign keys against their parent — and hand you the schema.yml for them, so the tests we ran are tests you keep. Where a test can't be evaluated soundly it comes back marked skipped, never passed. We don't run a full dbt build, and we don't compare your old numbers against the new ones row by row. If a figure has to reconcile exactly, that's a conversation for the call.
Not here yet
Ships with the beta A single score for how ready your warehouse is for agents is not built yet. The findings this audit delivers do not depend on it; the score will summarise them, not replace them.
Written in future tense on purpose. Anything on this list is something we intend to ship, not something you would be buying today.
Scope the engagement in thirty minutes.
Bring the domain that causes the most difficulty. If it turns out this is not the right engagement for you, we will say so and point at the one that is.