AutomateDV
AutomateDV: A free, open-source dbt package for metadata-driven Data Vault ETL. Ranked #6 of 13 in Data Warehouse Automation Software by our editors (7.8/10); pricing: Free plan; best for teams using dbt and Data Vault on a budget.
At a glance
- Editor score7.8 / 10
- PricingFree plan
- Best forTeams using dbt and Data Vault on a budget
- Free planYes
- Paid fromFree
- Warehouse modelingData_vault
- Founded2019
- Facts checked24 Sep 2026
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
Our verdict on AutomateDV
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.
Your product? Our editors can test AutomateDV in depth and publish a review, labelled as paid · from $149/mo →
AutomateDV pricing
AutomateDV fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Deployment options | Self-hosted |
| Warehouse modeling | Data_vault |
| Supported warehouses | Snowflake, SQL Server, Postgres, Google BigQuery, Databricks |
| Version control | Not verified |
| Code generation | Yes |
| Trial length | 0 days |
| Deployment | Self-hosted |
| Platforms | Linux |
| Support | Community, Docs |
| Built for | Small business, Mid-market, Enterprise (editorial estimate) |
| Integrations | 6 integrations: dbt, Snowflake, SQL Server, Postgres, Google BigQuery, Databricks |
| Pricing | Free plan |
| Website | automate-dv.com |
| Facts checked | 24 Sep 2026 |
AutomateDV integrations
AutomateDV lists 6 integrations on its own site.
- dbt
- Snowflake
- SQL Server
- Postgres
- Google BigQuery
- Databricks
Alternatives to AutomateDV
- Coalesce TransformA cloud transformation workspace pairing reusable patterns with testing, lineage and Git deployments.8.8
- VaultSpeedA focused cloud platform for generating Data Vault models, transformations, and pipelines.8.6
- TimeXtenderEnd-to-end warehouse automation for teams prepared for annual enterprise pricing.8.4
See all AutomateDV alternatives →
AutomateDV vs the competition
- AutomateDV vs Coalesce Transform
- AutomateDV vs VaultSpeed
- AutomateDV vs TimeXtender
- AutomateDV vs Astera Data Warehouse Builder
- AutomateDV vs BimlFlex
- AutomateDV vs DataMerlin
Compare AutomateDV with any tool side by side →
Used AutomateDV? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used AutomateDV for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
AutomateDV is listed in our Data Warehouse Automation Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/automatedv/"><img src="https://www.itechguides.com/best/badge/automatedv.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
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