AutomateDV review
A free, open-source dbt package for metadata-driven Data Vault ETL.
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
AutomateDV is a free, open-source dbt package for data engineers building Data Vault data platforms. It uses metadata to generate and execute ETL code, helping teams reduce hand-written SQL. Its core structures are hubs, links, and satellites, so it suits teams that have chosen Data Vault rather than those looking for tooling across several warehouse modeling approaches. It is self-hosted and runs within dbt, which supplies the broader pipeline workflow.
The package includes reusable dbt macros and generates SQL following dbt style conventions. Its supported warehouses are Snowflake, SQL Server, Postgres, Google BigQuery, and Databricks. That combination makes AutomateDV relevant to teams already working in dbt and one of those warehouse environments: metadata-driven generation addresses repeatable Data Vault transformations, while dbt remains the surrounding workflow. The five warehouse options provide platform choice, but they do not change the product's Data Vault focus.
There is no separate hosted product or paid tier described; AutomateDV is positioned as a free, open-source package rather than a separately priced service. Business Thinking Limited provides documentation, tutorials, and a community Slack channel. This is a practical fit for small, mid-market, or enterprise teams willing to own a self-hosted dbt workflow and comfortable with Data Vault. Teams seeking a standalone automation platform, hosted deployment, or a tool centered on multiple modeling methods should look elsewhere.
AutomateDV pros and cons
- Where it wins
- Generates and executes ETL code from metadata
- Provides dbt macros for reusable transformations
- Supports five named warehouses, including Snowflake and BigQuery
- Where it doesn't
- Focused on Data Vault modeling rather than multiple approaches
- Runs within dbt, not as a standalone warehouse platform
- Self-hosted deployment requires a dbt-based workflow
AutomateDV fact sheet, pricing and score →
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update