cal-itp / data-infra

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

NTD external tables for Complete Monthly Ridership with Adjustments and Estimates Data #3470

Closed erikamov closed 1 month ago

erikamov commented 1 month ago

Description

This PR creates the NTD external tables for XLSX Complete Monthly Ridership with Adjustments and Estimates Data

3403

Type of change

How has this been tested?

Tested with local Airflow and the tables were created on cal-itp-data-infra-staging.external_ntd__ridership

Post-merge follow-ups

Validate the creation of all tables on cal-itp-data-infra.external_ntd__ridership

vevetron commented 1 month ago

Should we consider putting the data into calitp-ntd-data-products instead where the existing ntd data gets dropped? And then we stop maintaining monthly-ridership-with-adjustments.

evansiroky commented 1 month ago

Since there was also a new bucket created within #3465, I think we should probably start with a fresh bucket.