Audit-ready vintages for an SPA / SIGAP review pack
Built a quarterly vintage-freeze pipeline + jurisdiction-filtered marts. Operator handed the regulator a self-contained pack; review closed in two weeks instead of six.
- Audit window6w → 2w
- Frozen tables12
- Engagement4 weeks
A Brazilian regulated gaming operator faced an SPA review and didn't have a clean way to freeze a quarterly vintage. The numbers in BI shifted retroactively as late-arriving facts updated.
Built a vintage-freeze job: signs and seals a snapshot of GMV / GGR / hold tables per jurisdiction at quarter close, retains for the regulatory window, and exposes them as `marts_audit.*` schemas with a row-level access policy.
The regulator reviewed a self-contained pack with the same numbers as the operator's BI. Review closed in 2 weeks; the playbook is now standard for the next two jurisdictions.
Wire a real pipeline to your warehouse
30-min stack review. We come back with a scoped plan, an owner, and a freshness contract. No SDR, no slide deck.