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



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? 

ITCS user
55 Answers

author avatar
Top 20Vendor

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. 

author avatarAriful Mondal (Wipro Ltd)
Top 5LeaderboardReal User

@Steve Sarsfield  - thank you for responding and sharing your white paper. Very useful. 

author avatarFer Lopez

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

author avatar
Top 20User

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.

author avatar
Top 20User

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

author avatar
Top 5LeaderboardReal User

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.

author avatar
Community Manager

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