dbt Cloud
An overview of the dbt Cloud integration with Secoda
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 Secoda:
- 1.Retrieve your Account ID
- 2.Retrieve a Service Token
- 3.Connect dbt to Secoda
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
.png)
Secoda uses the dbt Cloud REST API, which is only available paying dbt Cloud customers. For Secoda 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 Member of the selected projects for the Service Account. Once the projects have been selected Save the token and copy the generated token.
.png)
After enabling the dbt REST API, the next step is to connect Secoda:
- 1.In the Secoda 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
Last modified 4d ago