Implementing Data Vault 2.0 with AutomateDV for Change Logs

Hello everyone,

I’m exploring how Data Vault 2.0 can be used to standardize change logs from various data sources. I’ve currently set up hubs, satellites, extended tracking satellites (XTS), links, and point-in-time (PIT) tables using AutomateDV as part of a proof of concept (POC). This involves building history tables from these changes, using daily snapshot tables partitioned by day.

I’m particularly interested in leveraging dbt AutomateDV for this purpose. Has anyone here worked on something similar? Any insights or challenges you’ve faced with this setup would be greatly appreciated!


Are you looking to simply store change logs or build a DV based on change logs?