Skip to main content

Enable dbt Copilot StarterEnterpriseEnterprise +

Enable Copilot, an AI-powered assistant, in dbt to speed up your development and focus on delivering quality data.

This page explains how to enable Copilot in dbt to speed up your development and allow you to focus on delivering quality data.

Prerequisites​

  • Available in the dbt only.
  • Must have a dbt Starter, Enterprise, or Enterprise+ account.
  • Development environment is on a supported release track to receive ongoing updates.
  • By default, Copilot deployments use a central OpenAI API key managed by dbt Labs. Alternatively, you can provide your own OpenAI API key.
  • Copilot is optimized for OpenAI's gpt-3.x, gpt-4o, gpt-4.1-[mini|nano], and gpt-4.5 (deprecated by OpenAI) models. Other models, like o1 and o2, are not supported and will not work with Copilot.
  • Opt-in to AI features by following the steps in the next section in your Account settings.

Enable dbt Copilot​

To opt in to Copilot, 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 Copilot features option.
  5. Click Save. You should now have Copilot AI enabled for use.

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

Example of the 'Enable account access to AI-powered feature' option in Account settingsExample of the 'Enable account access to AI-powered feature' option in Account settings

Bringing your own OpenAI API key (BYOK) Enterprise +Enterprise​

Once AI features have been enabled, you can provide your organization's OpenAI API key. dbt will then leverage your OpenAI account and terms to power Copilot. This will incur billing charges to your organization from OpenAI for requests made by Copilot.

Configure AI keys using:

  • dbt Labs-managed OpenAI API key
  • Your own OpenAI API key
  • Azure OpenAI

AI integrations​

Once AI features have been enabled, you can use dbt Labs' AI integration or bring-your-own provider to support AI-powered dbt features like Copilot and Ask dbt.

dbt supports AI integrations for dbt Labs-managed OpenAI keys, Self-managed OpenAI keys, or Self-managed Azure OpenAI keys.

Note, if you bring-your-own provider, you will incur API calls and associated charges for features used in dbt. Bringing your own provider is available for Enterprise or Enterprise+ plans.

info

dbt's AI is optimized for OpenAIs gpt-4o. Using other models can affect performance and accuracy, and functionality with other models isn't guaranteed.

To configure the AI integration in your dbt account, a dbt admin can perform the following steps:

  1. Navigate to Account settings in the side menu.
  2. Select Integrations and scroll to the AI section.
  3. Click on the Pencil icon to the right of OpenAI to configure the AI integration.
    Example of the AI integration pageExample of the AI integration page
  4. Configure the AI integration for either dbt Labs OpenAI, OpenAI, or Azure OpenAI.
  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
0
Edit this page