data-infra icon indicating copy to clipboard operation
data-infra copied to clipboard

Ask Littlepay about variable fare transaction missing a tap

Open lauriemerrell opened this issue 1 year ago • 0 comments

In the course of investigating #3038, we found that we have an individual micropayment with a charge_type of complete_variable_fare but where there is only one device transaction. As an analytics engineer, I want to ask the data vendor about this issue because I am not sure whether this transaction should be dropped.

This row ends up missing a littlepay_transaction_id in fct_payments_rides because it is dropped in this join in int_littlepay__device_transaction_types, which becomes an inner join filter in the payments rides table.

AC: -[ ] Reach out to Littlepay to clarify how this transaction should be handled

lauriemerrell avatar Nov 08 '23 17:11 lauriemerrell