Links

dbt Cloud Integration

This page walks through the Secoda and dbt integration that Secoda supports

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 Secoda:
  1. 1.
    Enable your dbt Cloud REST API
  2. 2.
    Retrieve your dbt Cloud API key and Account ID
  3. 3.
    Connect dbt to Secoda

Enable the dbt REST API

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 enable your dbt's REST API. To do this, go to Account Settings > Metadata API and enable the API.

Retrieve your dbt Cloud API key and Account ID

You can determine your account ID by going to the Home page of dbt Cloud. In the URL, for example in the URL below, the account ID is 12345 https://cloud.getdbt.com/#/accounts/12345/projects/28649/dashboard
Your API key can be found in Profile > API Access and then click show to see your API key.

Connect dbt to Secoda

After enabling the dbt REST API, the next step is to connect Secoda:
  1. 1.
    In the Secoda App, select ‘Add Integration’ on the Integrations tab
  2. 2.
    Search for and select ‘dbt’
  3. 3.
    Enter your dbt account ID and API key. This information is kept encrypted.
  4. 4.
    Click 'Connect'