The Data Warrior

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

10 Mar 2016

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

Posted in Data Modeling, Data Vault, Data Warehouse, SnowflakeDB and tagged , , , , , , , ,
06 Mar 2016

Connect to Snowflake with JDBC

As promised in my earlier post, here is a deeper dive into the next of the Top 10 Cool Features from Snowflake:

#9 Ability to connect with JDBC

This seems like a no brainer but is very important. If you’re interested in connecting any custom or packaged Java based applications to Snowflake, JDBC is what you need. JDBC technology lets you access information in SQL databases using standard SQL queries.

So why is this cool? Because all of the modern applications written in Java can take advantage of our elastic cloud based data warehouse through a JDBC connection.

And we have plenty of customers doing that today with industry leading tools.

You can read the rest of the post here:

Connect to Snowflake with JDBC

Enjoy!

Kent

The Data Warrior

P.S. Don’t forget to join me in Nashville this week for their TDWI Meetup

Posted in Data Warehouse, SnowflakeDB and tagged , , | Leave a comment
29 Feb 2016
2 Comments

Viva Las Vegas!

Later this morning I am flying out to Las Vegas to attend my first HIMSS conference. This is the biggest IT Healthcare related event on the planet.

I will be hanging out at the Snowflake booth (#14078) in the Clinical & Business Intelligence Knowledge Center, ready to talk about elastic data warehousing and how it can help with BI and analytics in healthcare.

Here are the hours:

  • Monday, February 29 6:30 pm – 8:00 pm (Opening Reception)
  • Tuesday, March 1 9:30 am – 6:00 pm
  • Wednesday, March 2 9:30 am – 6:00 pm
  • Thursday, March 3 9:30 am – 4:00 pm

So, if you are attending HIMSS this year, please stop by and say hi.

Kent

The Data Warrior

P.S. I will be tweeting as always and may even attempt to Periscope live from HIMSS. Watch for #ElasticDW #HIMSS16

Posted in Data Warehouse, SnowflakeDB and tagged , , , , , , ,
22 Feb 2016

Snowflake Cool Features: Query History 

As promised in the previous post I wrote for Snowflake, here is a deeper dive into one of the Top 10 Cool Features from Snowflake:

#10 Result sets available via History

There are a lot of times when you want to make a small change to your large query, and want to be able to see the effect of a change quickly without rerunning the previous query. This is hard in most systems because you have to rerun the previous query, using up resources and time. Our solution allows users to view the result sets from queries that were executed previously, via history. One benefit users get is that if they had already executed a complex query that took some amount of time to execute, the user doesn’t have to run the query again to access the previous results. They can just go back to the history, and access the result set. This is also beneficial when working on a development project using the data warehouse. Developers can use the result set history to compare the effects of changes to the query or to the data set, without running the previous queries again.

Read the rest of the post here:

Snowflake Query Result Sets Available to Users via History – Snowflake

Enjoy!

Kent

The Data Warrior

Posted in Data Warehouse, SnowflakeDB and tagged , , | Leave a comment
12 Feb 2016

Top 10 Cool Things I Like About Snowflake Elastic Data Warehouse

I have now been with Snowflake Computing for a little over two months (my how time flies). In that time, I have run the demo, spoken at several trade shows, and written a few blogs posts. I have learned a ton about the product and what it means to be an Elastic Data Warehouse in the Cloud.

So for this post I am going to do a quick rundown of some of the coolest features I have learned about so far.

See the rest of the post here on the Snowflake blog: Top 10 Cool Things I Like About Snowflake – Snowflake

Happy Friday!

Kent

The Data Warrior

Posted in Data Warehouse, SnowflakeDB and tagged , , , , | Leave a comment

Post Navigation

← Older Entries
Newer Entries →