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