cal-itp/data-infra issues and pull requests

#3125 - Add diagram showing RBAC/security for Payments dashboards

Pull Request - State: closed - Opened by lauriemerrell about 1 year ago

#3124 - Onboard new ATN Metabase users

Issue - State: closed - Opened by lauriemerrell about 1 year ago

#3123 - Refactor payments rides for code readability and modularity: micropayments portion

Pull Request - State: closed - Opened by lauriemerrell about 1 year ago - 1 comment

#3122 - Bump aiohttp from 3.8.5 to 3.8.6 in /packages/calitp-data-infra

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3121 - Bump aiohttp from 3.8.5 to 3.8.6 in /images/jupyter-singleuser

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3120 - Bump aiohttp from 3.8.5 to 3.8.6 in /packages/calitp-data-analysis

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3119 - Bump aiohttp from 3.8.5 to 3.8.6 in /services/gtfs-rt-archiver-v3

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3118 - Bump aiohttp from 3.8.5 to 3.8.6 in /jobs/gtfs-schedule-validator

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3117 - Bump aiohttp from 3.8.5 to 3.8.6 in /apps/maps

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3116 - Bump aiohttp from 3.8.5 to 3.8.6 in /jobs/gtfs-rt-parser-v2

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3115 - Bump aiohttp from 3.8.5 to 3.8.6 in /script

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3114 - Bump aiohttp from 3.8.5 to 3.8.6 in /jobs/gtfs-aggregator-scraper

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3113 - Bump aiohttp from 3.8.4 to 3.8.6 in /warehouse

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3112 - Bump aiohttp from 3.8.3 to 3.8.6 in /airflow

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3111 - Investigate differences between on/off taps and ask Littlepay about them

Issue - State: open - Opened by lauriemerrell about 1 year ago
Labels: project-payments, external-question

#3110 - DAG: copy_prod_archiver_configs_to_test

Pull Request - State: closed - Opened by charlie-costanzo about 1 year ago

#3109 - Payments: Make customer processing participant-specific

Pull Request - State: closed - Opened by lauriemerrell about 1 year ago - 1 comment

#3108 - Bump werkzeug from 2.3.4 to 2.3.8 in /warehouse

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 2 comments
Labels: dependencies, python

#3107 - Overhaul CI/CD and Deployment Documentation

Issue - State: closed - Opened by SorenSpicknall about 1 year ago

#3106 - Bump apache-airflow from 2.4.3 to 2.7.3 in /airflow

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 2 comments
Labels: dependencies, python

#3105 - Document all columns in `mart_payments` & review YAML

Issue - State: open - Opened by lauriemerrell about 1 year ago

#3104 - Document all columns in `mart_gtfs_schedule_latest` & review YAML

Issue - State: closed - Opened by lauriemerrell about 1 year ago

#3103 - Document all columns in `mart_gtfs_quality` & review YAML

Issue - State: open - Opened by lauriemerrell about 1 year ago

#3102 - Document all columns in `mart_transit_database` & review YAML

Issue - State: open - Opened by lauriemerrell about 1 year ago

#3101 - Document all columns in `mart_gtfs` & review YAML

Issue - State: closed - Opened by lauriemerrell about 1 year ago

#3100 - Deprecate obsolete `staging` tables/views

Issue - State: open - Opened by lauriemerrell about 1 year ago - 1 comment

#3099 - Resolve npm command non-recognition on warehouse build

Pull Request - State: closed - Opened by SorenSpicknall about 1 year ago

#3098 - Ask Littlepay about customer data model

Issue - State: open - Opened by lauriemerrell about 1 year ago
Labels: project-payments, external-question

#3097 - Payments: Make customer modeling participant-aware

Issue - State: closed - Opened by lauriemerrell about 1 year ago

#3096 - Improve warehouse README (part 2)

Pull Request - State: closed - Opened by allejo about 1 year ago

#3095 - Bump pyarrow from 9.0.0 to 14.0.1 in /airflow

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 2 comments
Labels: dependencies, python

#3094 - HOTFIX gpg command in Dockerfiles

Pull Request - State: closed - Opened by SorenSpicknall about 1 year ago

#3093 - Bump pyarrow from 12.0.1 to 14.0.1 in /images/jupyter-singleuser

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 2 comments
Labels: dependencies, python

#3092 - Bump pyarrow from 11.0.0 to 14.0.1 in /packages/calitp-data-analysis

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 2 comments
Labels: dependencies, python

#3091 - Improve warehouse README with some more information

Pull Request - State: closed - Opened by allejo about 1 year ago

#3090 - Use More Recent nodejs Version In Build Tasks

Pull Request - State: closed - Opened by SorenSpicknall about 1 year ago

#3089 - Restore Unpinned netlify-cli Version In Deps and Dockerfiles

Pull Request - State: closed - Opened by SorenSpicknall about 1 year ago

#3088 - Identify and Resolve Observed Issue with New Netlify CLI Version

Issue - State: closed - Opened by SorenSpicknall about 1 year ago

#3087 - HOTFIX: Pin version of Netlify CLI used in docs publication

Pull Request - State: closed - Opened by SorenSpicknall about 1 year ago

#3086 - Ask Littlepay about variable fare transaction missing a tap

Issue - State: open - Opened by lauriemerrell about 1 year ago
Labels: project-payments, external-question

#3085 - Ask Littlepay about missing device transactions rows

Issue - State: open - Opened by lauriemerrell about 1 year ago
Labels: project-payments, external-question

#3084 - Update pillow and urllib3 in requirements.txt files

Pull Request - State: closed - Opened by SorenSpicknall about 1 year ago

#3082 - Create Documentation Outlining Dependency Update Approaches

Issue - State: closed - Opened by SorenSpicknall about 1 year ago

#3081 - Expand JSON column values in the Benefits table into their own columns

Pull Request - State: closed - Opened by allejo about 1 year ago - 1 comment
Labels: project-benefits

#3080 - Remove unmaintained `uri` field from `dim_gtfs_datasets`

Issue - State: open - Opened by lauriemerrell about 1 year ago - 2 comments

#3079 - Investigate non-unique customer ID: DbtTestFail: test.calitp_warehouse.unique_int_littlepay__customers_customer_id

Issue - State: closed - Opened by cal-itp-sentry[bot] about 1 year ago - 1 comment

#3075 - Fix missing Littlepay transaction ids

Pull Request - State: closed - Opened by lauriemerrell about 1 year ago - 1 comment

#3074 - Payments: Investigate broken question in Metabase `Journeys with Unlabeled Routes`

Issue - State: closed - Opened by charlie-costanzo about 1 year ago - 1 comment

#3073 - Upgrade Littlepay data schema

Issue - State: closed - Opened by lauriemerrell about 1 year ago - 1 comment

#3071 - Bump pip from 20.2.4 to 23.3 in /airflow

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 2 comments
Labels: dependencies, python

#3066 - Create new table to be used for Mobility Marketplace's new provider map

Pull Request - State: closed - Opened by allejo about 1 year ago - 2 comments

#3062 - Upgrade urllib & pillow

Issue - State: closed - Opened by lauriemerrell about 1 year ago

#3057 - RT Archiver: Copy prod configs to test occasionally

Issue - State: closed - Opened by lauriemerrell about 1 year ago - 3 comments

#3056 - Update docs: how to update calitp-data-analysis

Pull Request - State: closed - Opened by amandaha8 about 1 year ago - 2 comments

#3055 - Bug: Python 3.12 Breaks Linting CI Task

Issue - State: closed - Opened by SorenSpicknall about 1 year ago

#3054 - Address a bunch of linter failures

Pull Request - State: open - Opened by lauriemerrell about 1 year ago

#3053 - Create `fct_payments_settlements`

Pull Request - State: open - Opened by lauriemerrell about 1 year ago - 1 comment

#3052 - Take most recent authorisation with non-null status for aggregation

Pull Request - State: open - Opened by SorenSpicknall about 1 year ago - 1 comment

#3051 - Fix payments aggregation column names in YAML

Pull Request - State: closed - Opened by lauriemerrell about 1 year ago

#3050 - Benefits: fact table by event phase - Enrollment

Issue - State: closed - Opened by thekaveman about 1 year ago - 3 comments
Labels: project-benefits

#3049 - Benefits: fact table by event phase - Auth

Issue - State: closed - Opened by thekaveman about 1 year ago - 3 comments
Labels: project-benefits

#3048 - Benefits: fact table by event phase - Eligibility

Issue - State: closed - Opened by thekaveman about 1 year ago - 4 comments
Labels: project-benefits

#3047 - Benefits: views by event phase

Issue - State: closed - Opened by thekaveman about 1 year ago - 1 comment
Labels: project-benefits

#3046 - Benefits: fact table expanding keys from JSON columns

Issue - State: closed - Opened by thekaveman about 1 year ago - 1 comment
Labels: project-benefits

#3045 - Benefits: extract additional fact tables from Amplitude event data for Metabase usage

Issue - State: closed - Opened by thekaveman about 1 year ago - 3 comments
Labels: epic, project-benefits

#3044 - Bump werkzeug from 2.2.2 to 3.0.1 in /airflow

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3043 - Payments: Add end of month date columns

Pull Request - State: closed - Opened by lauriemerrell about 1 year ago - 1 comment

#3042 - Payments: Add organization columns to mart tables for Metabase use

Pull Request - State: closed - Opened by lauriemerrell about 1 year ago - 1 comment

#3041 - Drop a few dupe micropayments

Pull Request - State: closed - Opened by SorenSpicknall about 1 year ago - 1 comment

#3040 - Payments: Create `fct_payments_aggregations` model

Pull Request - State: closed - Opened by lauriemerrell about 1 year ago - 1 comment

#3039 - Payments: Some Littlepay Customers Have Improper Principal Links

Issue - State: open - Opened by SorenSpicknall about 1 year ago

#3038 - Payments: littlepay_transaction_id missing from some fct_payments_rides_v2 rows

Issue - State: closed - Opened by SorenSpicknall about 1 year ago - 1 comment

#3037 - Payments documentation: Adding new agencies to Metabase

Pull Request - State: closed - Opened by charlie-costanzo about 1 year ago

#3036 - Payments: intermediate refunds table

Pull Request - State: open - Opened by charlie-costanzo about 1 year ago - 1 comment

#3035 - remove not null test from littlepay_participant_id in payments seed

Pull Request - State: closed - Opened by charlie-costanzo about 1 year ago

#3034 - Bump urllib3 from 1.26.17 to 1.26.18 in /jobs/gtfs-aggregator-scraper

Pull Request - State: open - Opened by dependabot[bot] about 1 year ago
Labels: dependencies, python

#3033 - Bump urllib3 from 1.26.17 to 1.26.18 in /ci

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago
Labels: dependencies, python

#3032 - Bump urllib3 from 1.26.16 to 1.26.18 in /images/jupyter-singleuser

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago
Labels: dependencies, python

#3031 - Bump urllib3 from 1.26.16 to 1.26.18 in /warehouse

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3030 - Bump urllib3 from 1.26.16 to 1.26.18 in /jobs/gtfs-schedule-validator

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3029 - Bump urllib3 from 1.26.16 to 1.26.18 in /services/gtfs-rt-archiver-v3

Pull Request - State: open - Opened by dependabot[bot] about 1 year ago
Labels: dependencies, python

#3028 - Bump urllib3 from 1.26.16 to 1.26.18 in /script

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3027 - Bump urllib3 from 1.26.14 to 1.26.18 in /packages/calitp-data-analysis

Pull Request - State: open - Opened by dependabot[bot] about 1 year ago
Labels: dependencies, python

#3026 - Bump urllib3 from 1.26.14 to 1.26.18 in /packages/calitp-data-infra

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3025 - Bump urllib3 from 1.26.12 to 1.26.18 in /airflow

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3024 - Payments: update payments_gtfs_datasets seed to include elavon customer_name

Pull Request - State: closed - Opened by charlie-costanzo about 1 year ago - 5 comments

#3023 - Bump urllib3 from 2.0.2 to 2.0.7 in /apps/maps

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 2 comments
Labels: dependencies, python

#3022 - Bump urllib3 from 2.0.2 to 2.0.7 in /jobs/gtfs-rt-parser-v2

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 3 comments
Labels: dependencies, python

#3021 - Suppress Bad Littlepay Customer Funding Source Row

Pull Request - State: closed - Opened by SorenSpicknall about 1 year ago - 1 comment

#3020 - Bump apache-airflow from 2.4.3 to 2.7.2 in /airflow

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, python

#3019 - Expand Littlepay Sync Setup Docs

Pull Request - State: closed - Opened by SorenSpicknall about 1 year ago - 2 comments

#3018 - Payments: make product_data a dim and version rows

Issue - State: open - Opened by SorenSpicknall about 1 year ago

#3017 - Payments: Investigate ID assignment edge case for Littlepay device_transactions rows

Issue - State: open - Opened by SorenSpicknall about 1 year ago - 3 comments
Labels: project-payments

#3016 - Payments: Intermediate settlements model

Pull Request - State: closed - Opened by lauriemerrell about 1 year ago - 1 comment

#3015 - DbtTestFail: test.calitp_warehouse.unique_proportion_fct_payments_rides_v2_0_999__micropayment_id.5542cc48bd -...

Issue - State: closed - Opened by cal-itp-sentry[bot] about 1 year ago

GitHub / cal-itp/data-infra issues and pull requests