Data Vault 2.0 Data Modeling

When to Use

Use this skill when:

• Designing a Raw Vault schema: Hubs, Links, Satellites for a new source system
• Implementing hash key generation and hash diff columns
• Writing insert-only DML load patterns for any vault entity
• Designing performance constructs: PIT tables and Bridge tables
• Implementing Business Vault: computed satellites, derived links, exploration links
• Constructing Information Mart views/tables from the vault
• Building DV 2.0 pipelines in Spark, dbt, Airflow, or pure SQL
• Choosing between Satellite variants: standard, multi-active, effectivity, status-tracking

Architecture Overview

Data Vault 2.0 separates concerns into three layers: