Changelog and past doc 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.6.2 # 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_model'))                    }}

Join our Slack Channel

Talk to our developers and other members of our growing community, get support and discuss anything related to dbtvault or Data Vault 2.0

Sign up for early-bird announcements

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

Starting a Data Vault project

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!

Contributing

View our contribution guidelines

License

Apache 2.0