Definition

The Model Run view reports the most recent successful pipeline run window for each model and environment.

It is intended to help consumers understand run recency and execution windows without querying internal orchestration tables directly.

What this view contains

Each row identifies one model/environment pair and the latest successful pipeline run associated with it.

• airflow_run_id identifies the pipeline run.
• started_at and completed_at provide execution window timing.
• model_name is normalised by removing the internal srv_ prefix.

Typical use cases

• Confirm when a model was last successfully refreshed.
• Compare execution windows between models.
• Join with model_data_quality for freshness and quality reporting.

Example

SELECT
  environment,
  model_name,
  airflow_run_id,
  started_at,
  completed_at
FROM explorer_open_safely.model_run
ORDER BY completed_at DESC