The Data Warrior

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

Archive for the tag “Elastic Data Warehouse”

Using the Snowflake Information Schema

It is my 1 year anniversary of becoming the tech evangelist for Snowflake Computing!anniversary

Hard to believe that a year ago I gave up independent consulting and joined this amazing team in San Mateo. While there has been a lot of travel recently with my speaking schedule, I have gotten to learn a ton about big data, the cloud, and modern issues in the world of BI and analytics. Things I would have missed out on had I keep doing what I had been doing.

And the more I speak at events, talk to prospects, customers, analysts, and data architects, like me, the more convinced I am that Snowflake has NAILED it! What we have built here is truely unique in the industry and is led by a truely genius team of database engineers. You should come work here too! Tell them the Data Warrior sent you!

So, happy anniversary to me and here is yet another post I did about one of our great features.

Snowflake Information Schema

Snowflake has a data dictionary that we expose to users. We call it the Information Schema. This post will give you some examples of how to use it. Enjoy!

Read the post here: Using the Snowflake Information Schema

Cheers everyone!

Kent

The Data Warrior

P.S. In case you missed it, you can now sign up online for a FREE trial of Snowflake – the data warehouse built for the cloud!

Introduction to Snowflake!

Heads up! I will be giving a webinar next week, called Enabling Cloud-Native Elastic Data Warehousing to introduce folks to the Snowflake Elastic Data Warehouse. Sign up here and join me on July 12th!

Special thanks to DAMA International for inviting me to do this!

See you there!

Kent

The Data Warrior

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!”

Do Not Follow…Leave a Trail!

Do not follow where the path may lead…

Go instead where the is no path and leave a trail

— Ralph Waldo Emerson

Good advice in general.

I am very happy to be working for Snowflake Computing (@snowflakedb) and our CEO Bob Muglia (@bob_muglia) where we are forging the path for Elastic Data Warehousing (#ElasticDW)

We (Snowflakes) had a great time at Data Day Texas (#DDTX16) in Austin over the weekend. I think it is fair to say people are excited to see the trail we are blazing.

Have a great week!

Kent

The Data Warrior and Snowflake Evangelist

P.S. You can find the slides from my Data Day presentation on my LinkedIn profile or at slideshare.net/kgraziano

Post Navigation

%d bloggers like this: