cal-itp/data-infra issues and pull requests

#3038 - Payments: littlepay_transaction_id missing from some fct_payments_rides_v2 rows

Issue - State: closed - Opened by SorenSpicknall 11 months ago - 1 comment

#3037 - Payments documentation: Adding new agencies to Metabase

Pull Request - State: closed - Opened by charlie-costanzo 12 months ago

#3036 - Payments: intermediate refunds table

Pull Request - State: open - Opened by charlie-costanzo 12 months ago - 1 comment

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

Pull Request - State: closed - Opened by charlie-costanzo 12 months 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] 12 months 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] 12 months 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] 12 months 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] 12 months 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] 12 months 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] 12 months 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] 12 months 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] 12 months 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] 12 months 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] 12 months 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 12 months 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] 12 months 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] 12 months ago - 3 comments
Labels: dependencies, python

#3021 - Suppress Bad Littlepay Customer Funding Source Row

Pull Request - State: closed - Opened by SorenSpicknall 12 months 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] 12 months ago - 1 comment
Labels: dependencies, python

#3019 - Expand Littlepay Sync Setup Docs

Pull Request - State: closed - Opened by SorenSpicknall 12 months ago - 2 comments

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

Issue - State: open - Opened by SorenSpicknall 12 months ago

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

Issue - State: open - Opened by SorenSpicknall 12 months ago - 3 comments

#3016 - Payments: Intermediate settlements model

Pull Request - State: closed - Opened by lauriemerrell 12 months 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] 12 months ago

#3014 - Payments: fix join on feed_key for agency_name in fct_payments_ride_v2

Pull Request - State: closed - Opened by charlie-costanzo 12 months ago - 4 comments

#3013 - Missing device transactions column

Pull Request - State: closed - Opened by lauriemerrell 12 months ago - 1 comment

#3012 - DbtModelError: model.calitp_warehouse.fct_payments_rides_v2: device transactions missing geography column

Issue - State: closed - Opened by cal-itp-sentry[bot] 12 months ago

#3011 - Suppress duplicate row that is causing settlements test to fail

Pull Request - State: closed - Opened by lauriemerrell 12 months ago - 1 comment

#3010 - DbtTestFail: test.calitp_warehouse.unique_stg_littlepaysettlementspayments_key

Issue - State: closed - Opened by cal-itp-sentry[bot] 12 months ago

#3009 - Fix data type in transit funding programs schema

Pull Request - State: closed - Opened by tiffanychu90 12 months ago

#3008 - Add agency information to fct_payments_rides_v2

Pull Request - State: closed - Opened by charlie-costanzo 12 months ago - 1 comment

#3007 - Update Codeowners

Pull Request - State: closed - Opened by evansiroky 12 months ago

#3006 - remove shape_array_key from yml

Pull Request - State: closed - Opened by tiffanychu90 12 months ago

#3005 - Remove Caltrans District from transit data quality issues table

Pull Request - State: closed - Opened by evansiroky 12 months ago

#3004 - Difficulties locally testing for metabase sync issues

Issue - State: open - Opened by evansiroky 12 months ago

#3003 - Transit funding schema

Pull Request - State: closed - Opened by tiffanychu90 12 months ago - 1 comment

#3002 - re-add columns in billing intermediate table to allow for union downstream

Pull Request - State: closed - Opened by charlie-costanzo 12 months ago - 1 comment

#3001 - Payments: Summarized authorisations model

Pull Request - State: closed - Opened by lauriemerrell 12 months ago - 2 comments

#3000 - Bump gitpython from 3.1.32 to 3.1.37 in /images/jupyter-singleuser

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

#2999 - Bump gitpython from 3.1.32 to 3.1.37 in /ci

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

#2998 - Payments: Handle remaining duplicate authorisation `_payments_key` values

Issue - State: open - Opened by lauriemerrell 12 months ago

#2997 - Bump postcss from 8.4.23 to 8.4.31 in /apps/maps

Pull Request - State: closed - Opened by dependabot[bot] 12 months ago - 3 comments
Labels: dependencies, javascript

#2996 - Add new Littlepay columns + correct mistyped columns

Pull Request - State: closed - Opened by SorenSpicknall 12 months ago - 2 comments

#2995 - Bug: Incorrectly named Littlepay columns prevent data movement

Issue - State: closed - Opened by SorenSpicknall 12 months ago

#2994 - Payments staging models refactor: settlements, micropayments, refunds

Pull Request - State: closed - Opened by lauriemerrell 12 months ago - 1 comment

#2993 - Littlepay Table Deduplication Adjustments

Pull Request - State: closed - Opened by SorenSpicknall 12 months ago - 1 comment

#2992 - Payments settlements: add missing columns for Anaheim and all agencies

Pull Request - State: closed - Opened by lauriemerrell 12 months ago

#2991 - Update CODEOWNERS

Pull Request - State: closed - Opened by tiffanychu90 12 months ago - 1 comment

#2990 - Payments: Remove over-aggressive file deduping

Pull Request - State: closed - Opened by lauriemerrell 12 months ago - 1 comment

#2989 - Add seed mapping Elavon customer names to Littlepay participant IDs

Issue - State: closed - Opened by lauriemerrell 12 months ago

#2988 - Bump pillow from 9.5.0 to 10.0.1 in /warehouse

Pull Request - State: open - Opened by dependabot[bot] 12 months ago
Labels: dependencies, python

#2987 - Bump pillow from 9.5.0 to 10.0.1 in /jobs/gtfs-rt-parser-v2

Pull Request - State: open - Opened by dependabot[bot] 12 months ago
Labels: dependencies, python

#2986 - Bump pillow from 10.0.0 to 10.0.1 in /images/jupyter-singleuser

Pull Request - State: open - Opened by dependabot[bot] 12 months ago
Labels: dependencies, python

#2985 - fix typo in stg_transit_database__funding_programs

Pull Request - State: closed - Opened by tiffanychu90 12 months ago - 2 comments

#2984 - Payments: Identifying uncollectible debt / debt recovery / chargebacks

Issue - State: closed - Opened by charlie-costanzo 12 months ago

#2983 - Bug: typo in `stg_transit_database__funding_programs`

Issue - State: closed - Opened by tiffanychu90 12 months ago - 2 comments

#2982 - Payments: Documentation - Creating a new dashboard/ questions

Issue - State: closed - Opened by charlie-costanzo 12 months ago

#2981 - Payments: Documentation - Adding a new agency data source to metabase

Issue - State: closed - Opened by charlie-costanzo 12 months ago

#2980 - Payments: Documentation - Adding a new agency to the pipeline

Issue - State: closed - Opened by charlie-costanzo 12 months ago

#2979 - Payments: Ensure settlements are being captured correctly Littlepay/Elavon data

Issue - State: closed - Opened by charlie-costanzo 12 months ago

#2978 - Payments: Ensure refunds are being captured correctly Littlepay/Elavon data

Issue - State: open - Opened by charlie-costanzo 12 months ago - 1 comment

#2976 - Payments: Updates to fct_payments_rides_v2

Issue - State: closed - Opened by charlie-costanzo 12 months ago - 1 comment

#2975 - Payments: Dashboard updates / QA / refactoring PT 1

Issue - State: closed - Opened by charlie-costanzo 12 months ago

#2974 - Bump urllib3 from 1.26.16 to 1.26.17 in /images/jupyter-singleuser

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

#2973 - Bump urllib3 from 1.26.16 to 1.26.17 in /warehouse

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

#2972 - Bump urllib3 from 1.26.16 to 1.26.17 in /ci

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

#2971 - Bump urllib3 from 1.26.16 to 1.26.17 in /script

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

#2970 - Bump urllib3 from 1.26.16 to 1.26.17 in /services/gtfs-rt-archiver-v3

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

#2969 - Bump urllib3 from 1.26.16 to 1.26.17 in /jobs/gtfs-schedule-validator

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

#2968 - Bump urllib3 from 1.26.16 to 1.26.17 in /jobs/gtfs-aggregator-scraper

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

#2967 - Bump urllib3 from 1.26.14 to 1.26.17 in /packages/calitp-data-analysis

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

#2966 - Bump urllib3 from 1.26.14 to 1.26.17 in /packages/calitp-data-infra

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

#2965 - Bump urllib3 from 1.26.12 to 1.26.17 in /airflow

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

#2964 - Bump urllib3 from 2.0.2 to 2.0.6 in /jobs/gtfs-rt-parser-v2

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

#2963 - Bump urllib3 from 2.0.2 to 2.0.6 in /apps/maps

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

#2962 - New Team Member - Shweta Adhikari

Issue - State: closed - Opened by KatrinaMKaiser 12 months ago
Labels: new team member

#2961 - Deprecate obsolete Payments models

Issue - State: open - Opened by lauriemerrell 12 months ago - 3 comments

#2960 - Make a standalone `int_payments__micropayments` and/or `int_payments__micropayment_device_transactions` model

Issue - State: closed - Opened by lauriemerrell 12 months ago

#2959 - Break up payments rides

Issue - State: closed - Opened by lauriemerrell 12 months ago

#2958 - Payments: Develop `fct_aggregations` model

Issue - State: closed - Opened by lauriemerrell 12 months ago

#2957 - Payments: Add string handling, refactor modeling of Elavon data

Pull Request - State: closed - Opened by charlie-costanzo almost 1 year ago - 2 comments

#2956 - Payments: refactor elavon transactions and add handling for empty strings

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

#2955 - Manually fix corrupt files from LP

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

#2954 - Initial authorisations modeling

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

#2950 - Bump gitpython from 3.1.32 to 3.1.35 in /images/jupyter-singleuser

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

#2949 - Bump gitpython from 3.1.32 to 3.1.35 in /ci

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

#2948 - Bump cryptography from 36.0.2 to 41.0.4 in /airflow

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

#2942 - Bump apache-airflow from 2.4.3 to 2.7.1 in /airflow

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

#2941 - Remove Laurie from codeowners & non-Payments DAG emails

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

#2940 - Add incomplete variable fares to device transaction types so they willl appear in payments rides

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

#2939 - remove @charlie-costanzo from codeowners

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

#2938 - add stub docs on which software to request for Git/VS Code on Caltrans PCs

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

#2937 - Bump gitpython from 3.1.32 to 3.1.34 in /images/jupyter-singleuser

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

#2936 - Bump gitpython from 3.1.32 to 3.1.34 in /ci

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

#2935 - GTFS Validator Upgrade Follow-Up

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

#2934 - change fct_payments_rides_v2 join to include missing transactions

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

#2933 - make payments dags run hourly

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

#2932 - tweaks and loom link

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

#2931 - Candidates/main

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

#2930 - Candidates/downgrade metabase test

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

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