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

Adds ntd modes seed file and easy conversions from two letter ntd modes #3386

Closed vevetron closed 3 months ago

vevetron commented 3 months ago

Description

Adds ntd modes seed file and easy conversions from two letter ntd modes to the full name.

Makes it easier to make dashboards.

Chose not to extend dim_modes since that describes more California modes, not national modes.

Uses descriptions from https://github.com/cal-itp/data-infra/pull/3378

Type of change

How has this been tested?

poetry run dbt seed
poetry run dbt run -s +dim_monthly_ntd_ridership_with_adjustments --full-refresh
poetry run dbt run -s +dim_annual_ntd_agency_service --full-refresh

Post-merge follow-ups

github-actions[bot] commented 3 months ago

Warehouse report 📦

Checks/potential follow-ups

Checks indicate the following action items may be necessary.

New models 🌱

calitp_warehouse.intermediate.ntd.intntd\_modes

DAG

Legend (in order of precedence)

Resource type Indicator Resolution
Large table-materialized model Orange Make the model incremental
Large model without partitioning or clustering Orange Add partitioning and/or clustering
View with more than one child Yellow Materialize as a table or incremental
Incremental Light green
Table Green
View White