DataVault4dbt
Powered by Scalefree
The open-source solution that brings all your favorite Data Vault entities into your dbt Project.
Get DataVault4dbt NowUnlock the full potential of Data Vault with DataVault4dbt
Industry-Standard Data Vault
DataVault4dbt adheres to proven Data Vault standards established by the inventor, ensuring future-proof and reliable data management.
Works With Any Data Source
Effortlessly integrate data from any source, whether it’s Change Data Capture (CDC), transient, or persistent. DataVault4dbt handles it all.
Built on Expertise
Leverage the best practices of our experienced Data Vault professionals who have implemented and optimized Data Vault solutions across diverse environments.
Tailored to Your Needs
Configure DataVault4dbt to match your specific requirements and organizational standards. Customize everything from hashing algorithms to timestamp formats with our extensive global variables.
Elevate Your Data Vault with DataVault4dbt Premium
DataVault4dbt has become the cornerstone of robust data platforms, empowering organizations to automate Data Vault development with unparalleled efficiency. To help you fully capitalize on its power, we proudly introduce DataVault4dbt Premium.
Get DataVault4dbt PremiumClients That Use DataVault4dbt
“We’ve elevated our Data Warehouse to a new dimension with a Data Vault built on the DataVault4dbt package. It provides clean historization, high maintainability, and a robust architecture—all without the need for complex, UI-driven tools.”
Maximilian Ferdinand Müller
Principal Platform Engineer at Clariness GmbH
DataVault4dbt Supported Databases
Why DataVault4dbt is Your First Choice
| Features | DATAVAULT4dbt | Other Packages |
|---|---|---|
| Generating SQL Code | ||
| Bring Hubs, Links, Satellites to dbt | ||
| Adhering to Data Vault 2 standards | ||
| Dynamically supporting multi-batch processing | ||
| Extensive customization options without coding |
DataVault4dbt Updates
VS Code Extension to accelerate your workflow
Want to improve your workflow with Datavault4dbt? Snippets are now available as a Visual Studio Code Extension.
Fully Compatible with dbt Fusion engine
Datavault4dbt is fully compatible with the new dbt Fusion Engine! Install v1.14.0 or newer for out-of-the-box support.
dbt Talk – Hub & Speak
Every first Thursday of a month, our dbt experts will talk about various dbt topics. You can send your questions in advance or during the sessions. These will be addressed as well as prepared topics like Data Vault macros, testing or CI/CD.
Submit My QuestionsFrequently Asked Questions
How can I start using DataVault4dbt?
Visit the dbt Hub page of DataVault4dbt to find the two lines of code to add to your packages.yml inside your dbt project. After adding those lines, run a “dbt deps” statement and start using our templates right away.
What databases are currently supported by DataVault4dbt?
We currently support Snowflake, Google BigQuery, PostgreSQL, Amazon Redshift, Azure Synapse Analytics, Microsoft Fabric, Databricks, Oracle, and Exasol. More databases are being supported continuously.
Which Data Vault entities are included in DataVault4dbt?
DataVault4dbt currently includes macros for Stages, Hubs, Links, Satellites, Non-Historized Links, and more.
How can I customize DataVault4dbt?
DataVault4dbt is based on global variables that influence the entire structure of the generated code. Users can configure many aspects like hash algorithms, technical column aliases, and more.