2021-05-20T06:31:00Z

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

AM
  • 7
  • 171
PeerSpot user
6

6 Answers

Steve Sarsfield - PeerSpot reviewer
Vendor
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
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
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.

JA
User
2021-08-06T10:08:50Z
Aug 6, 2021

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

CD
Real User
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.).

NK
Real User
Top 20
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.


EB
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: March 2024.
763,955 professionals have used our research since 2012.
Snowflake vs. Snowflake Analytics comparison
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
Download Snowflake vs. Snowflake Analytics comparison ReportRead more

Related articles