External reviews
636 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Easy to use, easy with json objects, easy for ETL
What do you like best about the product?
Snowflake lets me load a lot of formats of data and play around with them. It reads anywhere from .gz to .csv and let's me copy specific coloumns' data out.
I actually use it as a replacement for Ms Excel on my Mac. I had taken a python course and instead of using Pandas, I used Snowflake to good effect.
I actually use it as a replacement for Ms Excel on my Mac. I had taken a python course and instead of using Pandas, I used Snowflake to good effect.
What do you dislike about the product?
Snowflake could bring in the support of a procedural SQL like PL/SQL. That would really make it unmatched.
What problems is the product solving and how is that benefiting you?
We are using Snowflake for in house data warehousing and ETL. We run all our analytical and intelligence generation queries on Snowflake and have realized how fast and efficient it is.
Recommendations to others considering the product:
It is wort giving a shot if you are reconsidering your ETL options.
Cloud native Database with exceptional performance and usability!
What do you like best about the product?
There are few things I liked Snowflake -
-Ease of management
-Complete elastic architecture
-Complete separation of compute and storage
-Compute clusters can be managed by end users
-Simple pricing model
-Dynamic scaling on the fly
-Ease of management
-Complete elastic architecture
-Complete separation of compute and storage
-Compute clusters can be managed by end users
-Simple pricing model
-Dynamic scaling on the fly
What do you dislike about the product?
I mostly liked Snowflake compared to other cloud databases and some aspects needs improvements incl. Geospatial functions and additional libraries.
What problems is the product solving and how is that benefiting you?
I'm using Snowflake to house enterprise data platform where all critical insurance related end to end information is stored in the form of real-time dataware house platform. With Lambda-Snowpipe it has been greatly successful to solve business problems. End users are completely hooked to Snowflake functionality due to agility and usability. Since it enables self service cluster management it's even more popular.
Recommendations to others considering the product:
-Experience snowflake for elasticity and scalability. part from that end users liked it more due to features like ease of use, cloning, on-demand cluster management etc. Security is huge plus on how data is protected.
Snowflake is great for performance and low maintenance
What do you like best about the product?
The performance has been great. We have seen 3 to 8 times improvement on query performance.
There has been very low maintenance work such as tuning hardware or system configuration or query plan optimization.
The auto resume and auto shutdown is great for cost savings.
Also, we are using processing semi-structure data like JSON as well.
There has been very low maintenance work such as tuning hardware or system configuration or query plan optimization.
The auto resume and auto shutdown is great for cost savings.
Also, we are using processing semi-structure data like JSON as well.
What do you dislike about the product?
More improvements in on the Stored Proc front.
What problems is the product solving and how is that benefiting you?
Migrating our on-premise MSSQL Server DW to Snowflake. We are improving performance, doing micro batching during the day, increase uptime (meeting SLAs),
Centralizing our data and reducing complexity.
Centralizing our data and reducing complexity.
Recommendations to others considering the product:
Make sure your solution separates compute from storage.
Evaluate how much technical expertise it takes to administer the system (lower is better).
Really look at cost (per second billing, storage, etc)
Evaluate how much technical expertise it takes to administer the system (lower is better).
Really look at cost (per second billing, storage, etc)
Snowflake > Redshift
What do you like best about the product?
- independent, on-demand scaling of compute and storage
- no maintenance / ops (don't have to worry about vacuum, adding nodes, sort / dist keys, weekly maintenance, etc)
- no maintenance / ops (don't have to worry about vacuum, adding nodes, sort / dist keys, weekly maintenance, etc)
What do you dislike about the product?
Because it's a new comer, the ecosystem is not as well established as Redshift (which has been around for over 6 years)
What problems is the product solving and how is that benefiting you?
It serves as our data warehouse and it replaces Redshift. The biggest benefit is just how little time we have to spend on upkeep, and can invest that into building something that's much more impactful
Scalable cloud data warehouse
What do you like best about the product?
Scalability - you can add as many compute nodes as you need to in order to meet your demand. You can also shut them down as needed to save on the cost.
What do you dislike about the product?
Cost and perceived savings of auto shut off. While the concept is awesome, being able to auto shut off is the only way to make Snowflake come even close in terms of cost to Azure data warehouse and AWS redshift.
What problems is the product solving and how is that benefiting you?
Servers as a data warehouse. Since it is a fully managed cloud service, a business doesn't need database administrators to set it up and perform management.
Recommendations to others considering the product:
Evaluate the cost savings of auto shut off. It may not be as worth it compared to other vendors. Also investigate ETL tools that work with. Even though SnowSQL can ingest data, there may be better options.
The DB for bigdata!
What do you like best about the product?
The Snowflake capacity to deal with a really large amount of data, usually faster but if not you can always bump the warehouse size and get results faster, and this all is done within a few clicks and smooth. Very well documented as well and quick support answers when needed.
What do you dislike about the product?
Lack of UI features for operations and debug. Not able to give hints to the compiler. Some updates that cause unexpected issues sometimes.
What problems is the product solving and how is that benefiting you?
Basic ETL queries over a huge amount of data.
Recommendations to others considering the product:
Talking about a software engineer view I definitely suggest you to give it a try. I'll be amazed by speed, features, and easy implementation, I can even run queries from my Sublime editor. The whole team is way more productive by not having to think about the db solution as much as before.
Great value and functionality
What do you like best about the product?
Performance and costs are configurable easily to your needs. Snowflake is also easily integrated with leading BI and ETL/ELT tools. Built-in tuning and optimization is very useful
What do you dislike about the product?
Admin panel could be a bit more comprehensive (user/role/group management), usage metrics
What problems is the product solving and how is that benefiting you?
Consolidated data warehouse and ability to handle data load, queries, and transactions simultaneously
Powerful tool that offers impressive query performance against semi-structured data
What do you like best about the product?
The feature that stands out most to us is the fact that we can send raw JSON into snowflake and each property is automatically indexed. This gives us the ability to operationalize our use of semi-structured data with minimal engineering overhead.
What do you dislike about the product?
Currently the only headache we're having is that it does not work to seamlessly integrate Azure Append Blobs into Snowflake. It still feels a bit like Microsoft Azure is a bit of a second class citizen.
What problems is the product solving and how is that benefiting you?
We wanted to build a robust automated data pipeline that would ultimately result in a de-identified data warehouse that provided scalable reporting functionality across massive data sets. Using semi-structured data allowed us to create a relatively generic, performant pipeline for our big data to get ingested into Snowflake, and the tool's scalability allows us to query that data in an efficient manner regardless of how much data is utilized. Compared to our previous hadoop-based reporting functionality, the performance is not even comparable.
Recommendations to others considering the product:
If you're already using Amazon AWS, Snowflake will be very easy to utilize. If you're a Microsoft Azure shop, there will be a few additional hoops to jump through and some additional cost overhead, but it's still worth the headaches once that data is loaded into Snowflake, as the query performance and scalability really does seem to be the best of the tools we've evaluated.
Easy, scaleable, seemless
What do you like best about the product?
Snowflake perfectly suits our needs - it turns on and scales up automatically, and is invisible, and free, when not in use. Couldn't ask for more.
What do you dislike about the product?
Nothing
What problems is the product solving and how is that benefiting you?
A single, consolidated place for our many data sources. Will scale to match our needs seamlessly into the future.
Very Good Experience
What do you like best about the product?
The query time is significantly better than qubole
What do you dislike about the product?
There are no stored procedures and no scheduler
What problems is the product solving and how is that benefiting you?
Cost saving vis-a-vis reduced query time
showing 241 - 250