dbt-transformation-adapter

Run governed dbt builds for silver and gold layers behind a human-approved mapping gate.

2|Updated Jun 22, 2026
One-click install
npx skills add https://github.com/Kemetra/Seshat-BI --skill dbt-transformation-adapter-kemetra
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-transformation-adapter
Source: https://github.com/Kemetra/Seshat-BI/tree/main/.claude/skills/dbt-transformation-adapter
Command: npx skills add https://github.com/Kemetra/Seshat-BI --skill dbt-transformation-adapter-kemetra

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires dbt-core, dbt-postgres.

What problem does it solve? Teams need dbt to build silver and gold warehouse models without letting the tool silently redefine business meaning, skip human approvals, or overwrite migration-built tables. This Skill enforces a governed execution path where dbt acts only as the build engine and every judgment call stops at a named human. ## Core Features & Use Cases - Gate-enforced execution: Refuses to run any dbt model unless the Mapping Ready stage shows pass with a matching named-human approval in the readiness files. - Governed command sequence: Uses the seshat dbt wrapper (doctor, validate, plan, build, test, inspect-run) with immutable plan digests so drift between planning and execution is rejected. - Reconciliation parity testing: Compares dbt-built gold tables against migration-built ones on row counts, key distinctness, money sums to the cent, and dimension member counts. - Use Case: After a retail source table's mapping is approved, run seshat dbt build to materialize the gold fact, record test results as evidence, and stop for a human to approve the Silver/Gold Ready stage. ## Quick Start Ask the agent to validate and build the gold models for an approved mapped table using the governed seshat dbt wrapper, then report the evidence and blocking reasons.

Frequently Asked Questions about dbt-transformation-adapter

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run dbt models for a mapped table in Seshat BI?▼

Run the governed sequence: seshat dbt doctor, validate, plan, then build with the accepted plan digest. Raw dbt commands are forbidden because they bypass the gate, selector, shadow-schema, and evidence contracts.

What is the Mapping Ready gate for dbt builds?▼

It is the first refusal point: mappings/<table>/readiness-status.yaml must show stages.mapping_ready.status as pass with a matching approvals entry, and the unresolved-questions.md mirror must show Gate status: CLEARED. Otherwise the run is refused and a blocking reason is recorded.

Can a green dbt test approve the Gold Ready stage?▼

No. A green dbt test is recorded only as evidence or blocking reasons. Moving Silver Ready or Gold Ready to pass always requires a named human approval citing that evidence.

How does dbt parity testing work against migration-built tables?▼

The parity test asserts equal fact row counts, preserved business-key distinct counts, additive money sums equal within 0.01, and equal per-dimension member counts. A mismatch records the delta as a blocking reason and keeps migrations as the default build path.

Does this adapter publish Power BI models?▼

No. dbt stops at gold and is DB-connected, not publish-capable. Power BI publishing belongs to the separately gated F016 adapter, which is currently parked.

Why does seshat dbt report [PENDING LIVE PROFILE]?▼

A live run needs the dbt extra, a database, and SESHAT_DBT_* values in the gitignored .env file. Without them, the skill reports the pending state and enable steps instead of faking compile, build, or parity success.