cal-itp/data-infra

DbtModelError: `stg_transit_database__transit_data_quality_issues` column missing

Opened this issue · 0 comments

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