The Data Warrior

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

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

Data Warrior #HappyDance! Guess who joined @Snowflakedb

Monday, April 16th, 2018 is going to be a BIG day.

As part of my personal campaign to #UniteTheDataNation, I am beyond happy to announce that two of my good friends from the Oracle community are joining my team at Snowflake Computing.

sno-cloud-analytics-tour-2018-email-signature

Drumroll please!

It is my honor and pleasure to announce that Laura K Ramsey and Danny Bryant have joined my team!

Laura will serve as the Director of Technical Education, Training, and Content.

Danny is joining as a Senior Solution Architect (and sometime Technical Trainer).

Please join me in congratulating them on launching their careers further into the #cloud.

Be sure to follow Danny on twitter and at his blog DBA on Tap. And check out all of Laura’s tweets too!

And keep your eyes on my handle, and theirs, to see what happens at Snowflake HQ this week.

Let it snow!

snowflakedifferencescreenshot

Kent

The Data Warrior

Wow! Snowflake lands massive $263 million investment

Have I said recently I LOVE  my job?

Well I do, and I love working with the awesome technology that is the Snowflake DWaaS as well as all the really smart and cool people that make up this innovative and ever growing company.

As you may have heard, we had a HUGE week with the announcement of our Series E round of funding ($263 million) and a valuation of $1.5 billion.

Makes my head explode to think I am part of this amazing tech story.

http://snowflake.net

Well, for those who somehow missed it, here are a bunch of links to all the stories out there with details about the event and the company.

Geekwire: Another Huge Round for Snowflake: Bob Muglia’s database company raises $263M valued at $1.5B

TechCrunch: Snowflake lands massive $263M investment on unicorn valuation

The Register: Muglia’s monster Snowflake in quarter-of-a-billion funding blizzard

ZDNet: Snowflake Raises $263.5 million for cloud data warehouse conquest

Computerworld (IDG): Snowflake, now a unicorn, eyes global growth for cloud data warehouse

Check out this interview with our CEO Bob Muglia:

 

And for those that speak French there is something for you too:

Want to learn more?

Register for one of our upcoming World Tour events in a city near you. Register here.

Later.

Kent

Chief Technical Evangelist, Snowflake

The Data Warrior

 

Post Navigation

%d bloggers like this: