Definite can pull metadata from your dbt project to improve NLQ performance and filter your schema to only use tables created by dbt.

Definite supports projects that use dbt Cloud and dbt Core.

Creating a dbt connection requires that you already have a database connection.

​
Connecting to dbt Cloud

1

In the Definite homepage, go to Settings Integrations dbt.

2

Make sure dbt Cloud is selected in the top right of the form. You should see this screen:

3

Fill in the following fields:

  • Nickname : Give your integration a unique name

  • Database Connection : Select the database that this dbt project is connected to from the dropdown

  • Account ID and Project ID can be found in the url of your dbt Cloud project, for example:

    https://cloud.getdbt.com/settings/accounts/123456/projects/654321

    where Account ID = 123456 and Project ID = 654321

  • API Key : you can find your dbt Cloud API key in your profile settings here

4

When you hit Save, Definite will attempt to connect to your dbt project. If this fails for any reason double-check your credentials and try again. If you keep running into issues, please contact hello@definite.app.

​
Connecting to dbt Core

1

In the Definite homepage, go to Settings Integrations dbt.

2

Make sure dbt Core is selected in the top right of the form. You should see this screen:

3

Fill in the following fields:

  • Nickname : Give your integration a unique name

  • Manifest : Upload your project’s file. The manifest is one of several artifacts created by dbt. The artifacts are located in your compile target directory (generally target/). Please note that you need to generate the file using the production profile from your file. For example, you can generate the file with this command:

    dbt compile --profile prod

  • Database Connection : Select the database that this dbt project is connected to from the dropdown

4

When you hit save, Definite will save your project’s manifest.json file securely in the cloud and create the integration.

NOTE: You will need to re-upload this file whenever you update your models. Currently, only dbt Cloud integrations will automatically stay up to date as your project changes.