data_vault_2
CommunityDesign Data Vault 2.0 models end-to-end.
Software Engineering#data vault 2.0#hash keys#hash diffs#pit tables#bridge tables#insert-only loading#information marts
Authorivanshamaev
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Data Vault 2.0 modeling helps you build durable, audit-friendly data warehouse foundations that can ingest changing data over time without losing history or forcing destructive updates.
Core Features & Use Cases
- End-to-end Data Vault 2.0 design: define Hubs, Links, Satellites, Reference Tables, Same-As Links, and PIT/Bridge constructs for query performance.
- Deterministic keying for integration: implement hash key generation and hash diff calculation (including normalization, NULL sentinels, and compound key delimiters) to enable consistent joins and change detection.
- Insert-only loading patterns: produce safe DDL and DML patterns for insert-only Hub/Link/Satellite loads, plus variant handling like Multi-Active and Effectivity satellites.
- Business Vault to Information Mart translation: apply business rules via computed satellites and then construct analyst-friendly dimensions and facts from vault structures.
Quick Start
Ask the AI to generate the full Data Vault 2.0 modeling blueprint for your source system, including staging views with hash keys and hash diffs, DDL for hubs/links/satellites (and PIT/Bridge if needed), and insert-only load SQL patterns.
Dependency Matrix
Required Modules
None requiredComponents
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: data_vault_2 Download link: https://github.com/ivanshamaev/de-agent-skills/archive/main.zip#data-vault-2 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 471,000+ vetted skills library on demand.