Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Payments: make product_data a dim and version rows #3018

Open
SorenSpicknall opened this issue Oct 16, 2023 · 0 comments
Open

Payments: make product_data a dim and version rows #3018

SorenSpicknall opened this issue Oct 16, 2023 · 0 comments

Comments

@SorenSpicknall
Copy link
Contributor

User story / feature request

During the implementation of Littlepay deduplication changes, we considered the idea that (unlike other tables from Littlepay) it may be correct to treat the product_data exports from the vendor as slowly changing type 2 data. Rather than overwriting rows when a new export includes a row with the same unique ID (which we do for other tables, since the latest version of a given row is treated as canonical across all time frames the row was active), we may need to store multiple time-bounded versions of the same row.

Note that, at the time of issue creation, we are not yet 100% certain that this is the most correct path to take. Further investigation is needed.

Acceptance Criteria

If we determine that this path is appropriate, we'll need to create a mapping between rows in the product_data table and rows in other Littlepay tables that reference product_ids, using a similar versioned system to we do for GTFS data.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant