{"repo":"ScalefreeCOM/datavault4dbt","free":true,"listed":false,"github":"https://github.com/ScalefreeCOM/datavault4dbt","clone":"git clone https://github.com/ScalefreeCOM/datavault4dbt.git","description":"Scalefree's dbt package for a Data Vault 2 implementation congruent to the original Data Vault 2 definition by Dan Linstedt including the Staging Area, DV2 main entities, PITs and Snapshot Tables.","language":"PLSQL","stars":200,"topics":["datavault","hubs","links","pits","satellites","sourcemarts","stagingarea","bigquery","snowflake","scalefree"],"license":"Apache-2.0","category":"data-pipelines","readme_excerpt":"datavault4dbt by Scalefree International GmbH --- ⚠️ Fusion Compatibility ⚠️ ✅ datavault4dbt works flawlessly with dbt-fusion! For more details and considerations check our documentation! Included Macros - Staging Area (For Hashing, prejoins and ghost records) - Hubs, Links & Satellites (allowing multiple deltas) - Non-Historized Links and Satellites - Multi-Active Satellites - Effectivity and Record Tracking Satellites - Virtualized End-Dating (in Satellites) - Reference Hubs, - Satellites, and - Tables - PIT Tables - Hook for Cleaning up PITs - Snapshot Control Tables and Views Features With datavault4dbt you will get a lot of awesome features, including: - A Data Vault 2 implementation congruent to the original Data Vault 2 definition by Dan Linstedt - Ready for both Persistent Staging Areas and Transient Staging Areas, due to the allowance of multiple deltas in all macros, without losing any intermediate changes - Enforcing standards in naming conventions by implementing global variables for technical columns - A fully auditable solution for a Data Warehouse - Creating a centralized, snapshot-based Business interface by using a centralized snapshot table supporting logarithmic logic - A modern insert-only approach that avoids updating data - Optimizing incremental loads by implementing a high-water-mark that also works for entities that are loaded from multiple sources - A straight-forward, standardized approach to conduct agile datawarehouse development cycles Requiremen","default_branch":null,"files":null,"tree":[],"storefront":"/r/ScalefreeCOM","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ScalefreeCOM/datavault4dbt/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}