dbt cloud

Getting Started with dbt

dbt is a secondary integration that adds additional metadata on to your data warehouse or relational database tables. Before connecting dbt make sure to connect a data warehouse or relational database first. These include Snowflake, BigQuery, Postgres, Redshift, etc.

There are three steps to get started using dbt with Seda:

1. Retrieve your Account ID

2. Retrieve a Service Token

3. Connect dbt to Seda

Retrieve your Account ID

You can determine your account ID by going to the Account Settings page of dbt Cloud console. In the URL, for example in the URL below, the account ID is 12345 https://cloud.getdbt.com/settings/accounts/12345/pages/projects

Retrieve a Service Token

Seda uses the dbt Cloud REST API, which is only available paying dbt Cloud customers. For Seda to retrieve metadata from dbt, you need to generate a Service Token with. To do this, go to Account Settings > Service Tokens and click "New Token".

The minimum permissions are Analyst of the selected projects for the Service Account. Once the projects have been selected Save the token and copy the generated token.

Connect dbt to Seda

After enabling the dbt REST API, the next step is to connect Seda:

1. In the Seda App, select Add Integration on the Integrations tab

2. Search for and select the dbt Cloud integration

3. Enter your dbt account ID and Service Token. This information is kept encrypted.

4. Click Connect