Working with dbt™ Projects

Last updated on Mar 14, 2024
On This Page

At this time, the dbt Core™ on Hevo is in BETA. Please reach out to Hevo Support or your account executive to enable it for your team.

Hevo’s dbt projects help you quickly transform data in your data warehouse by connecting to your Git repository that hosts your dbt projects and running the models within the project, as specified in the configuration file, dbt_project.yml.

Note: You must be assigned the Team, Pipeline, or Models and Workflows Administrator, or Team, Pipeline, or Models and Workflows Collaborator role in Hevo, to edit dbt projects in Hevo.

Hevo’s integration with dbt Core™ does not define any models for you, it simply runs the dbt project containing them for you.

Broadly, to run a dbt project, Hevo performs the following steps:

  1. Connects to your Git repository.

  2. Clones your Git repository in the server that hosts dbt Core.

  3. Generates the profiles.yml file with the connection details of your Destination.

  4. Looks for the dbt_project.yml file in the specified dbt project path.

  5. Identifies the models to be run on the data warehouse tables and runs them from the cloned repository.

  6. Creates the tables and views in your Destination and loads the transformed data into them. The tables and views are created in the first run; in subsequent runs, the existing data in them is first deleted, and then the transformed data is loaded.

  7. Deletes the cloned repository.

If you have already set up a dbt project in your Git repository, you can start configuring your dbt Projects in Hevo.

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Mar-15-2024 NA Added clarification about Hevo generating the profiles.yml file.
Nov-25-2022 NA New document.

Tell us what went wrong