Have you had a coding agent write dbt models or pipeline code and run the build for you?

Tools like Claude Code, Codex or Cursor read your project, write the model and tests, run them against a dev target and fix errors. You review the logic and the numbers.

How to automate it

How to automate “write dbt models, tests and transformations”

Here are 2 ways to spend less time on this, best first. Each comes with steps you can follow today and, for AI fixes, a prompt to copy.

90 min

typically, a few times a week

55%

of the time can be automated

Easy

to set up

Fix 1 of 2

AIBest fix

Use a coding agent on your dbt or pipeline repo

Claude Code, Codex, Cursor and Copilot can read the project, write models and tests, run dbt build and fix errors. You review the logic and the data it produces.

Typically saves about 30% of the time30 min to set up

1Add a short instructions file to the repo (CLAUDE.md or AGENTS.md) with naming conventions and how to run dbt and tests.
2Give the agent a well-scoped task with the prompt below.
3Let it run the build and tests against a dev target, never production.
4Review the SQL and check row counts against a known source before merging.

Prompt to copy

In this [DBT / AIRFLOW / DAGSTER] project, [TASK, e.g. add a model that calculates monthly active customers from events]. Follow the conventions in [EXAMPLE MODEL]. Add tests for [UNIQUENESS, NOT NULL, ACCEPTED VALUES] and a description for each column. Run the build against the dev target, fix any errors, and summarize what you changed plus anything you were unsure about. Do not run anything against production.

Tools: Claude Code, OpenAI Codex, Cursor or GitHub Copilot

Fix 2 of 2

Software feature

Use dbt's AI to generate docs, tests and semantic models

dbt Copilot and similar tools draft model descriptions, column docs, tests and semantic models from your SQL, which turns documentation from a chore into a review.

Typically saves about 50% of the time30 min to set up

1Turn on dbt Copilot in dbt Cloud, or use a coding agent with the dbt project open.
2Generate descriptions and tests for undocumented models; review and correct them.
3Require docs and basic tests on new models in your PR checklist.
4Publish docs in dbt Explorer or your catalog.

Tools: dbt Copilot · dbt Explorer · Claude Code, OpenAI Codex, Cursor or GitHub Copilot

Quick wins

Have you tried…

Have you had a coding agent write dbt models or pipeline code and run the build for you?: Tools like Claude Code, Codex or Cursor read your project, write the model and tests, run them against a dev target and fix errors. You review the logic and the numbers.

Who does this task

Roles in our library that list this as one of their common tasks. Each guide covers the rest of that role’s week.

Data engineer

HourLeak · the 8-minute work audit

How many hours does this cost you?

The free 8-minute check works out where your week goes and gives you your top fixes. The team scan does the same for everyone and adds it up, so you know which leaks to fix first.

Take the free check Scan my team, $49

Answers are anonymous. Leaders only see team totals.