Data Vault on Snowflake: Expanding to Dimensional Models

Snowflake continues to set the standard for Data in the Cloud by taking away the need to perform maintenance tasks on your data platform and giving you the freedom to choose your data model methodology for the cloud. You will expect the same relational capabilities for your data model as any other platform and Snowflake certainly delivers.

With the informed perspective we now have on the types of keys we use to join data vault tables; this article revisits the temporal surrogate sequence key we discussed when building a SNOPIT. Yes, with the temporal sequence key in place we can properly model a Kimball fact and dimension using data vault tables instead. This technique may in fact influence how you model your data vault — — and probably should! Without further ado let’s dig in!

Series

• Join Key Data Type
• Snapshot PIT tables
• Incremental PIT tables
• Information Marts
• Simulating Fact tables with Bridges
• Dynamic Information Marts

A reminder of the standard data vault table types,