Skills
.Work. You
Rest

slowly-changing-dimensions

Community

Implement SCD patterns to track history.

Data & Analytics#dbt#history#etl#data-modeling#snapshot#scd
Authornrakow
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Design and implement Slowly Changing Dimensions (SCD) patterns to track attribute history across data warehouses using dbt snapshots.

Core Features & Use Cases

  • Type 1: Overwrite current attribute values when corrections occur.
  • Type 2: Add new row for each change to preserve history and enable point-in-time joins.
  • Type 3: Track one prior value for quick comparisons.
  • Use Cases: When auditing customer attributes, pricing history, or policy changes over time; build accurate BI and analytics that reflect historical context.

Quick Start

Run the dbt snapshot for Type 2 history, then validate results with tests.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: slowly-changing-dimensions
Download link: https://github.com/nrakow/ae-skills-dev/archive/main.zip#slowly-changing-dimensions

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.