cal-itp / data-infra

Cal-ITP data infrastructure
https://docs.calitp.org/data-infra
GNU Affero General Public License v3.0
47 stars 12 forks source link

Bug: Elk Grove Transit not showing up in views.gtfs_schedule_fact_daily_feeds #1329

Closed evansiroky closed 2 years ago

evansiroky commented 2 years ago

Describe the bug

Despite Elk Grove Transit existing in agencies.yml, it is not being populated in views.gtfs_schedule_fact_daily_feeds BigQuery dataset.

To Reproduce

Steps to reproduce the behavior:

  1. Go to this metabase question
  2. Note absence of Elk Grove Transit

Expected behavior

Elk Grove Transit should appear in the views.gtfs_schedule_fact_daily_feeds BigQuery dataset for yesterday's date.

Additional context

The problem probably has something to do with this transit agency having been deleted before. See https://github.com/cal-itp/data-infra/pull/1224#issuecomment-1069702894.

lauriemerrell commented 2 years ago

Ah, I think this is an instance of this: https://github.com/cal-itp/data-infra/issues/1030