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!”
Like this:
Like Loading...
Posted in
Data Modeling,
Data Vault,
Data Warehouse,
SnowflakeDB and tagged
#datavault,
#ElasticDW,
#SnowflakeDB,
@SnowflakeDB,
Data Vault modeling,
data warehouse architecture,
data warehouse design,
Elastic Data Warehouse,
from the author of Super Charge Your Data Warehouse
The Data Warrior 