data-infra
data-infra copied to clipboard
DbtModelError: `stg_transit_database__transit_data_quality_issues` column missing
It seems that a column was changed in Airtable in the Transit Data Quality Issues table and because we use schema auto-detect (i.e., no schema is explicitly specified) in the associated external table, this is causing the staging view creation to fail.
Impact is that the staging view and downstream models are getting out of date.
Sentry Issue: CAL-ITP-DATA-INFRA-26WG
DbtModelError: model.calitp_warehouse.stg_transit_database__transit_data_quality_issues - Database Error in model stg_transit_database__transit_data_quality_issues (models/staging/transit_database/stg_transit_database__transit_data_quality_issues.sql)
Unrecognized name: last_update at [35:9]
compiled Code at target/run/calitp_warehouse/models/staging/transit_database/stg_transit_database__transit_data_quality_issues.sql