Hybrid Data Vault 2.0 Case Study: Data Warehousing in the Real World

Kent Graziano, Snowflake Computing

At a former health-care client, we were not able to implement a pure Data Vault 2.0 architecture. Instead, we had to evolve a hybrid solution that uses Type 2 persistent stage tables that we tie together using standard Hub and Link structures along with a Key Map table. While we have been able to utilize DV 2.0 concepts such as MD5 hash keys, in order to avoid joins in loading the stage tables we had to come up with a way to resolve the Business Keys further into the process. This talk will discuss why we were not allowed to use a pure DV 2.0 approach, and then show you our solution and discuss the pros and cons of our approach.


Kent Graziano is a Senior Technical Evangelist with Snowflake Computing and the author of The Data Warrior blog (http://kentgraziano.com). He is a Data Vault Master and certified Data Vault 2.0 Practitioner (CDVP2), Oracle ACE Director, member of the OakTable Network, former member of the Boulder BI Brain Trust (#BBBT), expert data modeler and architect with over 30 years of experience, including over two decades doing data warehousing and business intelligence, in multiple industries, with multiple architectures. Kent is an internationally recognized expert in Data Modeling and Agile Data Warehousing. He has developed and led many successful software and data warehouse implementation teams, including multiple agile DW/BI teams. He has written numerous articles, authored three Kindle books (including A Check List for Doing Data Model Design Reviews and An Introduction to Agile Data Engineering), co-authored four other books on Data Modeling and Data Vault, and has given hundreds of presentations, nationally and internationally. In 2014, he was voted one of the best presenters at OUGF14 in Helsinki, Finland.

Comments are closed.