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.
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:
-
Connects to your Git repository.
-
Clones your Git repository in the server that hosts dbt Core.
-
Generates a
profiles.ymlfile for each dbt project. This file contains the connection details for your Destination and always includes only theprodtarget under theoutputskey. For more details on its structure, read About profiles.yml. -
Looks for the
dbt_project.ymlfile in the specified dbt project path. -
Identifies the models to be run on the data warehouse tables and runs them from the cloned repository.
-
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.
-
Deletes the cloned repository.
If you have already set up a dbt project in your Git repository, you can start working with dbt projects using the links below.
- Configuring a dbt™ ProjectLearn how to connect your Git repository and configure a dbt project in Hevo.
- Modifying a dbt™ ProjectLearn how to modify the configuration of an existing dbt project.
- Scheduling a dbt™ ProjectLearn how to configure the schedule at which your dbt project runs.
- Viewing dbt™ Project Run DetailsLearn how to view the details and progress of your dbt project runs.
- Pausing and Deleting dbt™ ProjectsLearn how to pause or delete a dbt project.
- dbt™ Project and Model Run StatusesLearn about the different statuses a dbt project or Model run can have.