Familiarizing with the Models UI
When you click the MODELS icon in the Navigation Bar, the Models List View is displayed. On 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.
The following table describes each of these components:
| Page Component | Title | Description |
|---|---|---|
| 1 | Title Header | Displays the SQL and dbt Core™ tabs. |
| 2 | 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. |
| 3 | Data Controls | Enables you to control the data that is displayed. The Data Controls, from left to right are: - Filters: Enables you to filter the Models based on: - Destination type. - Model status. - Newest First: Enables you to filter the Models based on: - Most recently run. - Least recently run. - Oldest first. - Alphabetical order and vice versa. - Refresh: Enables you to view the SQL Models that are newly created but not visible in the UI yet. |
| 4 | + CREATE SQL MODEL button | Enables you to create a SQL Model. |
| 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, #6. - 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, dbt_countries. |
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 on the page.
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 (  ) 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
Last updated on Aug 27, 2024