2021-05-20T06:31:00Z
Ariful Mondal - PeerSpot reviewer
Consulting Practice Partner - Data, Analytics & AI at FH
  • 7
  • 159

What are the key reasons for choosing Snowflake as a data lake over other data lake solutions?

Hi, 

It seems that Snowflake is becoming very popular nowadays. I have done some training and live sessions by Snowflake. 

I would like to hear your opinion about the main key parameters we should look for when choosing Snowflake over other cloud-based data lakes, such as costs, ease of use, maintenance, etc? 

And what would be success criteria? 

6
PeerSpot user
6 Answers
Steve Sarsfield - PeerSpot reviewer
Marketing at a tech vendor with 1,001-5,000 employees
Vendor
Top 20
2021-05-25T15:27:13Z
May 25, 2021

I wrote a white paper on this that you can download here:https://bit.ly/3bRTCqp


It comes down to five factors, in my opinion: 


1. Options for Deployment - Can you deploy on any cloud, or on-premises?
2. External tables and analyze in-place features - Can you leverage data outside the DB?
3. Optimizations - What are the options for slow-running queries?
4. Depth of analytics - can you do ML, time-series, geospatial, SQL, Python, etc.
5. Other data governance features - encryption and other governance features


Of course, speed and scalability is a huge factor, but most people are on top of that.


The white paper was commissioned by Vertica, a player you didn't mention above, but I attempted to keep it vendor-neutral. 

FL
Workplace Operations Manager at Samsara
Vendor
Aug 5, 2021

@Steve Sarsfield Same for Teradata, plus In-Database processing in R & Python, SAS, Tableau and many others.

PeerSpot user
Product comparison that may be of interest to you
MS
Account Executive at a insurance company with 10,001+ employees
User
2021-06-02T20:16:49Z
Jun 2, 2021

We did a PoC with Snowflake.  scale up and down works as advertised.  Be careful with large ETL streams.  We would have to rewrite at least 20% of our ETL to make Snowflake meet or beat our current SLA's.

Jay Allen - PeerSpot reviewer
Information Systems and Database Architect at Relational Models LLC
User
2021-08-06T10:08:50Z
Aug 6, 2021

Snowflake is a columnar stored database. It is not a “data lake.”

CD
Data Architect at a tech services company with 201-500 employees
Real User
Top 10
2022-02-02T14:35:59Z
Feb 2, 2022

The main success criteria would be "re-use" of data by SQL-driven users. 


I can't speak for ALL cloud providers but on AWS the storage cost is comparable to S3. The advantage is once the data is housed in the Snowflake environment it can be re-used/re-purposed without the need of another SQL engine that has to be managed (Dremio, PrestoDB, etc.).

NitinKumar - PeerSpot reviewer
Director of Enginnering at Sigmoid
Real User
Top 5Leaderboard
2021-09-03T04:28:22Z
Sep 3, 2021

handling of semi-structured data like json. It has great support for json and we can write sql on json which is amazing. the performance on semi-structured data is little poor as compared to structured data but it is still great.


Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
Community Manager
2021-05-24T03:52:36Z
May 24, 2021

Hello @Anoop Anoop SLK ​, @NitinKumar , @Subhrajit Mitra ​and @Yash Mittal. Can you please share your experience?

Find out what your peers are saying about Snowflake vs. Snowflake Analytics and other solutions. Updated: November 2022.
655,994 professionals have used our research since 2012.
Related Questions
it_user434868 - PeerSpot reviewer
Senior Director of Delivery at a tech services company with 51-200 employees
Sep 30, 2022
If you were talking to someone whose organization is considering Snowflake Analytics, what would you say? How would you rate it and why? Any other tips or advice?
2 out of 5 answers
Jyothirmai Gopereddy - PeerSpot reviewer
Azure Manager at Tredence Inc.
May 29, 2022
Snowflake Analytics is more managed than other cloud offerings, which means I don't have to deal with anything happening in the backend. For those thinking of implementing Snowflake, I advise analyzing the cost, your volume of data, and the number of users. If you have a huge demand on these things, I would recommend choosing Snowflake. I rate Snowflake as seven out of ten.
AnujJain - PeerSpot reviewer
AVP Data Engineering at Genpact - Headstrong
May 31, 2022
We are partners with Snowflake. In the last four or five years, Snowflake has actually blown up. Before that, it was quite low in terms of visibility and potential. We have now done multiple engagements on Snowflake. Right now the snowflake is adding the multiple clients we using all editions. We're using a variety of clouds, including AWS and Azure. I'd rate the solution nine out of ten. While we've done many complex implementations, Snowflake always has a way of simplifying things.
it_user434868 - PeerSpot reviewer
Senior Director of Delivery at a tech services company with 51-200 employees
Sep 30, 2022
Hi Everyone, What do you like most about Snowflake Analytics? Thanks for sharing your thoughts with the community!
2 out of 5 answers
Jyothirmai Gopereddy - PeerSpot reviewer
Azure Manager at Tredence Inc.
May 29, 2022
Snowflake Analytics' most valuable feature is its inbuilt infrastructure for executing queries, which I don't have to manage based on my data volume as it's taken care of by Snowflake.
AnujJain - PeerSpot reviewer
AVP Data Engineering at Genpact - Headstrong
May 31, 2022
The performance has been good.
Related Articles
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Apr 26, 2022
PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to better connect with peers and other independent experts who provide advice without vendor bias. Our users have ranked these solutions according to their valuable features, and discuss which features they like most and why. You can read user reviews for the Top 5 Data Warehouse Tools to help you d...
Product Comparisons
Related Articles
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Apr 26, 2022
Top 5 Data Warehouse Tools 2022
PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to...
Download Free Report
Download our FREE report comparing Snowflake and Snowflake Analytics based on reviews, features, and more! Updated: November 2022.
DOWNLOAD NOW
655,994 professionals have used our research since 2012.