dbt Cloud integration
Import your dbt Cloud models into Count
Last updated
Import your dbt Cloud models into Count
Last updated
In an existing database connection, select Manage connection, then select the dbt tab.
To connect you will need:
Read-only
Metadata only
Once your credentials have been verified, you will first need to select a dbt Cloud account to use, after which your dbt Cloud jobs will be listed.
You should select artifacts for each job depending on the information you would like to view in Count:
If the step involves dbt build
or dbt compile
(for example) then Count will have access to raw and compiled SQL if you select manifest.json
.
If the step involves dbt build
or dbt test
(for example) then Count will have access to test results if you select run_results.json
.
In most cases, it will probably suffice to find the single step that performs dbt build
and select both the manifest and run results from that step.
Once you have selected the appropriate artifacts, click Finish setup and Count will request these files from dbt Cloud. When the metadata has been retrieved successfully, a message will be displayed at the bottom of the page:
An for your dbt Cloud account
An API token for a / with the following permissions
An account that conforms to the dbt Cloud metadata API
For each job, Count can extract dbt metadata by reading the manifest.json
and/or run_results.json
files for a particular step in that job. These files are referred to by dbt as , and contain information about your models and tests.
See our for frequently asked questions & how to guides on our dbt integrations.