Datavault-UK / automate-dv

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)
https://www.automate-dv.com
Apache License 2.0
478 stars 114 forks source link

[FEATURE] Alternative Standard Satellite Macro for adding virtual end_dates/is_current #220

Open philmaddocks opened 5 months ago

philmaddocks commented 5 months ago

Describe the solution you'd like Scalefree have the concept of a V0 and V1 satellite (V0 is insert only and materialised as table - V1 sat is built off V0 and adds effectivity related data virtually). This can be useful for the business for ad-hoc queries on specific sources of data

Describe alternatives you've considered Building own macro, or using Scalefrees V1 macro on top of sats created by the automateDV sat macro.

AB#5353