Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DbtModelError: stg_transit_database__transit_data_quality_issues column missing #3183

Open
cal-itp-sentry bot opened this issue Dec 13, 2023 · 0 comments

Comments

@cal-itp-sentry
Copy link

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

0 participants