Skip to content

A free to use dbt package for creating and loading Data Vault 2.0 compliant Data Warehouses (powered by dbt, an open source data engineering tool, registered trademark of dbt Labs)

License

Notifications You must be signed in to change notification settings

cd-philipp/automate-dv

This branch is 2 commits ahead of, 20 commits behind Datavault-UK/automate-dv:master.

Folders and files

NameName
Last commit message
Last commit date
May 15, 2024
Aug 15, 2024
May 14, 2023
Oct 3, 2019
May 14, 2023
Jun 14, 2023
Apr 30, 2024
Jun 7, 2024
Jun 6, 2024
Jan 27, 2023

Repository files navigation

AutomateDV AutomateDV

Documentation Status Slack

dbt Versions

Changelog and past doc versions

AutomateDV by Datavault

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

What does AutomateDV 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 dbt Labs

Worked example project

Learn quickly with our worked example:

Supported platforms:

Platform support matrix

Installation

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

Usage

  1. Create a model for your table.
  2. Provide metadata
  3. Call the appropriate template macro
# Configure model
{{- config(...)                          -}}

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

# Call the macro
{{ automate_dv.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 AutomateDV or Data Vault 2.0

Join our Slack

Social

Twitter Follow

LinkedIn

Youtube

Awards

innovation awards

Contributing

View our contribution guidelines

License

Apache 2.0

About

A free to use dbt package for creating and loading Data Vault 2.0 compliant Data Warehouses (powered by dbt, an open source data engineering tool, registered trademark of dbt Labs)

Resources

License

Stars

Watchers

Forks

Packages

No packages published