# Maestro data model

> The structure of the Maestro data model is based on the following concepts:

## Terms and concepts

The structure of the Maestro data model is based on the following concepts:

 <colgroup>
  <col/>
  <col/>
 </colgroup>
 
  
     Concept  
     Description  
  
 
 
  
    Explore 
     The starting point for exploration.  The data is surfaced via Explores, which you can think of as a general entity that corresponds to the fields within it.  
  
  
    View 
     A view represents a table of data, whether that table is native to your database or was created using Looker&rsquo;s derived table functionality.  Within each view are field definitions, each of which typically corresponds to a column in the underlying table or a calculation in Looker.  
  
  
    Dimension 
     As part of a View within the Explore, the Dimension is a groupable field and can be used to filter query results.  It can be one of the following: 
      
         An attribute, which has a direct association to a column in an underlying table. 
         A fact or numerical value. 
         A derived value computed based on the values of other fields in a single row. 
      

  
  
    Measure 
     As part of a View within the Explore, the Measure parameter declares a new measure (aggregation) and specifies a name for that measure.  Examples of measures types: <code>integer</code> , <code>string</code> . 
  
 

## Maestro

 <caption>
  Table 1. Maestro dimensions
 </caption>
 <colgroup>
  <col/>
  <col/>
 </colgroup>
 
  
    Dimension 
    Description 
  
 
 
  
    End Time 
    The time when process execution finished. The available options are:
      
         Date 
         Month 
         Quarter 
         Time 
         Week 
         Year 
      

  
  
    Event Time 
    The time when the event was executed. The available options are:
      
         Date 
         Month 
         Quarter 
         Time 
         Week 
         Year 
      

  
  
    Folder 
    Folder where the process is defined. 
  
  
    Process InstanceId 
    The ID of the process instance. 
  
  
    Process Key 
    The key of the executed process. 
  
  
    Process Name 
    The name of the process. 
  
  
    Process Version 
    The active version of the process package. A process can have multiple versions and it's the active version or the last configured version. 
  
  
    Total Run Time in Seconds 
    The total processing time of all jobs in seconds. 
  
  
    Start Time 
    The time when the execution of the process began. The available options are:
      
         Date 
         Month 
         Quarter 
         Time 
         Week 
         Year 
      

  
  
    Status 
    The status of the executed process. 
  
  
    Tenant Name 
    The name of the tenant where the process is defined. 
  
 

Table 2. Maestro measures

| Measures | Description |
| --- | --- |
| **Count** | The total number of executed processes. |

## Element Runs

 <caption>
  Table 3. Element Runs dimensions
 </caption>
 <colgroup>
  <col/>
  <col/>
 </colgroup>
 
  
    Dimension 
    Description 
  
 
 
  
    Element Name 
    The display name of the element executed within the process. Each task, event, or gateway in a process model is represented as an element. 
  
  
    Element RunId 
    The unique identifier assigned to each execution of an element within a process instance. It can be used to trace detailed element-level runs in Insights. 
  
  
    Element Type 
    The BPMN type of the executed element (for example, Script Task , User Task , Service Task , Event , or Gateway ) 
  
  
    End Time 
    The time when process execution finished. The available options are:
      
         Date 
         Month 
         Quarter 
         Time 
         Week 
         Year 
      

  
  
    Event Time 
    The time when the event was executed. The available options are:
      
         Date 
         Month 
         Quarter 
         Time 
         Week 
         Year 
      

  
  
    Folder 
    Folder where the process is defined. 
  
  
    Process InstanceId 
    The ID of the process instance. 
  
  
    Process Key 
    The key of the executed process. 
  
  
    Process Name 
    The name of the process. 
  
  
    Process Version 
    The active version of the process package. A process can have multiple versions and it's the active version or the last configured version. 
  
  
    Total Run Time in Seconds 
    The total processing time of all jobs in seconds. 
  
  
    Start Time 
    The time when the execution of the process began. The available options are:
      
         Date 
         Month 
         Quarter 
         Time 
         Week 
         Year 
      

  
  
    Status 
    The status of the executed process. 
  
  
    Tenant Name 
    The name of the tenant where the process is defined. 
  
 

Table 4. Element Runs measures

| Measures | Description |
| --- | --- |
| **Count** | The total number of executed processes. |