finds.dev

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)

View on GitHubHomepage ↗

★ 589Apache-2.0updated Feb 2026

// the take

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.

We read the README, the directory tree and a key source file in June 2026. Nobody pays to be listed. How we judge →

// at a glance

Stars
589
Forks
154
License
Apache-2.0
Last commit
5 Feb 2026

// nearby

If automate-dv isn't quite it.

All repos →