DataEngBytes 2023 - SYD-T1-05 - Patrick Cuba
summary
Claims that Snowflake native features let you implement Data Vault 2.0 patterns end to end: model with three table types (hub, link, satellite), load using staged views that add surrogate hash keys and hash digests, and process changes with streams as bookmarks into target tables. Loaders are three simple types (new keys, new relationships, changed data) and can run in parallel; SQL merge handles concurrency so hubs don’t need explicit locks. Patterns for multi‑active records, out‑of‑order arrivals and effectivity satellites are included and work within Snowflake’s execution model.
AI-written summary · about
chapters (7)
- 0:00Introduction to Data Vault
- 3:27Core building blocks
- 5:30Modeling business capability
- 6:47Query assistance and loading
- 8:32Snowflake implementation
- 11:20Passive integration
- 13:28Advanced patterns and closing
related talks
31mData Mesh & Data Vault
32mDataEngBytes 2023 - BRI-T1-10 Rishu Saxena & John Cosgrove
19mDataEngBytes 2023 - MEL-T1-04 - Michael Hyatt
13mLightning Talk: Highlights of the Snowflake Elastic Data Warehouse
24mA Single Data Platform for All of Your Workloads
28mBuilding A Governed Data Lake
42mData Modelling: Navigating the Data Seas with a Data Vault Compass
13mStreamline workloads with deep integration from Snowflake