Fox Chase has embarked on a journey to re-engineer our Data Warehouse internals with the Data Vault 2.0 Methodology. DV 2.0 strongly emphasizes metadata driven automation and we are attempting to follow the methodology in its entirety. The technologies employed by our solution include Python, Jinja templates, Airflow, and Oracle. The Jinja templates defining the nature of the output can be re-expressed to support other target database technologies.
We will examine all aspects of the solution with the goal of defining a roadmap for others to implement DV 2.0 with this open source toolset. Additional discussion points include Data Vault design decisions in the Healthcare vertical, the motivation for Fox Chase deciding to take these steps, and an engineer’s perspective on tackling the learning curve of these technologies.