Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
efficient data warehouse solution
What do you like best about the product?
storage and computing powers are independent. easy integration with s3 and other tools such as looker.
What do you dislike about the product?
some small caveat differences between snowflakeSQL and regular SQL/mysql have cause some rewriting in legacy codes
What problems is the product solving and how is that benefiting you?
use cases: data storage, data warehousing, data analytics. Cluster scaling/sizing & the separation of storage with compute allows for much faster queries for notably large datasets.
Recommendations to others considering the product:
smart solution for those struggling with lengthy mapR/hive queries (and the like) due to large datasets.
- Leave a Comment |
- Mark review as helpful
Snowflake has made my life easy
What do you like best about the product?
Snowflake is way faster than other DBs I have worked on for daily uses.
If table is clustered (optimized) then joins on huge table can be also be very fast.
Best of all, snowflake gives you capability to assign different warehouses for ETL , adhoc usage etc. Hence adhoc users dont have to kill their queries for ETL to run and finish.
You can see the query plan in the snowflake UI itself.
With their latest feature - AUTO CLUSTERING, now users dont have to worry about cluster and recluster as well.
Snowflake has a UI as well. Less savvy users can use snowflake's UI instead of buying any other product from the market. UI has some pretty standard features but its not the best UI I have worked with.
If table is clustered (optimized) then joins on huge table can be also be very fast.
Best of all, snowflake gives you capability to assign different warehouses for ETL , adhoc usage etc. Hence adhoc users dont have to kill their queries for ETL to run and finish.
You can see the query plan in the snowflake UI itself.
With their latest feature - AUTO CLUSTERING, now users dont have to worry about cluster and recluster as well.
Snowflake has a UI as well. Less savvy users can use snowflake's UI instead of buying any other product from the market. UI has some pretty standard features but its not the best UI I have worked with.
What do you dislike about the product?
Snowflake UI goes does very frequently, partition pruning might not work if cluster keyed filters are part of CASE WHEN.
So in nutshell, snowflake support is good but could be better in updating ETAs on their tickets.
So in nutshell, snowflake support is good but could be better in updating ETAs on their tickets.
What problems is the product solving and how is that benefiting you?
Creating a data mart to aggregate revenue from different product streams. Snowflake has been more reliable and predictable in terms of processing.
Recommendations to others considering the product:
Definitely. Its fast.
Outstanding performance and stability. Room to improve on support.
What do you like best about the product?
The database is incredibly fast even when using many joins and even with text joins. The functions ROLLUP and CUBE are critical to the way we use Snowflake and those have been unavailable in other systems. Our sales rep Sarah at Snowflake has been wonderful to work with.
What do you dislike about the product?
Support has been working a bug where queries return incorrect results for a while now. This does affect our customers, but the incorrect results cause rows to be shown many times so it's more annoying than it is misinformative. Snowflakes ABSOLUTE REFUSAL to shutdown while overloading it is awesome, but it has caused service interruption on our side due to a bad query hogging all of the resources. Instead of quitting and restarting all processes, Snowflake dutifully worked on churning the data. Good? Bad? I don't know. The query was never going to happen, so we ended up manually having to kill it so all other backed up queries could run. That being said, we are still working on developing our skills with using all of the database tools.
What problems is the product solving and how is that benefiting you?
We use snowflake for the back end of our reporting engine. Midday we will see huge spikes in reporting load and the auto scaling capabilities allow us to get the most out of our money by spinning up more only when it's needed.
Recommendations to others considering the product:
Our previous solution handled building temp tables much better than snowflake does. This was a huge performance drag for us in the beginning so we switched everything we could from building a temp table to either running one larger query or using sub queries. Things are MUCH better now. It also seems like one of the weaker points is moving the data out of Snowflake to the MySQL database or web server. We made some of our own changes to help with this.
Snowflake also offers WAY more management tools than our previous solution did. Make sure you help your DBA get training on these. You can't drive a Ferrari fast if you don't know how to drive stick...
Snowflake also offers WAY more management tools than our previous solution did. Make sure you help your DBA get training on these. You can't drive a Ferrari fast if you don't know how to drive stick...
Fantastic product. Easy to use and works great.
What do you like best about the product?
The separation of compute and storage is pure genius. Such a simple concept, but has such a tremendous impact in terms of how you manage your database performance /workloads etc. Almost nothing to tune performance - no indexes / partitions to deal with. Time travel functionality is something the business likes as well. Support for semi-structured data has allowed us to transform complex business data into easy analysis points for the business.
What do you dislike about the product?
Support is a bit spotty and difficult to get hold of. The new lodge is a great start, but will take some time to build up fully. The error messages in Snowflake are a bit cryptic at times, making it harder to troubleshoot complex issues at hand.
What problems is the product solving and how is that benefiting you?
Faster time to market and better partnership / response to business needs. Simplicity from a data engineering and analytics perspective and rapid scale. Streamlined data management processes from a business perspective, as well.
Recommendations to others considering the product:
If you're looking for a simple, no-hassle solution where you can focus more of your / your team's time on what do with the data vs. how to engineer it, I would highly recommend snowflake. Very easy and intuitive platform.
Amazing solution and great company to work with
What do you like best about the product?
The technology works exactly as described and has been a game changer for us. All of the people that we work with are very customer focused and want to make things work exceptionally well
What do you dislike about the product?
There have been a few outages and we've also encountered some bugs. All of this is par for the course, but of course, we would like to try to minimize and avoid this whereever possible.
What problems is the product solving and how is that benefiting you?
Flexibility, scale and predictability. Since moving to snowflake, we've been able to accelerate the speed of development and analysis. We have far superior capabilities through data sharing, the intuitive web interface and have been able to minimize much of our administrative overhead that we had with our previous solution
Recommendations to others considering the product:
Snowflake has been a game changer in our organization. It addresses so many of the challenges that many traditional solutions have and provides incredible flexibility that will enable a multitude of use-cases. I would strongly suggest that this be one of the top initiatives that you consider and drive.
Snowflake for Big data
What do you like best about the product?
The easy to increase performance power, the separation of database and warehouse.
What do you dislike about the product?
The setup process of snowpipe because it is not easy and confusion. I like copy command setting up process, it is straightforward and easy to maintain
What problems is the product solving and how is that benefiting you?
The SQL Server cannot handle of amount of financial data we have to process on regular basis.
Just works
What do you like best about the product?
No maintenance required, good query performance, good SQL support and features, super easy to scale, reliable so far. Data cloning and sharing is unique and awesome and fits our use case perfectly.
What do you dislike about the product?
Some bugs in the Python connector, some query errors for complex queries, can get pricy if high concurrency is required. Permission management differs from MySQL. We only had a single service outage so far.
What problems is the product solving and how is that benefiting you?
We are building a data warehouse on Snowflake, we have eliminated database maintenance costs and greatly reduced TCO. Query performance has greatly improved.
Recommendations to others considering the product:
Give it a try, rely on the community.
The new generation Big Data Platform
What do you like best about the product?
The performance, its support for semi-structured data and the Acid back-bone. It is like having Hadoop with Transactions and fine role-base security. Data Sharing is also new to the database world. We can now share any data with our Clients without additional burden.
What do you dislike about the product?
It would be nice to be able to self-manage the fail-safe. For instance tables from the fail-safe should be removed explicitely so no storage is vasted.
What problems is the product solving and how is that benefiting you?
Big Data Healthcare Analytics
Recommendations to others considering the product:
Lean how to monitor and handle the costs. You need to do that actively as the easy to use and its flexibility can increase costs quite rapidly.
Performant, Secure, and Scalable Cloud-based Data Warehouse
What do you like best about the product?
Snowflake is easy to set up and use. It provides a lot of flexibility in terms of performance and cost efficiency by its ability to scale clusters up and down in an instant. Snowflake's best feature though, in my opinion, has to be "time travel". Time travel is a concept of deriving data from any given point in time. Snowflake also has a "share" functionality, which allows us to share data across the company with ease. Snowflake's capability to clone has also helped us in our testing efforts.
What do you dislike about the product?
There's not much to be said here. Snowflake was one of the most flexible and scalable warehouse options we found in the market when researching for a cloud-based data warehouse.
What problems is the product solving and how is that benefiting you?
Snowflake allowed us to centralize most (if not all) of our data sources into a theoretical single space, which made reporting to our clients easier. Snowflake allows us to easily join data across various data sources within one single space.
Fast and scalable
What do you like best about the product?
Speed of query and ease of use of the web UI. Dialect similar to Redshift so easy to adopt.
What do you dislike about the product?
Tough to organise and share queries between users - some SQL commands are non-intuitive
What problems is the product solving and how is that benefiting you?
Scale across locations, easy to replicate
Recommendations to others considering the product:
N/A
showing 511 - 520