Skip to main content

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

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.

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.

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)

  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 in public preview as an AI agent layer across the managed dbt platform. Some customers may still have access to dbt Copilot until the updated AI agent layer is generally available. 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