DataVault4dbt
Powered by Scalefree

 
A quick and easy-to-use solution to implement performant Data Vault solutions.

Get It Now

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

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.

 
Register Me Now

Supported Databases

Snowflake
Google Big Query
databricks
Amazon Redshift
Microsoft Fabric
Azure Synapse Analytics
PostgreSQL
Exasol
Oracle

Frequently Asked Questions

How can I start using DataVault4dbt?

Click on 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.

Check the full documentation

talk to an expert