News

• We now have a slack channel, use the button below to join
• Looking to use dbtvault or Data Vault in your project? We've written a document to give you a head start. Download for FREE now!

past docs versions

dbtvault by Datavault

Build your own Data Vault data warehouse! dbtvault is a free to use dbt package that generates & executes the ETL you need to run a Data Vault 2.0 Data Warehouse on a Snowflake database.

What does dbtvault offer?

• productivity gains, fewer errors
• multi-threaded execution of the generated SQL
• your data modeller can generate most of the ETL code directly from their mapping metadata
• your ETL developers can focus on the 5% of the SQL code that is different
• dbt generates documentation and data flow diagrams

powered by dbt, a registered trademark of Fishtown Analytics

Worked example project

Learn quickly with our worked example:

• Read the docs

• Project Repository

Currently supported databases:

• snowflake

Installation

Add the following to your packages.yml

packages:

  - git: "https://github.com/Datavault-UK/dbtvault"
    revision: v0.5 # Latest stable version

And run dbt deps

Read more on package installation

Usage

1. Create a model for your table.
2. Provide metadata
3. Call the appropriate template macro

{{- config(...)                                                           -}}

{{ dbtvault.hub(var('src_pk'), var('src_nk'), var('src_ldts'),
                var('src_source'), var('source'))                          }}

Sign up for early-bird announcements

Get notified of new features and new releases before anyone else!

Contributing

View our contribution guidelines

License

Apache 2.0