Control Tower

drop

Sudden downward drop in a metric relative to recent baseline.

flatline

Metric values stop changing over an extended window (possible sensor failure).

silent_station

Station stopped reporting any observations for one or more metrics.

spike

Sudden upward jump in a metric relative to recent baseline.

stale_data

Observations continue but observed_at does not advance (stuck timestamps).

ingest_openmeteo_all_stations

Collects fresh weather data from all monitored stations and stores it exactly as received.

transform_raw_to_fact

Cleans/standardizes raw data, converts units, validates values, prepares for dashboards.

dq_check_run

Runs data quality checks to catch missing/stale/inconsistent data.

anomaly_detection

Detects spikes/drops/flatlines/silent stations and may open incidents.

fact_freshness_minutes

How recently data was observed per station/metric.

metric_completeness_pct

Whether all expected metrics exist at the latest time.

late_data_rate_pct

Share of observations arriving later than allowed.

late_data_rate_pct_all_time

Long-term late-arrival rate.

raw_duplicate_key_count

Duplicate raw ingestion keys (replay/duplication).

fact_duplicate_key_count

Duplicate fact-table keys (dedupe/transform issue).

stations_missing_any_metric_count_latest_hour

Stations missing one+ expected metrics in the latest window.

value_out_of_range_count

Values outside expected ranges (sensor/corruption).

Status (GREEN / AMBER / RED)

Overall platform health computed by vw_platform_status. RED = open incidents. AMBER = DQ fail in last 24h or freshness > 120. GREEN = none.