Familiarizing with the Models UI

When you click the Transform icon in the Asset Palette, the Models List View is displayed. In this page, you can view the list of 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 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 + CREATE button for creating a 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 Select the Destination name or Model status to filter the list of Models.
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 Click in the Search Anything field to open 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 schedule according to your requirements.
You can click the More ( More icon ) 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
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.
Last updated on 16 Sep 2022

Tell us what went wrong