The Data Warrior

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

Archive for the tag “#SnowflakeDB”

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
18 Jan 2016

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

Posted in Big Data, Data Modeling, Data Warehouse, Quotes, SnowflakeDB and tagged , , , , , , , , , , | Leave a comment
14 Jan 2016

Better Data Modeling: Customizing Oracle Sql Developer Data Modeler (#SQLDevModeler) to Support Custom Data Types

On a recent customer call (for Snowflake), the data architects were asking if Snowflake provided a data model diagramming tool to design and generate data warehouse tables or to view a data model of an existing Snowflake data warehouse. Or if we knew of any that would work with Snowflake.

Well, we do not provide one of our own – our service is the Snowflake Elastic Data Warehouse (#ElasticDW).

The good news is that there are data modeling tools in the broader ecosystem that you can of course use (since we are ANSI SQL compliant).

…

If you have read my previous posts on using JSON within the Snowflake, you also know that we have a new data type called VARIANT for storing semi structured data like JSON, AVRO, and XML.

In this post I will bring it together and show you the steps to customize SDDM to allow you to model and generate table DDL that contain columns that use the VARIANT data type.

Read the details of how I did it here on my Snowflake blog:

Snowflake SQL: Customizing Oracle Sql Developer Data Modeler (SDDM) to Support Snowflake VARIANT – Snowflake

Enjoy!

Kent

The Data Warrior

P.S. If you are in Austin, Texas this weekend, I will be speaking at Data Day Texas (#DDTX16). Snowflake will have a booth there too, so come on by and say howdy!

Posted in Data Modeling, Data Warehouse, SnowflakeDB, SQL Developer Data Modeler and tagged , , , , , , , , , , | Leave a comment
08 Jan 2016
15 Comments

Snowflake SQL: Making Schema-on-Read a Reality (Part 2)

This is the 2nd of my articles on the Snowflake blog.

In the first article of this series, I discussed the Snowflake data type VARIANT, showed a simple example of how to load a VARIANT column in a table with a JSON document, and then how easy it is to query data directly from that data type. In this post I will show you how to access an array of data within the JSON document and how we handle nested arrays. Then finally I will give you an example of doing an aggregation using data in the JSON structure and how simple it is to filter your query results by referring to values within an array.

Check out the rest of the post here:

Snowflake SQL: Making Schema-on-Read a Reality (Part 2) – Snowflake

Enjoy!

Kent

The Data Warrior

Posted in Data Modeling, Data Warehouse, SnowflakeDB and tagged , , , , , , , ,

Post Navigation

← Older Entries
Newer Entries →