External reviews
636 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Fast, Affordable, Scalable
What do you like best about the product?
Beats Redshift in performance and cost. The in-time snapshot to roll back data to a previous state is also pretty incredible. The data storage costs is very low in comparison to Redshift and the computational speed far exceeds what Redshift can handle. DUO push as a two step authentication is a bonus.
What do you dislike about the product?
Extra fees for security and vpc. Not really a big fan of paying roughly 30-50% more for AWS VPC routing.
Also there might be a need for more support hours since databases can be used 24/7 downtime can occur anytime. During a regional, but not national Holiday, most of the company was out and there wasn't any method to contact support team besides leaving a phone number and waiting it out.
Also there might be a need for more support hours since databases can be used 24/7 downtime can occur anytime. During a regional, but not national Holiday, most of the company was out and there wasn't any method to contact support team besides leaving a phone number and waiting it out.
What problems is the product solving and how is that benefiting you?
Data Analysis, Big Data. Parallel queries.
Reaped benefits in roughly 1/3 the cost of Redshift and in significantly improved query times.
Reaped benefits in roughly 1/3 the cost of Redshift and in significantly improved query times.
Recommendations to others considering the product:
Better support hours. During one of the regional but not national US holidays it was hard to reach anyone for support. Wondering if there are better support pricing plans.
Also would be nice to not have to pay significantly more for AWS security integration features. All in all, it still beats out Redshift by miles.
Also would be nice to not have to pay significantly more for AWS security integration features. All in all, it still beats out Redshift by miles.
Near Zero Maintenance
What do you like best about the product?
We have taken over all of the DBA management for our warehouse(s) without additional resources. This is because we don't have very many maintenance or configuration tasks (or issues).
What do you dislike about the product?
Have a more robust stored procedure features will be great.
What problems is the product solving and how is that benefiting you?
Reducing maintenance of our data warehouses (building indexes, restarting servers, etc)
Meeting SLAs by moving from nightly batch processing to near-real-time micro-batching (15-30 mins).
Product stability and improved performance
Reducing cost
Meeting SLAs by moving from nightly batch processing to near-real-time micro-batching (15-30 mins).
Product stability and improved performance
Reducing cost
Recommendations to others considering the product:
Snowflake out performs others by separating compute and storage. Per second billing in conjunction with pausing and auto resume can really save cost. We have very little maintenance and configuration work. My team has taken over all of the DBA tasks since there are so few and it's very low complexity.
Amazing Solution!
What do you like best about the product?
Snowflake's flexibility in the data warehouse space is amazing. The scalability and price can't be beat! Plus, I have an amazing Account Exec, Chris Li, that is always passionate about providing the best value.
What do you dislike about the product?
I would love to see smart text when drafting SQL.
What problems is the product solving and how is that benefiting you?
In the process of developing an Enterprise Data Warehouse (EDW). We've made a lot of progress and our internal customers can run queries that are extremely fast making it easier for them to make key decisions.
Recommendations to others considering the product:
Try it! You'll be amazed at the query performance and low cost
Turnkey simplicity
What do you like best about the product?
Snowflake just works! No crazy complexity required to fine tune the system, no complex spreading of data across nodes, partitioning, indexing, configuation etc. Need a separate 'box' for heavy duty BI queries? Spin one up instantly! Need a bigger resource for a big ETL job, again spin one up instantaneously and shut it down when it's done - per second billing means you don't pay for resources you don't need. You can really tell a lot of thought has gone into a complete redesign - it hasn't been 'stretched' for the cloud, but 'built' for the cloud
What do you dislike about the product?
Nothing really! The organisation is growing rapidly, so they don't necessarily have the customer suppot teams outside of Europe. Some functions are WIP e.g. additional windowing functions, recursion.
What problems is the product solving and how is that benefiting you?
Snowflake is acting as a data lake/warehouse for my organisation, which alleviates the need to have eg Hadoop for storage and an RDBMS for presentation. One platform makes it so much simpler.
Recommendations to others considering the product:
use the free trial credits to try for yourself
Great value for money, actionable data platform that will accelerate any data strategy
What do you like best about the product?
We got to modernise our ailing, ageing data infrastructure without it costing the earth. Our data staff, all conversant in SQL were able to transfer their skills overnight, and our analytics staff all got access to cloud scalability to support their heavy analytical workloads (no Hadoop in sight). VERY, VERY cost effective way to modernise!
What do you dislike about the product?
Nothing - it's brilliant! Would really love there to be a built-in environment for scheduling SQL scripts, but there are plenty of ETL tools for this already.
What problems is the product solving and how is that benefiting you?
Business problems / opportunities = Single Customer View. Customer Data Platform. Website engagement / data collection. Enterprise Data Warehouse. Business Intelligence modernisation. Predictive Analytics.
Benefits = cost savings over "big data" solutions; cost saving on data warehouse management, business intelligence modernisation, supporting predictive analytics initiatives that are saving money / boosting top line sales. In-sourced single customer view.
Benefits = cost savings over "big data" solutions; cost saving on data warehouse management, business intelligence modernisation, supporting predictive analytics initiatives that are saving money / boosting top line sales. In-sourced single customer view.
Recommendations to others considering the product:
Just do it. Honestly, if you are looking for a sophisticated data platform that supports heavy analytical workloads, whilst keeping it simple then you will not find a better solution.
Data Expert
What do you like best about the product?
JSON parsing feature of Snowflake is the best compare to Redshift. I am currently using snowflake as our main data warehouse where multiple application has JSON data and snowflake does it really well.
What do you dislike about the product?
Support response is slow in case of emergency need. I had need last year and response was very slow.
What problems is the product solving and how is that benefiting you?
Firstly, I use Snowflake to build data pipelines using multiple applications and store it in snowflake.
and Our business team uses this data for analysis.
and Our business team uses this data for analysis.
Recommendations to others considering the product:
There is no need to think about which cloud data warehouse to go with, Snowflake is the best and highly recommended cloud data warehouse.
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...
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.
showing 261 - 270