The Data Warrior

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

Archive for the tag “Snowflake Cloud Data Warehouse”

18 Mar 2020

Tips for Optimizing the #DataVault Architecture on #Snowflake (Part 2)

SETTING UP FOR MAXIMAL PARALLEL LOADING!

In this post, I discuss how to engineer your Data Vault load in Snowflake Cloud Data Platform for maximum speed.

Because Snowflake separates compute from storage and allows the definition of multiple independent compute clusters, it provides some truly unique opportunities to configure virtual warehouses to support optimal throughput of DV loads.

Along with using larger “T-shirt size” warehouses to increase throughput, using multi-cluster warehouses during data loading increases concurrency for even faster loads at scale.

Get the details –  Tips for Optimizing the Data Vault Architecture on Snowflake (Part 2)

Enjoy!

Kent

The Data Warrior & Chief Technical Evangelist for Snowflake

Posted in Data Modeling, Data Vault, Data Warehouse, SnowflakeDB and tagged , , , , , , , , , ,
16 Mar 2020

Data Engineering Podcast – What is Snowflake?

A few months back I had the privilege of being interviewed by Tobias Macey on his Data Engineering Podcast show. This came about because Tobias actually Tweeted at me about wanting to do the interview! In this episode we spent an hour discussing the ins and outs of the Snowflake Cloud Data Platform. You can find it here. Hope you enjoy it!

Interview Outline

  • How did you get involved in the area of data management?
  • Can you start by explaining what Snowflake is for anyone who isn’t familiar with it?
    • How does it compare to the other available platforms for data warehousing?
    • How does it differ from traditional data warehouses?
      • How does the performance and flexibility affect the data modeling requirements?
  • Snowflake is one of the data stores that is enabling the shift from an ETL to an ELT workflow. What are the features that allow for that approach and what are some of the challenges that it introduces?
  • Can you describe how the platform is architected and some of the ways that it has evolved as it has grown in popularity?
    • What are some of the current limitations that you are struggling with?
  • For someone getting started with Snowflake what is involved with loading data into the platform?
    • What is their workflow for allocating and scaling compute capacity and running analyses?
  • One of the interesting features enabled by your architecture is data sharing. What are some of the most interesting or unexpected uses of that capability that you have seen?
  • What are some other features or use cases for Snowflake that are not as well known or publicized which you think users should know about?
  • When is Snowflake the wrong choice?
  • What are some of the plans for the future of Snowflake?

This is a great podcast series, so you might want to add it to your regular list!

Cheers.

Kent

The Data Warrior & Chief Technical Evangelist at Snowflake

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

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

Posted in Big Data, Data Warehouse, SnowflakeDB and tagged , , , , ,
15 Apr 2018

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

Posted in Big Data, SnowflakeDB, Training and tagged , , , , , | Leave a comment
27 Jan 2018

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

 

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

Post Navigation

← Older Entries
%d bloggers like this: