Skip to main content

dbt Copilot

dbt Copilot helps you generate SQL, documentation, tests, and semantic models in the dbt platform.

dbt Wizard is the recommended agent for dbt work

dbt Wizard is the 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.

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

The earlier version of dbt Copilot in the Studio IDE is available only to a limited set of accounts. dbt Wizard is available to all accounts and is the recommended way to develop with AI in the Studio IDE — it covers everything dbt Copilot's quick actions did, plus multi-step changes with built-in validation.

Where to access dbt Copilot​

dbt Copilot is available across the following experiences in the dbt platform. Refer to the links for more info on how to use each experience.

Action limits by plan​

dbt Copilot usage is metered in actions — one completed AI request counts as one action. Each plan includes a monthly action allotment per license:

PlanActions per month
Developer❌
Starter100
Enterprise5,000
Enterprise+10,000

Enterprise and Enterprise+ limits don't apply if you bring your own key (BYOK), since your AI provider bills that usage directly. Legacy Enterprise-tier plans enrolled before May 1, 2025 have a 1,000 action limit.

Refer to dbt AI usage for what counts as an action, what happens when you hit the limit, and how to check your usage.

Configure AI provider for dbt Copilot​

You need dbt admin permissions to change account settings and configure providers. dbt Copilot is configured separately from dbt Wizard — for dbt Wizard providers, refer to Manage AI features.

dbt Copilot supports fewer providers than dbt Wizard, including bring your own key (BYOK) on any plan:

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

dbt Copilot is available for inline assistance in Studio IDE, Canvas, and Insights. Configure it separately from dbt Wizard if your team uses these inline AI experiences.

To configure a provider:

  1. Click 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. Select your Key management option from the dropdown, then follow the steps for your provider below.
  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

Considerations​

  • dbt Copilot is a separate experience from dbt Wizard. For agentic, full-lifecycle AI development, use dbt Wizard.
  • AI features are enabled by default. Admins can turn them off or back on anytime.
  • Certain features are only available on Enterprise and Enterprise+ plans. Refer to Billing for details.
  • dbt Copilot doesn't yet support generating semantic models with the latest YAML spec.

Was this page helpful?

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

0
Loading