Skip to main content
Skip table of contents

dbt core (self hosted)

This page will walkthrough the setup of dbt core (self hosted dbt) in K.

Integration details

















Step 1) Extract from dbt

The inclusion of the project_id in the filename is to support multiple dbt projects.

Step 2) Add dbt Core as a New Source

  • Select Platform Settings in the side bar

  • In the pop-out side panel, under Integrations click on Sources

  • Click Add Source and select DBT_CORE

  • Select Load from File and add your dbt core details and click Next

  • Fill in the Source Settings and click Next

    • Name: Give the dbt source a name in K

    • Host: Enter the dbt server name

    • Project Mapping: A mapping is required to map dbt projects ids to KADA source hosts.


          "projectid_1234": "",
          "anotherprojectid_9283": ""

      payload containing key, value pairs:

      • key - dbt project id. This can be found in the manifest.json file under metadata > project_id

      • value - host of the database matching the KADA onboarded source’s host.
        This can be found in Platform Admin > Sources > Edit source > See host name.

  • Click Finish Setup

Step 3) Configure the dbt extracts

  • Click Edit on the dbt core source you just created

  • Note down the storage location

  • Schedule the dbt extracts to land in this directory.

For details about how to push files to landing - see Collectors

Step 4) Schedule the dbt core source load

  • Select Platform Settings in the side bar

  • In the pop-out side panel, under Integrations click on Sources

  • Locate your new dbt core Source and click on the Schedule Settings (clock) icon to set the schedule

Step 5) Push your extracts to K

Step 6) Manually run an ad hoc load to test dbt core setup

  • Next to your new Source, click on the Run manual load icon


  • Confirm how your want the source to be loaded

  • After the source load is triggered, a pop up bar will appear taking you to the Monitor tab in the Batch Manager page. This is the usual page you visit to view the progress of source loads

A manual source load will also require a manual run of



To load all metrics and indexes with the manually loaded metadata. These can be found in the Batch Manager page


Troubleshooting failed loads

  • If the job failed at the extraction step

    • Check the error. Contact KADA Support if required.

    • Rerun the source job

  • If the job failed at the load step, the landing folder failed directory will contain the file with issues.

    • Find the bad record and fix the file

    • Rerun the source job

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.