DataVault4dbt - A Comprehensive Guide

REFERENCE DATA:

— Available Macros: — Reference Hub

— Reference Satellite (v0, v1) — Reference Tables

— Purpose: Store static or semi-static data that doesn’t change frequently and can be used to enrich the Data Vault model POINT-IN-TIME (PIT) TABLES:

— Available Macros:

Standard PITs (+ PIT Cleanup Hook)

— Purpose: Provide a snapshot of data at specific points in time for easier querying and reporting — Components: Combination of hash keys from hubs and links to capture the state of data at a given time

17/18