Skip to main content

Get started in dbt platform StarterEnterpriseEnterprise +

Enable AI features in dbt platform to speed up your development and focus on delivering quality data.

You can control AI features in dbt platform for dbt Wizard and dbt Copilot in your Account settings.

  • dbt Wizard: dbt's innovative and recommended agentic AI layer, available on the dbt platform and CLI.
  • dbt Copilot: Inline AI assistance (code generation, docs, tests, metrics buttons) in Studio IDE, as well as Canvas and Insights.

Both experiences are controlled by a single AI toggle in Account settings.

Prerequisites​

Enable AI features​

To opt in to AI features, a dbt admin can follow these steps:

  1. Navigate to Account settings in the navigation menu.
  2. Under Settings, confirm the account you're enabling.
  3. Click Edit in the top right corner.
  4. Enable the Enable account access to AI features option.
  5. Click Save. You should now have AI features enabled for use.

Note: To disable (only after enabled), repeat steps 1 to 3, toggle off in step 4, and repeat step 5.

Try your first prompt​

After AI features are enabled, open dbt Wizard from the left sidebar in the dbt platform. You can use it from the home tab for an agent-native workflow, or from Studio IDE when you want to work alongside the file editor.

Try a prompt such as:

  • summarize what this project does
  • which models in this project have no tests?
  • add not_null and unique tests to the primary key of stg_customers

Use the home tab to investigate, generate, review diffs, and run validations. Use Studio IDE when you want direct file control with the editor, console, and file explorer.

Next steps​

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

dbt Copilot​

dbt Copilot supports different AI providers, including bring your own key (BYOK) for Enterprise and Enterprise+ plans:

  • dbt Labs-managed OpenAI API key
  • BYOK OpenAI API key
  • BYOK Azure OpenAI API key

Snowflake Cortex, AWS Bedrock, Azure AI Foundry, and Anthropic aren't supported for dbt Copilot.

 What's the difference between dbt Wizard and dbt Copilot?
info

dbt Wizard is the new and recommended AI agent for governed data development in dbt. It handles the full development lifecycle — investigation, building, validation, and shipping — grounded in your dbt project's lineage, tests, contracts, and metric definitions.

dbt Copilot is separate from dbt Wizard and is dbt's inline AI assistance experience, providing single-click generation of SQL, documentation, tests, and semantic models in Studio IDE, Canvas, and Insights.

Refer to dbt AI FAQs, Billing, and dbt's Terms of Use for more information.

Configure AI provider EnterpriseEnterprise +​

Once AI features have been enabled, Enterprise and Enterprise+ accounts can configure a custom AI provider. If you bring your own provider, you will incur API calls and associated charges from that provider.

* Managed (or Managed by dbt Labs): dbt Labs manages the AI provider connection; no user provider key is required. Refer to Billing for more information.

dbt Wizard​

To configure your AI provider for dbt Wizard:

  1. Click on your account name and select Account settings in the side menu.
  2. Under Settings, click AI features.
  3. Under AI providers, click Edit to configure the AI integration.
  4. For each provider, select your Key management option from the dropdown.

Managed* by dbt Labs (default, no setup required). Refer to Billing for more information.*

  1. Select the toggle for dbt Labs to use dbt Labs' managed* OpenAI key.
  2. Click Save.
Example of the dbt Labs integration pageExample of the dbt Labs integration page

Managed by you (Enterprise or Enterprise+ plans)

  1. Select OpenAI from the options.
  2. Enter your OpenAI API key.
  3. Click Save.
Example of the OpenAI integration pageExample of the OpenAI integration page
Data residency limitation

OpenAI projects with data residency controls enabled and configured for the United States (project region set to US) don't currently support BYOK. These projects can only use the API key in the dbt platform configuration. Specifying custom endpoints required for data residency isn’t yet supported, and we’re evaluating a solution for this.

To use BYOK, ensure your OpenAI project doesn’t have data residency controls enabled. Projects without project region settings will use the standard OpenAI endpoint (https://api.openai.com) and support BYOK.

  • For BYOK, enable the latest text generation models as well as the text-embedding-3-small model.
  • Ensure your project doesn't have data residency controls enabled. Projects without project region settings use the standard OpenAI endpoint (https://api.openai.com) and support BYOK.

dbt Copilot​

To configure your AI provider for dbt Copilot:

  1. Click on your account name and select Account settings in the side menu.
  2. Under Settings, click Copilot.
  3. Under AI providers, click Edit to configure the AI integration.
  4. For each provider, select your Key management option from the dropdown.
  1. Select the toggle for dbt Labs to use dbt Labs' managed* OpenAI key.
  2. Click Save.
Example of the dbt Labs integration pageExample of the dbt Labs integration page

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.

0
Loading