dbt Cloud

If you have a dbt Cloud account, Seemore can use the Cloud APIs and dbt Metadata APIs to enrich your metadata in Seemore.

Pre-requisites

Before proceeding to generate the service token, ensure that dbt Core is installed and properly configured in your environment. Follow the dbt Core installation guide to set it up. Only after this step should you continue with the instructions below.

🤓 Who can do this? You will probably need your dbt Cloud administrator to run these commands you may not have access yourself.

🚨 Careful! To enable Seemore to fetch metadata for dbt models defined in your project, you must add the dbt docs generate command to the list of commands in the job run steps. This will produce a catalog.json file containing all the relevant metadata. Alternatively, you can select the Generate docs on run checkbox to automatically generate updated project docs each time a job runs. Refer to dbt documentation to learn more.

Create service token

To generate a service token, follow the steps in the dbt documentation and configure the following permissions:

• Team plans: add Read-Only access to all projects you want to integrate into Seemore.

• Enterprise plans: add Account Viewer access to all projects you want to integrate into Seemore.

Be sure to copy the generated token for crawling dbt.

The required details for this integration are:

• ApiKey - the service token.

• AccountID - the account id.

Custom access urls

In case your'e using cell based dbt cloud you can get the URLs from your Account settings below the Account information pane

Configuring IP restrictions

To allow SeeMore to access DBT Cloud, you may need to enable our IPs by following these steps:

1. Go to Account Settings → IP Restrictions

2. Add these IPs:

   • 3.78.110.132

   • 3.73.171.134

3. Save & Verify access from an allowed network.