DataVault4dbt
Powered by Scalefree
A quick and easy-to-use solution to implement performant Data Vault solutions.
Unlock 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.
Open-source dbt Package by Scalefree
Harness the Power of Data Vault
Leverage all the advantages of Data Vault 2.0, including comprehensive historization, unparalleled flexibility, efficient parallel loading, and complete auditability.
Simplified Implementation
Eliminate the complexities of managing loading patterns and dependencies. DataVault4dbt automates these processes, allowing you to focus on deriving value from your data.
Guaranteed Standardization
Ensure adherence to Data Vault naming conventions and hashing standards from the outset, promoting consistency and efficiency across your data pipelines.
End-to-End Data Vault Coverage
Seamlessly manage your entire Data Vault lifecycle, from Staging to Raw Vault and Business Vault, all within the familiar dbt environment.
Developer Freedom
Use your preferred IDE (dbt Cloud IDE or VSCode) and combine SQL and Python in your dbt project.
dbt Talk – Hub & Speak
Supported Databases
Frequently 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.