Familiarizing with the Models UI

When you click the MODELS icon in the Asset Palette, the Models List View is displayed. In this page, you can view the Models that you or your team has created, refine the view using filters, and click on any Model to open it in the Detailed View.

The following sections highlight the main layout elements of both these pages and the actions you can perform in these.

Models List View

Refer to the image and descriptions below to familiarize yourself with the components of the Models List View. To close the List View, click the Close (X) 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 tabs for Models and Workflows along with the + CREATE MODEL button for creating a Model.
2 Model Count View the total number of Models created by your team.
3 Data Controls Select values from the available drop-downs to sort and filter the search results. You can filter the results by:
- The Destination on which the Model is configured.
- The status of the Model run.
- The timeline when the Model was added.
You can also search for Models by clicking on the Search icon and typing a partial or complete name of a Model, the Destination name or type it is created on, or the Model number, in the Search Models field.
4 Asset List Displays the list of Models created by the current user, and is refreshed based on the search string.
5 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. If a run is in progress, the status is Streaming.
- 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 Access the Source Query, Query History, View Details, and Activity Log sections from the Tools Bar.
2 Global search Click in the Search Anything field in the Global Search panel to open the Search window, which lists the projects you have recently worked on. You can search for any of your Pipelines, Models, Workflows, and Destinations. Results matching the search string are displayed from all categories.
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.
You can click on the More icon to run the Model or delete it.

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. You can also reset the Model entirely if you want to modify its query or migrate it to the latest version.

Read Model Reset for more information.
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 of Save and Reset Model.

Read Creating and Modifying Models.

See Also

Last updated on 14 Dec 2021