cal-itp/data-infra

DbtModelError in `stg_audit__cloudaudit_googleapis_com_data_access`

Closed this issue · 1 comments

cal-itp-sentry commented

It seems that the union in stg_audit__cloudaudit_googleapis_com_data_access has broken, presumably because of an upstream schema change in the raw data. Data will stop updating in the BQ usage tables until this is fixed.

Sentry Issue: CAL-ITP-DATA-INFRA-26WS

DbtModelError: model.calitp_warehouse.stg_audit__cloudaudit_googleapis_com_data_access - Database Error in model stg_audit__cloudaudit_googleapis_com_data_access (models/staging/audit/stg_audit__cloudaudit_googleapis_com_data_access.sql)
  Query error: Queries in UNION ALL have mismatched column count; query 1 has 16 columns, query 5 has 15 columns at [87:5]
  compiled Code at target/run/calitp_warehouse/models/staging/audit/stg_audit__cloudaudit_googleapis_com_data_access.sql