Familiarizing with the Models UI

Last updated on Oct 06, 2023

When you click the MODELS icon in the Navigation Bar, the Models List View is displayed. In this page, you can view the list of SQL Models created by you or your team, refine the view using filters, and click on any Model to open it in the Detailed View.

The following sections highlight the main elements of the Models List View and Detailed View:


Models List View

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

Models 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 SQL MODEL button for creating a SQL Model.
2 Item Count Displays the total number of Models created by your team.
3 Search Bar Enables you to search for Models by clicking the Search icon, and typing a partial or complete name of a Model, the Destination name or type it is created for, or the Model 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 Models by the Destination.
- Status: Enables you to filter the Models based on their status.
- Newest First: Enables you to filter the Models based on:
   - Most recently run.
   - Least recently run.
   - Oldest first.
   - Alphabetical order and vice versa.
5 Asset List Displays the list of Models created by you or your team, and can be refined based on the Data Controls or the search string.
6 Model Summary Each row in the Asset List mentions the Model name, along with the following summary details to help you assess the state of the Model:
- The sequential serial number assigned to the Model at the time of creation. For example, #81.
- The time of the last run of the Model.
- The status of the latest run.
- The Destination on which the Model is created.
- The output table for storing the query results. For example, applicants_list.

Models Detailed View

Click anywhere in the Model Summary row to open it in the Detailed View. This view opens in the Source Query tab by default. The following image highlights the main components that are displayed and the actions you can perform in the page.

Model Source Query tab

The following table describes each of these components:

Page Component Title Description
1 Tools Bar Provides links for the Source Query, Query History, Preview, and Activity Log.
2 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.
3 Summary Bar Get a snapshot of the Model here. It displays:
- The Model name and the Destination it is built on. A Model is initially created in Draft state with name as Untitled. You can update it to the name you want.
- The status of the current run.
- Details of the last run.
- The schedule of the run. You can change this schedule according to your requirements.
You can click the More ( ) icon to access the actions available for the Model.

Models created prior to Release 1.44 are identified by the LEGACY tag.
4 Destination Details Displays the Destination database name, its last refresh time, and its schema details. Click the Info ( Info icon ) icon to view the database connection details. Schema information is useful while creating the SQL query or changing the output table.
5 Export Table Details Lists the table to which the query results are exported. You can change the export table and also reset the Model entirely if you want to modify its query or migrate it to the latest version.

Read Model Reset.
6 Query Builder The main section of the Source Query tab, where you can create and test the SQL queries for your Models. You can also run the query; the elapsed time is shown alongside the Run Query button. For incremental Models, the Save Query button provides you an option to Save and Reset Model.

Read Working with Models.



See Also


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, Models Detailed View to add information about the enhanced search functionality.
Nov-25-2022 NA Updated section, Models List View to reflect the changed UI.
Sep-07-2022 1.97 Updated section, Models List View page to reflect the latest UI changes.
Mar-11-2022 NA Updated sections, Models List View and Models Detailed View.

Tell us what went wrong