README.md

There will be a live demonstration of dbtvault at the next UK Data Vault User Group on Tuesday, December 3, 2019 @ 6pm in LONDON.

Sign up 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

Ensure you are using dbt 0.14 (0.15 support will be added soon!) Add the following to your packages.yml

packages:

  - git: "https://github.com/Datavault-UK/dbtvault"
    revision: v0.4 # 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(...)                                                           -}}

{%- set metadata = ...                                                    -%}

{%- set source = ...                                                      -%}

{{ dbtvault.hub_template(src_pk, src_nk, src_ldts, src_source,
                         tgt_pk, tgt_nk, tgt_ldts, tgt_source,
                         source)                                           }}

Sign up for early-bird announcements

SIGN UP and get notified of new features and new releases before anyone else!

Contributing

View our contribution guidelines

License

Apache 2.0