AIToday
Large Language ModelsAI Coding AssistantsZenn AI/MLPublished: Oct 9, 2026, 22:00 JST

dbt Wizard vs Claude Code: same tasks, deeper checks, $3.17

dbt Wizard vs Claude Code: same tasks, deeper checks, $3.17

The author ran five identical dbt prompts through dbt Wizard and Claude Code, both on claude-sonnet-5. Tasks 1–3 converged on nearly the same code; on the churn task, Wizard flagged that a 90-day threshold left 0 churned customers with order history, while Claude Code shipped 90 days silently.

Not sure about something? Ask the AI

Questions and answers are published on this page.

Summaries like this, in your inbox every morning.

Context & Analysis

The test put both agents on the same underlying model, claude-sonnet-5, so any difference reflects agent design rather than the model. dbt Wizard's edge comes from how it engages the project: before editing it checks upstream and downstream impact, it confirms dbt_utils was not installed before writing tests, and on the churn logic it did not hard-code the 90-day threshold, instead pulling it into a variable.

The contrast on the ambiguous churn task was the clearest. Wizard compared 90-day and 30-day thresholds against real data and reported that 90 days produced no churned customers with order history. Claude Code hard-coded 90 in the SQL. Claude Code shipped faster: roughly 23 to 58 seconds per task versus Wizard's 4 minutes 36 seconds on task 1 and 4 minutes 44 seconds on task 5.

The author's team already runs Claude Code with dbt rules in place, so their preference is to enrich Skills rather than pay for a second agent. Still, for teams without that setup, Wizard's default habits — checking git diff before fixes, verifying with dbt build, and testing whether a chosen threshold produces meaningful segments — stand out as practices Claude Code needed to be told to follow.

FAQ
How much did dbt Wizard cost for these tests?
The tested tasks totaled $3.17 in BYOK Anthropic API usage. This is not a dbt Labs fee but the model usage cost.
What is dbt Wizard?
It is an AI agent from dbt Labs specialized for dbt development. The CLI version is in public beta as of September 2026.
Which tasks showed the biggest difference?
The debugging task and the vague-requirements task. Wizard treated a column rename as intentional and aliased downstream to preserve public column names, while Claude Code reverted it.

AI news that matters for your work, delivered every morning.

Pick your industry and the AI tools you use, and get news related to your work every day.

Free · 30 seconds with Google · unsubscribe anytimeWhat is AIToday? →

Ask AI

Ask AI anything about this article. The AI reads this article, earlier AIToday articles, and Wikipedia, and cites its sources. Q&As are published on this page for other readers too.

Questions and answers are published on this page.

Related Articles

Next articleIIHS: self-driving cars see 68% fewer crashes