DataVault4dbt - A Comprehensive Guide

LINKS:

— Available Macros:

Standard Links, Non-Historized Links

— Purpose: Capture relationships between business keys stored in hubs

— Components: Hash key (a unique identifier for each relationship), foreign keys (references to the business keys in the hubs), load date and record source SATELLITES:

— Available Macros:

— Standard Satellites (v0, v1) — Multi-Active Satellites (v0, v1) — Record-Tracking Satellites — Non-Historized Satellites — Effectivity Satellites

— Purpose: Store descriptive attributes and historical data related to hubs or links

— Components: Hash key (a unique identifier), attributes (descriptive data), record source, load dates, and end dates for tracking changes over time

16/18