The Data Warrior

Changing the world, one data model at a time. How can I help you?

Data Vault Modeling and Snowflake Elastic Data Warehouse

Since I have joined Snowflake, I have been asked multiple times what data warehouse modeling approach does Snowflake support best. Well, the cool thing is that we support multiple data modeling approaches equally.

Turns out we have a few customers who have existing data warehouses built using a particular approach known as the Data Vault modeling approach (which my readers no well by now) and they have decided to move into Snowflake (yeah!).

So the conversation often goes like this:

Customer: “Can you do Data Vault on Snowflake?”

Me: “Yes you can! Why do you ask?”

Customer: “Well, your name is “snowflake” so we thought that might mean you only support snowflake-type schemas.”

Me: “Well, yes I can see your confusion in that case, but the name has nothing to do with data warehouse design really. In fact, we support any type of relational design, including Data Vault.”

See the rest of the post here:

Data Vault Modeling and Snowflake

Keep on Modeling!

Kent

The Data Warrior

P.S. Next week I will be in Grapevine, Texas at the Gartner BI & Analytics Summit. Snowflake has a booth there. Come by and say “howdy!”

Advertisements

Single Post Navigation

Comments are closed.

%d bloggers like this: