How scalefreecom/datavault4dbt works
datavault4dbt is a dbt macro package for building Data Vault 2.0 warehouses. A data engineer supplies flat, wide source data and configures dbt models; the macros support staging transformations and generate vault and business-vault structures in the target database. The README documents these capabilities, but no source excerpts were provided, so links show documented usage rather than implementation-level calls or a verified execution sequence.
Main entry points: stage.sql Staging Macros · hub.sql Hubs · link.sql Links · sat_v0.sql Satellites
Components 17
Staging
- Staging Macros
macros/staging/stage.sql - Staging Helpers
macros/staging - Metadata Processing
macros/internal/metadata_processing
Core Vault
- Hubs
macros/tables/hub.sql - Links
macros/tables/link.sql - Satellites
macros/tables/sat_v0.sql - Non-Historized Entities
macros/tables/nh_link.sql - Multi-Active Satellites
macros/tables/ma_sat_v0.sql - Effectivity & Tracking
macros/tables/eff_sat_v0.sql
Reference Data
- Reference Hubs
macros/tables/ref_hub.sql - Reference Satellites
macros/tables/ref_sat_v0.sql - Reference Tables
macros/tables/ref_table.sql
Business Vault
- PIT Tables
macros/tables/pit.sql - Snapshot Control
macros/tables/control_snap_v0.sql
Other components
- Data Engineer
- Source Data
- Target Database
Connections 25
- Data Engineer → Staging Macros: uses macros
README.md - Source Data → Staging Macros: provides inputs
README.md - Data Engineer → Hubs: uses macros
README.md - Data Engineer → Links: uses macros
README.md - Data Engineer → Satellites: uses macros
README.md - Data Engineer → Non-Historized Entities: uses macros
README.md - Data Engineer → Multi-Active Satellites: uses macros
README.md - Data Engineer → Effectivity & Tracking: uses macros
README.md - Data Engineer → Reference Hubs: uses macros
README.md - Data Engineer → Reference Satellites: uses macros
README.md - Data Engineer → Reference Tables: uses macros
README.md - Data Engineer → PIT Tables: uses macros
README.md - Data Engineer → Snapshot Control: uses macros
README.md - Staging Macros → Target Database: builds staging
README.md - Hubs → Target Database: creates entities
README.md - Links → Target Database: creates entities
README.md - Satellites → Target Database: creates entities
README.md - Non-Historized Entities → Target Database: creates entities
README.md - Multi-Active Satellites → Target Database: creates entities
README.md - Effectivity & Tracking → Target Database: creates entities
README.md - Reference Hubs → Target Database: creates entities
README.md - Reference Satellites → Target Database: creates entities
README.md - Reference Tables → Target Database: creates entities
README.md - PIT Tables → Target Database: creates tables
README.md - Snapshot Control → Target Database: creates snapshots
README.md