About dbt Wizard
Your personal dbt agent — wherever you work.
dbt Wizard is an AI agent purpose-built for governed data development in dbt. Unlike general-purpose coding agents, it understands your dbt project through a native metadata engine — a structured index of lineage, model health, tests, contracts, run results, and semantic definitions.
Think of it like a map of your city: dbt Wizard knows how everything connects before it starts, rather than walking every street to figure out the layout.
dbt Wizard comes with the following capabilities:
- Project understanding: A native dbt metadata engine for lineage, contracts, tests, and runtime context
- Impact awareness: Checks upstream and downstream dependencies before you change code
- Safe validation: Compiles and builds changes before review
- Complete workflow: Investigate, change, validate, and review in one place
- Setup and governance: Works out of the box with dbt governance built in
Use dbt Wizard
dbt Wizard is for anyone doing dbt development — from analytics engineers working locally in the terminal to teams building in the dbt platform. You can use it in the platform with managed or bring-your-own-key (BYOK) credentials, or in the terminal with your own key, with or without a dbt platform account.
dbt Wizard is data warehouse agnostic and works with both the dbt Fusion engine and dbt Core — no specific engine is required.
The following table shows where dbt Wizard is available, the AI keys each surface uses, and how usage is billed:
| Where | Status | AI provider keys | Availability and cost |
|---|---|---|---|
| dbt platform — Studio IDE | Public preview | Managed keys, or BYOK | Managed usage is included with dbt AI by plan (not available on Developer). BYOK is available on Enterprise and Enterprise+. |
| dbt platform — dbt Wizard home tab | Public beta | Managed keys, or BYOK | Same as Studio IDE. |
| Terminal (CLI) | Public beta | BYOK, or OpenAI subscription | You pay your AI provider directly. Works with or without a dbt platform account. |
For included action limits by plan and how managed usage is metered, refer to the Billing page. To bring your own key, refer to supported providers on this page.
Supported AI providers
dbt Wizard
dbt Wizard supports different AI providers depending on where you use it.
| Provider | dbt Wizard in dbt platform | dbt Wizard CLI |
|---|---|---|
| OpenAI | ✓ (managed or BYOK) | ✓ (OpenAI subscription or BYOK) |
| Anthropic† | ✓ (BYOK) | ✓ (BYOK) |
| Azure AI Foundry / Azure OpenAI | ✓ (BYOK) | ✓ (BYOK) |
| AWS Bedrock | - | ✓ (BYOK) |
| Google Gemini | - | ✓ (BYOK) |
| Snowflake Cortex | - | ✓ (BYOK) |
† Anthropic enterprise and subscription licenses (such as Claude Enterprise) aren't supported per Anthropic's terms of service. BYOK requires an Anthropic API key.
- Configure dbt platform integrations in account settings.
- Configure BYOK for the CLI by running
wizard providers configure PROVIDER_NAMEand follow the prompts.
Get started with dbt Wizard
Available in public beta.
A terminal-based agent for governed data development in dbt, whether your team uses the dbt platform or self-hosts. Bring your own key to experience the full agentic analytics engineering loop.
If you've never used the terminal before, check out the terminal guide. Some tips include:
- Enter
/to see the available commands or try out/overviewto get a quick summary of your project. - Press
Shift+Tabto cycle through collaboration modes.
Install dbt Wizard as wizard on your PATH using the curl script for your operating system:
- macOS/Linux
- Windows
curl -fsSL https://public.cdn.getdbt.com/dbt-wizard/install/install-wizard.sh | sh
Run the following in PowerShell:
irm https://public.cdn.getdbt.com/dbt-wizard/install/install-wizard.ps1 | iex
Then verify the install and start a session:
wizard --version # confirm the install
wizard # start an interactive session
After running wizard --version, you should see something like dbt-wizard VERSION. Run wizard --help to see all available commands and flags. dbt Wizard installs default config files — refer to the config reference for more details.
Available in public preview.
Leverage agentic capabilities in the home app or Studio IDE for governed data development in dbt.
To get started:
- Make sure an admin has enabled dbt Wizard.
- Navigate to the dbt Wizard icon in the left sidebar of the dbt platform.
- Open a project in Studio IDE or the home app.
- Try a prompt, such as:
summarize what this project doeslist all models with no testsadd not_null and unique tests to the primary key of stg_customers
Refer to Use cases and examples for more prompts.
(Be warned, the wizard has been known to
.)Next steps
Now that you know where to start, continue with Get started with the local CLI for local installation and onboarding, or Get started in dbt platform for the platform setup flow.
Related docs
- dbt Wizard in Studio IDE — generate docs, tests, semantic models, SQL, and delegate end-to-end model work
- Use skills in the dbt platform — give dbt Wizard reusable instructions for your project
- Use MCP servers with dbt Wizard CLI — connect the dbt Wizard CLI to more tools and context
- Use subagents in the dbt platform — delegate work to specialized agents
- Migrate to dbt Wizard — switch from Claude Code, Cursor, or another AI agent to dbt Wizard
- Data & Privacy in the dbt platform — understand how dbt Wizard in the dbt platform handles privacy and data
Want to see dbt Wizard in action? Check out the demo video.
We'd love to hear how dbt Wizard is working for you. Share your feedback by either running the /feedback slash command in your interactive terminal session or by going to the #dbt-wizard channel in the dbt Community Slack.
Thanks so much for your help in improving dbt Wizard and dbt data development!
dbt Wizard is available in Studio IDE as a public preview feature, and as a standalone beta feature across the managed dbt platform. However, certain customers may have disabled experimental features, in which case, they can use Wizard CLI via terminal-access and will continue to have access to dbt Copilot until dbt Wizard is released as generally available to all customers. Contact dbt Support with any questions.
Please contact dbt Support with any questions
Was this page helpful?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
