Working with dbt™ Projects

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.

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.

• Articles in this section
  • Configuring a dbt™ Project
  • Modifying a dbt™ Project
  • Scheduling a dbt™ Project
  • Viewing dbt™ Project Run Details
  • Pausing and Deleting dbt™ Projects
  • dbt™ Project and Model Run Statuses

Revision History