Data Vault Virtual Data Warehouse — Snowflake

The Virtual Data Vault Snowflake starter solution is a 3-tiered design with a staging layer, integration layer, and presentation layer, targeting Snowflake. The example adopts Data Vault methodology for the integration layer.

Both the integration layer and presentation layer are generated as database views.

To support the integration layer, the staging layer contains a persistent staging area (PSA) which captures and timestamps the detected data changes in its original (raw) form and thus provides the means to deliver different downstream data interpretations using the views.

As part of the sample, various classifications and conventions for Data Vault and Ensemble Logical Models (ELM) are prepared.