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

Worked example project

Learn quickly with our worked example:

Currently supported databases:

snowflake

Installation

Check dbt Hub for the latest installation instructions, or read the docs for more information on installing packages.

Usage

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

# Configure model
{{- config(...)                          -}}

# Set metadata
{%- set src_pk = ...                     -%}
...

# Call the macro
{{ dbtvault.hub(src_pk, src_nk, src_ldts,
                src_source, 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

Contributing

View our contribution guidelines

License

Apache 2.0

fernandobrito/dbtvault