Familiarizing with the Models Interface
ON THIS PAGE
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 Workbench.
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 on the X on the top right or anywhere in the page in the background.
The following table describes these layout elements:
|1||Title Header||Displays the asset title MODELS along with the + CREATE MODEL button for creating a Model.|
|2||Search Bar||Search for Models by 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.|
|3||Model Count||View the total number of Models created by your team.|
|4||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.
|5||Asset List||Displays the list of Models created by the current user, and is refreshed based on 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. 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,
Click anywhere in the Model Summary row to open it in the Workbench, which is also called the Source Query page. The following image highlights the main layout elements that are displayed and the actions you can perform in the page.
The table below describes these key elements of the page:
|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 Workbench 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.