Snowflake Pros and Cons

Snowflake Pros

reviewer739716
Business Intelligence and Data Engineering at a tech services company with 201-500 employees
The thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services.
View full review »
Valai Gunapalan
Architect at Sony Corporation of America
As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes.
View full review »
DivyaRaj
Sr. Software Developer at Tech Mahindra Limited
It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL.
View full review »
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
418,116 professionals have used our research since 2012.
Cesar AugustoSiado Leyva
Business Intelligence Consultant at a tech services company with 201-500 employees
The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications.
View full review »
reviewer1175826
Data & Analytics Practitioner at a tech services company with 1,001-5,000 employees
They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises.
View full review »
Padmanesh NC
Big Data Solution Architect - Spatial Data Specialist at Sciera, Inc.
The distributed architecture of Snowflake has the capacity to process huge datasets faster and allows us to scale up and down according to our needs.
View full review »
RajeshBalasubramaniyan
Principal Technologist at a healthcare company with 10,001+ employees
The snapshot feature is good, the rollback feature is good and the interface is user-friendly.
View full review »
JatinArora
Data Engineer at Celebal Technologies
The initial setup is straightforward. You just need to follow the documentation.
View full review »
reviewer1077408
R&D Operations Manager at a manufacturing company with 1,001-5,000 employees
I like the idea that you can assign roles and responsibilities, limiting access to data.
View full review »
Yuval Klein
Pre-sale Leader, Big Data Enterprise Solutions at Ness Technologies
The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes.
View full review »

Snowflake Cons

reviewer739716
Business Intelligence and Data Engineering at a tech services company with 201-500 employees
Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway.
View full review »
Valai Gunapalan
Architect at Sony Corporation of America
There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source.
View full review »
DivyaRaj
Sr. Software Developer at Tech Mahindra Limited
They do have a native connector to connect with integration tools for loading data, but it would be much better to have the functionality built-in.
View full review »
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
418,116 professionals have used our research since 2012.
Cesar AugustoSiado Leyva
Business Intelligence Consultant at a tech services company with 201-500 employees
Support needs improvement, as it can take several days before you get some initial support.
View full review »
reviewer1175826
Data & Analytics Practitioner at a tech services company with 1,001-5,000 employees
The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template.
View full review »
Padmanesh NC
Big Data Solution Architect - Spatial Data Specialist at Sciera, Inc.
Snowflake has to improve their spatial parts since it doesn't have much in terms of geo-spatial queries.
View full review »
RajeshBalasubramaniyan
Principal Technologist at a healthcare company with 10,001+ employees
Availability is a problem.
View full review »
JatinArora
Data Engineer at Celebal Technologies
The solution could improve the user interface and add functionality to the system.
View full review »
reviewer1077408
R&D Operations Manager at a manufacturing company with 1,001-5,000 employees
If you go with one cloud provider, you can't switch.
View full review »
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
418,116 professionals have used our research since 2012.