Skills
.Work. You
Rest

slowly-changing-dimensions-minimal

Official

Manage slowly changing dimensions in data models with minimal overhead.

Data & Analytics#database#data-integrity#data-modeling#data-history#slowly-changing-dimensions
Authorsnoodleboot-io
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill helps manage changes in data over time, such as customer name changes, without the need for complex data structures.

Core Features & Use Cases

  • Type 1: Overwrite - Update existing records with new information.
  • Type 2: Add New Row - Maintain history by adding new records with effective dates.
  • Type 3: Add Column - Store both previous and current values in a single column.
  • Use Case: For a customer relationship management system, this Skill can handle changes in customer names, keeping a history of name changes without the need for additional tables.

Quick Start

Use the dim_customer table to update the customer name with minimal overhead by choosing the appropriate type for your data model.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 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-minimal
Download link: https://github.com/snoodleboot-io/prompticorn/archive/main.zip#slowly-changing-dimensions-minimal

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 620,000+ vetted skills library on demand.