Skip to content
Back to challenges
Company Tracks: Netflix-style and Stripe-styleConcept Challengeadvanced30 minPro

Stripe MRR snapshots

Model a monthly MRR periodic snapshot joined to a Type 2 plan dimension so plan changes are reflected per period.

How this preview works
Preview this problem before signing in. Sign in to save progress and submit work.

Concept

slowly-changing-dimensions

The primary modeling idea this problem reinforces.

Requirements

0

Business needs the model must satisfy.

Read the concept guide: Slowly changing dimensions: Type 2
Scenario

Finance needs monthly recurring revenue per account, with plan price and tier reflected as they were each month. Plans change price over time. The account and plan dimensions exist; the plan dimension overwrites price in place.

Why this matters

MRR is state observed monthly, a periodic snapshot. Joined to a Type 2 plan, each month reflects the plan version then in effect; overwriting the plan rewrites history.

Requirements
    Read-only starter workspace
    Inspect the authored starting ERD, then open the workspace to edit and run the checks. Saving your progress needs a free account.

    Template

    The model users start from in the full workspace.

    Entities

    0

    Seeded tables visible in the public preview.

    Dialect

    postgresql

    Generated SQL target for this starter model.

    Mini Map

    This preview is read-only. Open the workspace to edit and verify; saving needs a free account.

    Open workspace

    Try the question first.

    The discussion has other people's approaches and solutions. Give it a real attempt before you read them.