The Data Warrior

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

Archive for the tag “#SnowflakeDB”

01 Jun 2016
1 Comment

Snowflake DB Cool Features – Automatic Query Optimization

This is the final installment of my ongoing series on the Top 10 Cool Features in the Snowflake Elastic Data Warehouse:

#1 Automatic Query Optimization. No Tuning!

As a long time data architect, and not a DBA, this is my favorite part of Snowflake. I do not have to worry about query performance at all. It is all handled “auto-magically” via a dynamic optimization engine in our cloud services layer. I just model, load, and query the data.

See the rest of the post here: Automatic Query Optimization. No Tuning!

Model On!

Kent

The Data Warrior

P.S. If you have questions about any specific features in Snowflake, please let me know in the comments or send me an email at kent.graziano@snowflake.net.

P.P.S. I am considering making a few short videos about Snowflake – what features should I start with?

Posted in Big Data, Data Warehouse, SnowflakeDB and tagged , , , , , ,
09 May 2016

Support for Multiple Workloads in Snowflake DB

Excerpt from my most recent post on the Snowflake blog:

With our unique Multi-cluster, shared data architecture, Snowflake can easily support multiple and disparate workloads.  This is a common issue in traditional data warehouses so it makes total sense to be able to keep disparate workloads separate, to truly avoid resource contention, rather than just saying we support “mixed” workloads.

Read the rest here: Support for Multiple Workloads

 

Love your data!

Kent

The Data Warrior

p.s. Don’t forget to join me a #WWDVC May 25-28 in Stowe, Vermont. I will be giving away a GoPro! after my talk on Thursday.

Posted in Big Data, Data Warehouse, SnowflakeDB and tagged , , , , , | Leave a comment
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 , , , , , , ,

Post Navigation

← Older Entries
Newer Entries →