search

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] Multi Active Sats and PIT #194

Open RonniePitts opened 1 year ago

RonniePitts commented 1 year ago

The current PIT macro supports SATs, is there a plan to support Multi Active SAT's and PIT's?

AB#5361

DVAlexHiggs commented 10 months ago

Hello! Thanks for the request and apologies for the late response on this.

PITs and Bridges in AutomateDV are currently due a rework due to their usability issues (too many parameters and unnecessary parameters) and non-standard implementation.

This may include logic to work with MAS as well.

mjahammel commented 2 months ago

Hey @DVAlexHiggs:

I was just working with the PIT macro over the last day or so and would like to suggest, if it hasn't already been considered, that the parameter names for the driving date be changed to something other than LDTS. If the driving date for the PIT is an 'applied date' rather than the actual Data Vault LDTS column, it can be somewhat confusing.