About dbt Wizard in the dbt platform Preview
dbt Wizard helps teams ship trusted dbt changes faster and with less risk. It uses native dbt metadata, routes to the right tools, and validates with warehouse awareness so teams can investigate, change, validate, and ship in one place.
dbt Wizard is more than a general coding agent with access to dbt. Built for governed data development in dbt, it understands lineage, documentation, tests, and semantic definitions, and accounts for dev builds, compute, run time, and post-build inspection. Its suggestions are grounded in your project's actual data and context.
An admin must enable dbt Wizard for your account before you can use it in the platform.
dbt Wizard comes with various features like:
- Built-in agent mode to help you manage agent control:
- Ask for approval mode allows you to review and approve each file change before dbt Wizard takes action
- Edit files automatically mode allows the agent to automatically make edits without approval.
- A simplified wayfinder bar shows your current project and branch and guides you through Git tasks, such as committing files or creating a branch.
- Built-in dbt Agent Skills encode dbt best practices for consistent output.
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) |
| Databricks Unity AI Gateway | - | ✓ (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.
Refer to the following pages for more information:
- Configure dbt platform integrations in account settings.
- Configure BYOK for the CLI by running
wizard providers configure PROVIDER_NAMEand follow the prompts.
Looking for the terminal experience? Visit About dbt Wizard CLI.
What you can do
Use dbt Wizard in the dbt platform to:
- Leverage agentic capabilities in the Wizard home tab or Studio IDE for governed data development in dbt.
- Ask project-aware questions and get context-grounded answers
- Generate documentation, semantic models, tests, and metrics
- Build or refactor models from plain-language prompts
- Review file changes as diffs before persisting
- Run end-to-end tasks in approval or automatic edit modes
For more examples, visit Use cases and examples.
Most of the workflows in How to use dbt Wizard in your dbt project apply here too — the prompts work the same in Studio IDE and the Wizard home tab.
Always review AI-generated content, as it may be incorrect. For prompt best practices, refer to the Prompt cookbook.
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
Get started in the dbt platform
Was this page helpful?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
