Home
The following documentation sheds some light on the dbt-macros that have been developed by Scalefree to make your DataVault-Experience more comfortable! The documentation can be found by clicking the links in the sidebar on the right side. In the documentation the macros and its parameters are explained and further exemplified.
- Staging Area (For Hashing, prejoins and ghost records)
- Hubs, Links & Satellites (allowing multiple deltas)
- Virtualized End-Dating (in Satellites)
- PIT Tables
- Source Marts
- Data Vault 2.0 related tests????
To use the macros efficiently, there are a few prerequisites you need to provide:
- Flat & Wide source data, available within your target database
- Load Date column that represents the arriving time in the source data storage
- Record Source column that gives information about where the source data is coming from (e.g. the file location inside a Data Lake)
With the Scalefree version of dbtvault you will get a lot of awesome features, including:
- A Data Vault 2.0 implementation congruent to the original Data Vault 2.0 definition by Dan Linstedt and Michael Olschimke
- A fully auditable solution for a Data Warehouse
- A modern insert-only approach that avoids updating data
- A straight-forward, standardized approach to conduct agile datawarehouse development cycles
- Learn more about dbt in the docs
- Check out Discourse for commonly asked questions and answers
- Join the chat on Slack for live discussions and support
- Find dbt events near you
- Check out the blog for the latest news on dbt's development and best practices
https://www.scalefree.com/scalefree-newsletter/data-vault-2-0-with-dbt-part-1/
https://www.scalefree.com/scalefree-newsletter/data-vault-2-0-with-dbt-part-2/