Why Is There a MAR Spike Every Saturday for the BALANCE_TRANSACTION Table?

Question

Why is there a MAR spike every Saturday for the BALANCE_TRANSACTION table?

Environment

Connector: Stripe

Answer

Stripe's API does not inform us when pending transactions are settled. To ensure that transactions are up-to-date, we re-sync all pending transactions in the BALANCE_TRANSACTION table every Saturday. We sync all other transaction types incrementally.