// the find
Datavault-UK/automate-dv
A free to use dbt package for creating and loading Data Vault 2.0 compliant Data Warehouses (powered by dbt, an open source data engineering tool, registered trademark of dbt Labs)
AutomateDV is a dbt package that generates the SQL boilerplate for Data Vault 2.0 warehouses — hubs, links, satellites, PITs, bridges — across Snowflake, BigQuery, Databricks, SQL Server, and Postgres. You describe your vault structure in YAML metadata and the macros write the load SQL for you. It's for data engineers who've committed to DV2 methodology and want to skip typing the same insert patterns 40 times.
Platform coverage is genuinely broad — per-platform macro implementations mean BigQuery and Snowflake variants handle dialect quirks rather than papering over them. The materialisation library includes period and rank-based incremental strategies that are non-trivial to write correctly from scratch. Ghost record generation is handled out of the box, which is one of the fiddliest parts of DV2 correctness. dbt Fusion compatibility badge is current as of early 2026, so it's tracking the dbt ecosystem actively.
589 stars in what is now a fairly mature dbt ecosystem suggests limited adoption outside Datavault UK's own consulting orbit — you're betting on a small team's continued interest. The macro abstraction means debugging generated SQL is painful; when something goes wrong at scale you're reading Jinja output, not the code you wrote. No native support for hashed diff / delta detection beyond what dbt incremental strategies provide, so high-volume satellite loads can still blow up costs. Documentation lives on ReadTheDocs but the worked example is a separate repo — onboarding is more fragmented than it needs to be.