expose all ntd annual reporting staging tables as mart

[charlie-costanzo]

Description

As requested in #3531, we are making all of the base staging NTD annual reporting tables available in mart schemas so as to access them in Metabase.

Resolves #3531

Type of change

• [x] New feature

How has this been tested?

tested locally with dbt

Post-merge follow-ups

• [x] Actions required (specified below) observe post-merge for expected behavior, change any outstanding/new models to use these new schemas and communicate out new schema.

[github-actions[bot]]

Warehouse report 📦

Checks/potential follow-ups

Checks indicate the following action items may be necessary.

• [ ] For new models, do they all have a surrogate primary key that is tested to be not-null and unique?

New models 🌱

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_breakdowns

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_breakdowns_by_agency

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_capital_expenses_by_capital_use

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_capital_expenses_by_mode

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_capital_expenses_for_existing_service

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_capital_expenses_for_expansion_of_service

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_employees_by_agency

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_employees_by_mode

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_employees_by_mode_and_employee_type

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_fuel_and_energy

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_fuel_and_energy_by_agency

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_funding_sources_by_expense_type

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_funding_sources_directly_generated

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_funding_sources_federal

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_funding_sources_local

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_funding_sources_state

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_funding_sources_taxes_levied_by_agency

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_maintenance_facilities

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_maintenance_facilities_by_agency

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_metrics

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_operating_expenses_by_function

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_operating_expenses_by_function_and_agency

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_operating_expenses_by_type

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_operating_expenses_by_type_and_agency

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_service_by_agency

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_service_by_mode

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_service_by_mode_and_time_period

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_stations_and_facilities_by_agency_and_facility_type

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_stations_by_mode_and_age

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_track_and_roadway_by_agency

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_track_and_roadway_by_mode

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_track_and_roadway_guideway_age_distribution

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_vehicles_age_distribution

calitp_warehouse.mart.ntd_fct_annual.fct_ntd_annualdata\_vehicles_type_count_by_agency

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