What’s so great about Snowflake? (non-technical) (2024)

Non-Technical Demystification of The Largest Software IPO of all Time

The hype train is certainly pulling into the station. You may have heard about Snowflake, the software company that Warren Buffett invested in and is now having its Initial Public Offering (IPO) So really, what exactly is so great about Snowflake (in non-technical terms)?

The meter turns off

Sitting in standstill traffic with the taxi meter running is a very special feeling. You are going nowhere and getting poorer all the while. Well Snowflake turns the meter off when data is not moving. Petabytes of data are out there, pretty much just sitting there unused. Sometimes for years. With older data stores, the meter is always running for capacity to call and crunch the data. Not with Snowflake. If the data is just sitting there, the processing capacity goes to sleep and the meter turns off. For big companies with lots of data this is huge. The Snowflake for “data just sitting there” is a very respectable $23 per terabyte per month. (That’s about enough to store over 600 full length movies).

If we compare that to something else, like Amazon AWSRedshift, we find that the meter does not shut off. So the cost per terabyte is about $306 per month. It’s not an apples-to-apples comparison but for data that “mostly just sits there,” $23 v. $306 is an eyeopener. And, frankly, even AWS Redshift is eye-openingly cheap compared to corporate “on prem” storage costs, which can get into the thousands of dollars per month.

So, if the meter is off a lot of the time, what does this mean to performance when I need it? Actually, the way Snowflake is set up, performance is cleverly optimized. Even as the data size increases Snowflake distributes performance automatically behind the scenes. This relieves a bunch of setup and engineering headaches.

Digital sweatpants to formal dress code

What are digital sweatpants? Come on over, exactly as you are. Snowflake grabbed an idea from Google Big Query that made it really popular. Just jam data into Snowflake as it is. Don’t worry about the structure. Old databases require a strict dress code to be saved in the database. It takes some work. Snowflake? The data can be saved exactly as it is. (There are substantial challenges with this) but if you are in a pinch and just want the data saved without a lot of headache…Snowflake is your most comfy pair of sweatpants.

But there is more. Want to dress up like an “old fashioned” (relational) database. Yep. Snowflake can do that too. So it tackles structured (strict dress code) and unstructured (no dress code). (We will have a follow up post about structured and unstructured ETL for Snowflake using K3.)

That friend that is friends with so many friends

Snowflake runs on all the big cloud providers. This is kind of a big deal. Some people are really loyal to AWS and others to Azure. Google…sure. Oracle Cloud? Ummmm….Snowflake is agnostic to all this so it can be used by everyone wherever they like. This is really important because as companies make the leap to cloud they tend to focus on just one over time.

And if SQL does not mean anything to you…don’t worry. SQL (pronounced seequil) is the historical baseline database language. There has been a wave of new databases that do not use SQL. It ruffled some feathers because people always struggle with new languages. Snowflake? Straight SQL and voila everyone is happy.

What’s it all mean?

Companies still need to keep plenty of important historical data. In Snowflake, it’s all on tap and ready to go, but without the meter running. Customers storing data are getting a really nice discount by using Snowflake.

But, think about this. Let’s say your business has a factory manufacturing cars. That factory churns out lots and lots of data. Right now it’s too much, too hard to store. Even if we did save it, we would not know what to do with it. Say, here’s an idea. Put it into Snowflake. You are giving your company’s future self a high five. We don’t know what we want the data for as of now, but in the future? Who knows. At $23/TB/Mo that’s a pretty cheap option. Maybe you don’t see it now, but in five years it could be your promotion.

What now?

Ready for your off-the-shelf adaptor to Snowflake? K3 is used by some of the world’s largest companies to pick up data from anywhere in your organization, intuitively transform it and get it to where you need it, including Snowflake! Everything in K3 is streaming and real-time. We’d love to show you how you can get the most out of Snowflake.

Always happy to show our stuff. Just send us a message.

What’s so great about Snowflake? (non-technical) (2024)
Top Articles
Why Decommissioning Your Old Servers Makes Sense
Support
Victory Road Radical Red
Main Moon Ilion Menu
Www.fresno.courts.ca.gov
4-Hour Private ATV Riding Experience in Adirondacks 2024 on Cool Destinations
Craigslist Cars Augusta Ga
Western Union Mexico Rate
Voordelige mode in topkwaliteit shoppen
Aiken County government, school officials promote penny tax in North Augusta
House Share: What we learned living with strangers
OnTrigger Enter, Exit ...
13 The Musical Common Sense Media
W303 Tarkov
Obituary | Shawn Alexander | Russell Funeral Home, Inc.
Taylor Swift Seating Chart Nashville
George The Animal Steele Gif
The Murdoch succession drama kicks off this week. Here's everything you need to know
Meritas Health Patient Portal
Nba Rotogrinders Starting Lineups
Samantha Lyne Wikipedia
NHS England » Winter and H2 priorities
Tinker Repo
UPS Store #5038, The
Catherine Christiane Cruz
Myhr North Memorial
Theater X Orange Heights Florida
The EyeDoctors Optometrists, 1835 NW Topeka Blvd, Topeka, KS 66608, US - MapQuest
Talkstreamlive
Stihl Dealer Albuquerque
Lovindabooty
Garden Grove Classlink
Bolly2Tolly Maari 2
Lbrands Login Aces
Roseann Marie Messina · 15800 Detroit Ave, Suite D, Lakewood, OH 44107-3748 · Lay Midwife
Ehome America Coupon Code
Shauna's Art Studio Laurel Mississippi
Rvtrader Com Florida
Hypixel Skyblock Dyes
Junior / medior handhaver openbare ruimte (BOA) - Gemeente Leiden
Midsouthshooters Supply
Main Street Station Coshocton Menu
Gvod 6014
Janaki Kalaganaledu Serial Today Episode Written Update
Joey Gentile Lpsg
M&T Bank
About Us
15 Best Places to Visit in the Northeast During Summer
The Jazz Scene: Queen Clarinet: Interview with Doreen Ketchens – International Clarinet Association
25100 N 104Th Way
Solving Quadratics All Methods Worksheet Answers
Craigslist Monterrey Ca
Latest Posts
Article information

Author: Arline Emard IV

Last Updated:

Views: 6458

Rating: 4.1 / 5 (52 voted)

Reviews: 83% of readers found this page helpful

Author information

Name: Arline Emard IV

Birthday: 1996-07-10

Address: 8912 Hintz Shore, West Louie, AZ 69363-0747

Phone: +13454700762376

Job: Administration Technician

Hobby: Paintball, Horseback riding, Cycling, Running, Macrame, Playing musical instruments, Soapmaking

Introduction: My name is Arline Emard IV, I am a cheerful, gorgeous, colorful, joyous, excited, super, inquisitive person who loves writing and wants to share my knowledge and understanding with you.