dbt Copilot FAQs Enterprise

Read about common questions about Copilot to understand how it works and how it can help you.

Copilot is an AI-powered assistant fully integrated into your dbt Cloud 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 Copilot handles your data. For more information, check out the dbt Labs AI development principles page.

Overview

 What is dbt Copilot?

Copilot is a powerful AI-powered assistant that's fully integrated into your dbt Cloud experience and designed to accelerate your analytics workflows. Copilot embeds AI-driven assistance across every stage of the analytics development life cycle (ADLC), empowering data practitioners to deliver data products faster, improve data quality, and enhance data accessibility.

With automatic code generation, let Copilot generate code using natural language, and generate documentation, tests, metrics, and semantic models for you with the click of a button in the Cloud IDE and, now in beta, Canvas.

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.

 Where can I find dbt Copilot?

Copilot can currently be found in the Cloud IDE. Future releases will bring Copilot to the Canvas and even more parts of the dbt Cloud application.

To use Copilot, you must have a dbt Cloud Enterprise account and administrative privileges to opt-in to the feature for your team.

 What are the benefits of using dbt Copilot?

Use Copilot to:

• Generate code from scratch or edit existing code with natural language.
• Generate documentation, tests, metrics, and semantic models for your models.
• Accelerate your development workflow with AI-driven assistance.

with a click of a button and ensuring data privacy and security.

Example of using dbt Copilot to generate documentation in the IDE

Availability

 Who has access to dbt Copilot?

When enabled by an admin, Copilot is available on a dbt Cloud Enterprise account to all dbt Cloud developer license users.

 Is dbt Copilot available for all deployment types?

Yes, Copilot is powered by ai-codegen-api, which is deployed everywhere including multi-tenant and single-tenant deployments.

How it works

 What data/code is used to train the model supporting dbt Copilot?

Copilot is not used to train a large language model (LLM). dbt Labs does not train any models at all. Currently, we use OpenAI models, and our agreement with OpenAI prohibits OpenAI from retaining our data persistently. Refer our dbt Labs AI principles page for more information.

 Which model providers does dbt Copilot use?

dbt Labs works with OpenAI to build and operationalize Copilot. Enterprise accounts can supply their own OpenAI keys

 Do we support BYOK (bring your own key) at the project level?

The Copilot BYOK option is currently an account-only configuration. However, there may be a future where we make this configurable on a project-level.

Privacy and data

 Does dbt Copilot store or use personal data?

The user clicks the Copilot button. Aside from authentication, it works without personal data, but the user controls what is input into Copilot.

 Does dbt Copilot access my warehouse data?

To provide the services, Copilot utilizes the data entered by the user in addition to metadata, including column names, model SQL, the model's name, and model documentation. The row-level data from the warehouse is never used or sent by dbt Labs to a third-party provider without action by the user. The user is responsible for double-checking output for completeness and accuracy.

 Can dbt Copilot data be deleted upon client written request?

To the extent client identifies personal or sensitive information uploaded by or on behalf of client to dbt Labs systems by the user in error, such data can be deleted within 30 days of written request.

 Does dbt Labs own the output generated by dbt Copilot?

No, dbt Labs will not dispute your ownership of any code or artifacts unique to your company that's generated when you use Copilot. 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 for dbt Copilot?

Clients who signed with terms after January 2024 don't need additional terms prior to enabling Copilot. Longer term clients have also protected their data through confidentiality and data deletion obligations. In the event client prefer additional terms, clients may enter into the presigned AI & Beta Addendum available at here (the dbt Labs signature will be dated as of the date the client signs).

Considerations

 What are the considerations for using dbt Copilot?

Copilot has the following considerations to keep in mind:

• Copilot is not available in the Cloud CLI.
• Copilot is not available in the dbt Cloud API.

Future releases are planned that may bring Copilot to even more parts of the dbt Cloud application.