# View: elementary_model_job_monitoring_v1

**View Name:** elementary_model_job_monitoring_v1
**Table Source:** `intelligence.dbt_prod.elementary_model_job_monitoring`
**File Path:** `elementary_model_job_monitoring_v1.view.lkml`

## Overview

- **File Size:** 5810 bytes
- **Lines of Code:** 213
- **Dimensions:** 15
- **Measures:** 8
- **Dimension Groups:** 6
- **Filters:** 0

## Description

The unique model execution id - model is an invidual dbt run command

## Comments & Notes

- dimension: job_execution_time {
- description: "The time taken for a run to execute"
- type: number

## Dimensions

| Name | Type |
|------|------|
| `model_execution_id` | string |
| `materialization` | string |
| `model_name` | string |
| `schema_name` | string |
| `package_name` | string |
| `alias` | string |
| `database_name` | string |
| `invocation_id` | string |
| `job_id` | string |
| `job_run_id` | string |
| `jobs_unique_id` | string |
| `full_refresh` | yesno |
| `jobs_name_clean` | string |
| `parent_folder` | string |
| `parent_subfolder` | string |

## Measures

| Name | Type |
|------|------|
| `distinct_count_of_model_runs` | count_distinct |
| `total_model_run_execution_time` | sum |
| `average_model_run_execution_time` | average |
| `average_job_run_execution_time` | average_distinct |
| `distinct_count_of_job_runs` | count_distinct |
| `total_job_execution_time` | sum_distinct |
| `distinct_count_of_model_name` | count_distinct |
| `distinct_count_of_job_name` | count_distinct |

## Dimension Groups

| Name | Type |
|------|------|
| `model_execute_started_at` | time |
| `model_execute_completed_at` | time |
| `model_execution_time` | duration |
| `job_started_at` | time |
| `job_completed_at` | time |
| `job_execution_time` | duration |