Incident Lab · SEV2 · Airflow
stg_orders fails: "Could not convert string 'N/A' to DOUBLE"
Finance: the revenue dashboard is stale. stg_orders has failed three runs in a row, everything downstream is skipped.
Conversion Error: Could not convert string 'N/A' to DOUBLE
raw orders.amount arrives as text . stg orders casts it to a number, and since this morning every run fails. Investigate: which values aren't numbers? Fix stg orders so it never fails on a bad value: amount becomes a DOUBLE ( NULL when it isn't a number) and a new column amount is valid says whether it parsed. Keep order id , customer id and ordered at .