Incident Lab · SEV2 · dbt
stg_payments fails: "Could not convert string 'N/A' to DOUBLE"
RevOps: the collected revenue dashboard is stale. stg_payments has failed three runs in a row, everything downstream is skipped.
Conversion Error: Could not convert string 'N/A' to DOUBLE
raw payments.amount arrives as text . stg payments casts it to a number, and since this morning every run fails. Investigate: which values aren't numbers? Fix stg payments 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 payment id , account id and paid at .