How do model_run and model_data_quality relate to freshness and trust?

Use model_run and model_data_quality together when validating whether a model is both recent and quality-checked.

For production studies, run both checks before treating a model as analysis ready.

What each view tells you

• model_run: latest successful execution window for each model/environment.
• model_data_quality: latest quality status for each model/environment.

Recommended interpretation

• Use model_run.completed_at to assess recency.
• Use model_data_quality.status to assess latest quality outcome.
• Treat both together as operational metadata for analysis readiness checks.

Example: freshness and quality check

SELECT
  r.environment,
  r.model_name,
  r.completed_at,
  q.status,
  q.run_at AS quality_run_at
FROM explorer_open_safely.model_run AS r
LEFT JOIN explorer_open_safely.model_data_quality AS q
  ON r.environment = q.environment
  AND r.model_name = q.model_name
ORDER BY r.completed_at DESC