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

Netflix title history (SCD2)

Make the title dimension Type 2 so viewing reflects the metadata in effect when it happened.

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

Title metadata (maturity rating and category) changes over time. Analysts want viewing analyzed against the metadata as it was when the view occurred. The current title dimension overwrites metadata in place.

Why this matters

Overwriting metadata makes past viewing look like it had today’s rating or category. A Type 2 title dimension preserves each version with a validity window.

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.