data-infra icon indicating copy to clipboard operation
data-infra copied to clipboard

DbtModelError: `stg_transit_database__transit_data_quality_issues` column missing

Open cal-itp-sentry[bot] opened this issue 1 year ago • 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

cal-itp-sentry[bot] avatar Dec 13 '23 15:12 cal-itp-sentry[bot]