Document toolboxDocument toolbox

[M - DONE] DBT Cloud

Use this integration where you use DBT cloud (getdbt.com)

 

  1. Before you setup DBT integration for K, you will need to create a Service Token to use. Log into your DBT cloud account and go to Account Settings > Service Tokens


     

  2. Click New Token.

    Give the Token a name
    Add Read Only Access to All Projects



     

  3. Copy the Key and save it in a safe location for later steps


     

  4. Log in to K and go to Platform Settings > Integration / Sources


     

  5. Click on New Source and Select dbt


     

  6. Fill in the DBT details
    Name: Give the DBT source a name in K
    Host: cloud.getdbt.com.[account id]

    You can find your Account ID in the URL when you log into your DBT cloud console. It should be something like this

    https://cloud.getdbt.com/#/accounts/[account ID]/projects/[project ID]/dashboard/


    DBT Cloud Account ID: see above in Host

    Click Next



     

  7. Add your token you saved in Step 3. Click Save. After a successful connection, click Next


     

  8. Click Finish Setup to complete the DBT cloud configuration

  9. Click on Edit Schedule in Sources and set up a schedule to extract DBT metadata