dbt Copilot FAQs enterprise

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

dbt 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 dbt Copilot handles your data. For more information, check out the dbt Labs AI development principles page.

Overview

 What is dbt Copilot?

dbt Copilot is a powerful AI-powered assistant that's fully integrated into your dbt Cloud experience and designed to accelerate your analytics workflows. dbt 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 dbt Copilot generate code using natural language, and generate documentation, tests, metrics, and semantic models for you with the click of a button in the dbt Cloud IDE and, now in beta, Visual Editor.

 Where can I find dbt Copilot?

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

To use dbt 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 dbt 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, dbt 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, dbt 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?

dbt 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 dbt Copilot. Enterprise accounts can supply their own OpenAI keys

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

The dbt 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 dbt Copilot button. Aside from authentication, it works without personal data, but the user controls what is input into dbt Copilot.

 Does dbt Copilot access my warehouse data?

To provide the services, dbt 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 dbt 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 dbt 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?

dbt Copilot has the following considerations to keep in mind:

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

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