close
Skip to main content

About dbt Wizard in the dbt platform PreviewStarterEnterpriseEnterprise +

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.

Share your feedback!

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 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.

In approval mode, dbt Wizard shows every file change as a diff before anything is persisted. Built-in dbt Agent Skills encode dbt best practices for consistent output. An admin must enable dbt Wizard for your account before you can use it in the platform.

Supported AI providers​

dbt Wizard​

dbt Wizard supports different AI providers depending on where you use it.

Providerdbt Wizard in dbt platformdbt Wizard CLI
OpenAI✓ (managed or BYOK)✓ (OpenAI subscription or BYOK)
Anthropic✓ (BYOK)✓ (BYOK)
Azure AI Foundry / Azure OpenAI✓ (BYOK)✓ (BYOK)
AWS Bedrock-✓ (BYOK)
Snowflake Cortex-✓ (BYOK)

  • Configure dbt platform integrations in account settings. BYOK is available for Enterprise and Enterprise+ plans.
  • Configure BYOK for the CLI. For OpenAI subscription support in the CLI, run wizard providers configure openai_subscription and 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.

tip

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​

Image

Enable AI in dbt

Turn on dbt Wizard and dbt Copilot for your account in the dbt platform.
Image

Wizard in Studio IDE

Leverage agentic development in the Studio IDE for governed data development in dbt.
Image

Wizard home tab

Use the agent-native home tab to iterate in natural language, review inline diffs, and validate changes.
Image

dbt AI FAQs

Common questions about availability, data handling, and billing.

Was this page helpful?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

0
Loading