The Data Warrior

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

Archive for the category “Data Warehouse”

Schema-on-what? How to model JSON

It seems hard to believe, but all year, around the world, I continue to have this conversation on whether or not we still need data modeling.

I know! Crazy!

Thought we were past that…

As I have said before,

Schema-on-read has the word SCHEMA in it!

So instead of continuing to rant about it, I decided to put together a talk to show people, graphically, what I meant by decomposing, step by step, a few JSON documents into real data models. For the sake of the talk I decided to go with 3NF and Data Vault styles to make my point.

This talk has been very well received so I decided I would share it a bit more publicly by posting it here on my blog.

 

Now that you can see how to model JSON, check out my Snowflake ebook on how to easily analyze JSON using SQL.

If you know any meet-ups or conferences that I should be giving this talk at, please let me know. Or check out my speaking schedule for 2019 and join me at one of the events already on my calendar. (1st up is ITOUG in Milano!)

Ciao!

Kent

The Data Warrior & Chief Evangelist at Snowflake

P.S. There was no magic, or built-in wizard, to creating the models. I did it all by hand using Oracle Sql Developer Data Modeler.

 

Advertisements

Automatic Clustering, Materialized Views and Automatic Maintenance in Snowflake 

Boy are things going bananas at Snowflake these days. The really big news a few weeks back was another round of funding! This time we got another $450 million.

A-MAZ-ING!

We are gaining marketshare everyday with name brands signing up in droves. I am constantly taken aback by the names I see on our win-wire. In my role as evangelist, I am getting to speak with folks at places like Sony, NBC Universal, and CapitalOne to name a few. Not only here in the US but over in EMEA as well (as my frequent flyer status will attest). And early next year I will be heading out to Australia and New Zealand too (stay tuned for details).

As exciting as all that is (#ILoveMyJob), even more exciting is how our engineering team is putting all that funding $$ to use to continue to improve what is already the leading cloud-built data warehouse. This week we announced two new major features.

From today, two new automation and performance capabilities are available in Snowflake. They are the latest advancements to Snowflake’s ability to deliver the best performance and scalability without requiring administration or maintenance from our customers. They also lay the foundation for a series of new features to come in the months ahead.

Read all the details here: Automatic Clustering, Materialized Views & Automatic Maintenance in Snowflake

After reading up on these features, head on over to our site and sign up fro your FREE trial account to see for yourself how awesome, and easy, moving to the cloud can be.

Make it snow!

Kent

Chief Technical Evangelist, Snowflake

The Data Warrior

Get Started Faster with Snowflake Partner Connect

Got data you want to load and analyze in the cloud? Would you like to do it today? The check out this announcement about getting up and running with your data in Snowflake faster. #YourDataNoLimits

Ending the struggle for data starts with getting to your data faster. Snowflake already streamlines the path to get up and running with a simple sign-up process via our website. With the introduction of Partner Connect, getting started with loading your data just got easier.Featuring data integration partners Fivetran, Alooma and Stitch, Partner Connect accelerates the onboarding process for new customers by eliminating the time-consuming steps of signing up for a new partner application and manually configuring the connection to Snowflake. We want to remove all barriers to getting started so you can unlock the full value of Snowflake immediately. Partner Connect makes this possible.

Read the rest here: Get Started Faster with Snowflake Partner Connect | Snowflake Blog

Happy loading!

Kent

The Data Warrior

Okta SSO with Snowflake 

Ever wonder how to secure a cloud data warehouse? Well, Vlad from EA (Entertainment Arts) has produced an entire blog just about using Snowflake. This is the 1st in a series he wrote with detailed instructions on how to set up SSO on Snowflake for various tools, including Tableau. Check it out:

Once you made a decision (smart one!) to place you data warehousing and analytics activity onto Snowflake platform the next question would be how to make your data secure. Snowflake is really good …

Read the rest here: Okta SSO with Snowflake – Data Warehousing and Business Intelligence

Thanks Vlad!

Enjoy all!

Kent

The Data Warrior

Chief Technical Evangelist, Snowflake Computing

Join the Cloud Analytics Academy

Maybe not a cool as Star Fleet Academy, but this is pretty cool.

Snowflake and a number of our partners have come together to create the first, self-paced, vendor agnostic, online training academy for analytics in the cloud. This academy will get you up to speed on what is happening today in the cloud with respect to data warehousing and analytics so that you can be a leader in your organization.

20171111_072127

Reach for the summit above the clouds!

And the best part – it is FREE!

The Cloud Analytics Academy is a training and certification program for data professionals who want to advance their skills for the technology and business demands of today’s data analytics. It’s a collective industry effort from executives at Snowflake Computing, AWS, Looker, Talend and WhereScape.

We decided to launch this academy in part to address the data and analytics skills gap, which Gartner says is “threatening to overwhelm the credibility of data use” in business. At the same time, Gartner also recently projected that the worldwide software-as-a-service (SaaS) market to grow more than 63 percent to by 2020.

The Academy is designed for data professionals of all technical and business levels and backgrounds. You can complete any or all of the following Academy tracks:

  • Executive Fast Track Learn the key technologies and techniques to foster an effective cloud analytics team.
  • Cloud Foundation Track Become proficient with the fundamental building blocks of cloud analytics.
  • Modern Data Analytics Track Learn advanced technical concepts to propel your cloud analytics.

There will be quiz questions at the end of each session to test your retention. By completing the sessions and the quizzes in a track you will get a related academy badge. Anyone who completes all three tracks will be certified as a Cloud Analytics Academy Master.

The Academy launches on November 14th with a live keynote from Tom Davenport. You can get all the details and sign up here. (Don’t worry if you miss it as it will be recorded and available the rest of the year).

So what are you waiting for? Sign up today and take your career to the next level – above the clouds!

To infinity and beyond!

Kent

The Data Warrior

 

 

Post Navigation

%d bloggers like this: