Scalefree  /  Knowledge Hub  /  Guides  /  DataVault4dbt

DataVault4dbt
A Comprehensive Guide

DataVault4dbt is Scalefree’s open-source dbt package for implementing Data Vault 2.0. Built on years of practical project experience, it automates the creation of Data Vault entities through macros, so teams can build robust, standards-compliant data warehouse models without writing the SQL for their raw vault entities manually.

This guide starts with the fundamentals of Data Vault 2.0 and how it integrates with dbt, then walks you through installing the package and configuring its global variables. Detailed examples show how metadata defined in YAML is passed to the macros to generate hubs, links, satellites, and more, including ghost records and incremental loading out of the box.

It also gives an overview of all supported entities, from staging and standard hubs to multi-active, record-tracking, and effectivity satellites, reference data, and PIT tables, along with how the package handles CDC, transient, and persistent sources.

In this guide, you will:

  • Understand how DataVault4dbt brings Data Vault 2.0 standards and automation into dbt
  • Learn how to install the package, configure global variables, and build your first models
  • Discover all supported entities and how to use them in heterogeneous data landscapes

Ready to automate your Data Vault with dbt? Get in touch with our experts.