03-fact-table-patterns
OfficialMaster advanced fact table design patterns.
Data & Analytics#data modeling#data warehousing#dimensional modeling#gold layer#fact table#measure additivity
Authordatabricks-solutions
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses the complexities of designing robust fact tables in dimensional modeling, ensuring accurate aggregations and preventing silent data errors by classifying measures and applying specialized patterns.
Core Features & Use Cases
- Measure Additivity Classification: Distinguish between additive, semi-additive, and non-additive measures to guide aggregation logic.
- Advanced Fact Patterns: Implement factless facts, accumulating snapshots, consolidated facts, and header/line patterns for diverse business scenarios.
- Use Case: When designing a sales fact table, use this Skill to correctly identify that
revenueis additive,account_balance(if included) is semi-additive, andunit_priceis non-additive, ensuring correct reporting.
Quick Start
Use the 03-fact-table-patterns skill to classify measures as additive, semi-additive, or non-additive for a new fact table.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 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: 03-fact-table-patterns Download link: https://github.com/databricks-solutions/vibe-coding-workshop-template/archive/main.zip#03-fact-table-patterns Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.