Hi,
We are using Prometheus for Airflow DAGs monitoring. How to get the only last run status of DAG, like whether failed or successful?
We tried using below queries:
For Success - count(last_over_time(airflow_dagrun_duration{kubernetes_namespace=“$namespace”}[1h])) by (dag_id)
For Failure -
count(last_over_time(airflow_dagrun_failed{kubernetes_namespace=“$namespace”}[1h])) by (dag_id)
Some of the DAGs are showing in both failed and success, as they run more than once within specific time (hourly/daily).
Can we get only last status of DAGs using PromQL?