dbt AI FAQs
Answers to common questions about dbt AI features, including dbt Wizard and dbt Copilot.
dbt Wizard is an AI-powered assistant fully integrated into your dbt experience that handles the tedious tasks, speeds up workflows, and ensures consistency, helping you deliver exceptional data products faster.
dbt Labs is committed to protecting your privacy and data. This page provides information about how dbt Wizard handles your data. For more information, check out the dbt Labs AI development principles page.
Overview
What is dbt Wizard?
dbt Wizard is the latest and recommended agentic experience for governed data development in dbt, available in both the dbt platform and the terminal CLI. It helps teams ship trusted dbt changes faster and with less risk by understanding project context, routing to the right dbt tools, validating changes, and supporting review before changes are persisted.
Use dbt Wizard to investigate lineage and downstream impact, generate or refactor SQL from natural-language prompts, create documentation, data tests, metrics, and semantic models, and validate changes with warehouse awareness.
In the dbt platform, dbt Wizard is available in the Studio IDE and the dbt Wizard home tab. dbt Copilot is available in Canvas and Insights.
In the CLI, you can use dbt Wizard from your terminal for local development workflows.
Where can I find dbt Wizard?
dbt Wizard is available in the dbt platform and as a terminal CLI.
- In the platform, you can use dbt Wizard in the Studio IDE for governed data development in dbt.
- In the CLI, use the dbt Wizard CLI for local development and automation.
To use dbt Wizard in the platform, you need a dbt Starter, Enterprise, or Enterprise+ account, and an admin must enable AI features for your account.
What are the benefits of using dbt Wizard?
dbt Wizard helps teams ship trusted dbt changes faster and with less risk. Use it to:
- Ask project-aware questions and investigate lineage, dependencies, and downstream impact.
- Generate or refactor SQL from natural-language prompts.
- Generate documentation, tests, metrics, and semantic models.
- Validate changes with warehouse awareness before review.
- Review proposed file changes as diffs before they are persisted.
dbt Wizard is built into dbt experiences with dbt governance, privacy, and security controls.
Is dbt Wizard the same as dbt Copilot?
No, dbt Wizard and dbt Copilot are separate products.
dbt Wizard is the latest and next generation of agentic product available in the dbt platform and as a CLI. It uses your project context to help you develop governed dbt changes faster. Think of it like a smart AI agent that has a map of your project. Instead of having to read through each file and understand the context, it can answer questions and help you develop and validate your changes faster.
dbt Copilot features for those who have access to them, include quick-action buttons in Studio IDE, the Copilot pane in Insights and Canvas.
Can I use my existing dbt Copilot action allotment with dbt Wizard?
No, dbt Copilot actions apply only to dbt Copilot usage. Refer to dbt Wizard billing and AI access FAQs.
Availability
Who has access to dbt Wizard?
In the dbt platform:
When enabled by an admin, dbt Wizard is available to users with a dbt developer license on Starter, Enterprise, and Enterprise+ accounts.
In the CLI:
For dbt Wizard CLI, bring your own API key or credentials for a supported provider using BYOK: OpenAI, Anthropic, Azure AI Foundry, AWS Bedrock, Google Gemini, or Snowflake Cortex (preview). Install and configure the CLI on your local machine. BYOK means any token costs will be billed directly by whichever provider you choose.
Refer to Use dbt Wizard locally for more information.
Is dbt Wizard available for all deployment types?
Yes, dbt Wizard is deployed everywhere including multi-tenant and single-tenant deployments.
How it works
Which AI model providers does dbt Wizard use?
-
For dbt-managed inference, Wizard can be used with several frontier models including models provided by OpenAI and Anthropic as well as several open weight models either in the dbt platform or the CLI. By default, accounts use managed OpenAI.
-
For BYOK, you can bring your own key either in dbt platform or the the CLI.
Refer to Model Provider Rate table and Service Consumption Table for more information.
Do we support BYOK (bring your own key) at the project level?
In dbt platform, the dbt Wizard BYOK option is currently an account-only configuration. However, there may be a future where we make this configurable on a project-level.
dbt Wizard CLI supports BYOK locally for OpenAI, Anthropic, Azure AI Foundry, AWS Bedrock, Google Gemini, and Snowflake Cortex (preview).
Privacy and data
This section covers dbt Wizard in the dbt platform. For what the CLI collects and how to opt out, refer to dbt Wizard CLI data use and telemetry.
Does dbt Wizard access my warehouse data?
dbt Wizard can run dbt commands and queries on your behalf, and every query needs your explicit permission first. When a query runs, dbt Wizard sends those results — which may include row-level data — to the AI provider so it can respond in your session.
For dbt-managed AI providers, we have zero data retention (ZDR) agreements in place that prevents the provider from retaining or using this data for training. If you bring your own AI provider (BYOK), that provider's terms will govern retention and training. Always review AI output for accuracy.
Refer to Model Provider Rate table and Service Consumption Table for more information.
Does dbt Wizard store or use personal data?
dbt Wizard stores your conversation history — including your prompts, responses, and any query results returned during your session — so you can revisit past chats. Conversation history is retained for 90 days; feedback you submit on a dbt Wizard conversation is retained for 400 days. You can delete your conversation history or feedback at any time in the product.
You control the information you submit to dbt Wizard. dbt Labs does not use your prompts, conversation history, command results, or feedback to train AI models.
Is my data used by dbt Labs to train AI models?
No. dbt Labs does not use customer content processed by dbt Wizard — including warehouse query results, prompts, or conversation history — for AI model training. A zero data retention (ZDR) policy is also in place with AI providers, which prevents training on the provider side as well.
Does dbt Labs share my personal data with third parties?
dbt Labs only shares client personal information as needed to perform the services, under client instructions, or for legal, tax, or compliance reasons.
Can dbt Wizard data be deleted upon client written request?
Yes. dbt Wizard conversation history is retained for 90 days by default, feedback you submit on a dbt Wizard conversation is retained for 400 days, and you can delete this information in the product at any time. To the extent a client identifies personal or sensitive information uploaded to dbt Labs systems, that data can be deleted within 30 days of written request.
Does dbt Labs own the output generated by dbt Wizard?
dbt Labs will not dispute your ownership of any output (e.g., code or artifacts) that are unique to your company generated when you use dbt Wizard. Your code will not be used to train AI models for the benefit of dbt Labs or other third parties, including other dbt Labs customers.
Does dbt Labs have terms in place?
dbt Wizard is governed by our Terms of Use. In the event clients prefer additional terms, clients may enter into the presigned AI & Beta Addendum (the dbt Labs signature will be dated as of the date the client signs). Contact your account manager for more information.
Clients who signed with terms after January 2024 don't need additional terms prior to enabling dbt Wizard. Longer term clients have also protected their data through confidentiality and data deletion obligations. In the event clients prefer additional terms, clients may enter into the presigned AI & Beta Addendum (the dbt Labs signature will be dated as of the date the client signs).
Considerations
What are the considerations for using dbt Wizard?
- dbt Wizard is not available in the dbt API.
Future releases are planned that may bring dbt Wizard to even more parts of the dbt application.
dbt Wizard allowlisting URLs
Allowlisting URLs
dbt Wizard doesn't specifically block AI-related URLs. However, if your organization use endpoint protection platforms, firewalls, or network proxies (such as Zscaler), you may encounter the following issues with dbt Wizard:
- Block unknown or AI-related domains.
- Break TLS/SSL traffic to inspect it.
- Disallow specific ports or services.
We recommend the following URLs to be allowlisted:
For dbt Wizard in the IDE:
/api/ide/accounts/${accountId}/develop/${developId}/ai/generate_generic_tests/.../api/ide/accounts/${accountId}/develop/${developId}/ai/generate_documentation/.../api/ide/accounts/${accountId}/develop/${developId}/ai/generate_semantic_model/.../api/ide/accounts/${accountId}/develop/${developId}/ai/generate_inline/api/ide/accounts/${accountId}/develop/${developId}/ai/generate_metrics/.../api/ide/accounts/${accountId}/develop/${developId}/ai/track_response
For dbt Copilot in Canvas:
/api/private/visual-editor/v1/ai/llm-generate/api/private/visual-editor/v1/ai/track-response/api/private/visual-editor/v1/files/${fileId}/llm-generate-dag-through-chat
Was this page helpful?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
