Familiarizing with the dbt™ Models UI

Last updated on May 30, 2023

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.

When you click the MODELS icon in the Navigation Bar for the first time, the Models home page is displayed. Click + CREATE MODEL to create your first SQL or dbt™ Model.

Create Model

Once you have created at least one model, clicking MODELS displays the SQL Models List View, where you can view the SQL Models currently created by your team. You can click on the dbt Core™ tab to switch to the dbt Projects List View.

Select dbt tab

You can click on any dbt project in the dbt projects list view to open it in the Detailed View.

The following sections highlight the main elements of the dbt projects List View and Detailed View.

dbt Projects List View

Refer to the image and descriptions below to familiarize yourself with the components of the dbt Models List View. To close the List View, click the Close ( ) icon on the top right or anywhere on the page in the background.

dbt Projects List View

The following table describes each of these components:

Page Component Title Description
1 Title Header Displays the SQL and dbt Core™ tabs, and the CREATE dbt™ MODEL button for creating a dbt Model.
2 Item Count Displays the total number of dbt projects created by your team.
3 Search Bar Enables you to search for dbt projects by clicking the search icon, and typing a partial or complete name of the project, the Destination name or type it is created for, or the dbt project number, in the Search Models field.
4 Data Controls Enables you to control the data that is displayed. The Data Controls include, from left to right:

- Destination: Enables you to filter the projects by Destination.
- Status: Enables you to filter the dbt projects by Status. Read dbt Project Statuses for the list and their meanings.
- Newest First: Enables you to filter the projects based on:
  - Most recently run.
  - Least recently run.
  - Oldest first.
  - Alphabetical order and vice versa.
5 Asset List Displays the list of dbt projects created by you or your team, and can be refined based on the Data Controls or the search string.
6 Project Summary Each row in the Asset List mentions the dbt project name, along with the following summary details to help you assess the state of the dbt project:

- The sequential serial number assigned to the project at the time of creation. For example, #16.
- The time of the last run of the dbt project.
- The status of the latest run.
- The name and type of the Destination on which the dbt project is created.
- The name of the linked Git repository.

dbt Projects Detailed View

Click anywhere in a dbt project’s Summary row in the List View to open the project’s Detailed View. This view opens in the Overview tab by default. The following image highlights the main components that are displayed and the actions you can perform in the page.

dbt Projects Detailed View

The following table describes each of these components:

Page Component Title Description
1 Global Search Displays your most recent work, such as Pipelines, Models, and Destinations in the left pane, and their key details, available actions, and related documentation on the right. In addition, you can search for and configure any unused Source or Destination from the search results window.
2 Tools Bar Access the Overview, Execution History, and Activity Log sections from the Tools Bar.
3 Summary Bar View a snapshot of the dbt project here. It displays:

- The number assigned to the dbt project at the time of creation.
- The project name, Destination name, and its type, and the Git repository name linked to your dbt project.
- The status of the dbt project.
- The schedule of the dbt project. You can change this. You can use the PAUSE/RESUME button to pause or resume the dbt project respectively.
You can click the More ( ) icon to access the actions available for the project.
4 List Area You can view the list of models in the project here. For each model, it displays:

- The name and location of the model.
- The schedule of each model.
- The status of each model in the project and the last time it was run.

- Filter: Enables you to filter the models on Status. Read Model Statuses for the list and their meanings.

Revision History

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

Date Release Description of Change
Apr-10-2023 2.11 Updated section, Pipelines Detailed View to add information about the enhanced search functionality.
Nov-25-2022 NA New document.

Tell us what went wrong