DataVault4dbt - A Comprehensive Guide

2. EXPLANATIONS WHAT IS DATA VAULT 2.0?

Data Vault 2.0 is a methodology designed to provide long-term historical storage of data from multiple operational systems. It aims to offer a flexible, scalable, and auditable approach to data warehousing. Data Vault 2.0 extends the original Data Vault methodology by incorporating best practices, techniques, and methodologies for achieving a comprehensive data management system, including both the technical and the business aspects. KEY CONCEPTS AND TERMINOLOGY — Hubs: Represent unique business keys. Each hub table contains a list of unique business keys, which are the main entities in the data model — Links: Capture the relationships between hubs. They represent associations or transactions between business keys — Satellites: Store the descriptive attributes and context for the business keys and links. Satellites contain historical data and are associated with either hubs or links

— Business Keys: Unique identifiers that represent the core business concepts or entities

6/18