search

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

payments: merge United States issuer_country values in stg_littlepay__customer_funding_source #3393

Closed charlie-costanzo closed 2 months ago

charlie-costanzo commented 2 months ago

Description

This pull request alters the Littlepay payments staging table stg_littlepay__customer_funding_source table to force one value related to the issuer_country field for the United States.

Previously, two values existed: ‘UNITED STATES’ and ‘UNITED STATES OF AMERICA (THE)’. This PR adds SQL code to change both fields to the ‘UNITED STATES’ value.

Resolves #3392

Type of change

How has this been tested?

local dbt run and dbt test

Post-merge follow-ups

github-actions[bot] commented 2 months ago

Warehouse report 📦

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