Sign in
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

Snowflake On Demand - Standard

Snowflake | 12.04

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
    0
  • 4 star
    0
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

531 reviews
from G2

External reviews are not included in the AWS star rating for the product.


    Scott S.

Great value for money, actionable data platform that will accelerate any data strategy

  • February 26, 2019
  • Review provided by G2

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.
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.


    Avinash H.

Easy to use zero maintenance true cloud data warehouse

  • February 26, 2019
  • Review verified by G2

What do you like best about the product?
Snowflake is a zero maintenance true cloud data warehouse. We can control the cost, scale up and down the resources needed to make it fast. It is compatible with ANSI SQL which makes querying data very easy. Also in built support for JSON handling that data easier. Strong security come out of the box with roles and schema level controls.
What do you dislike about the product?
I would want more ways to load data into Snowflake. Also handling of more character types would make some tasks easier. Some of the error messages are not intuitive. Also native integration with traditional databases would make it easier to manage ETL jobs. Some kind of inbuilt scheduling capability would also make it easier to use Snowflake.
What problems is the product solving and how is that benefiting you?
I gather data from multiple data sources in different formats into Snowflake and then stitch it together using ETL. By this I build data marts for marketing, sales, product etc. which are then connected to Tableau to produce dashboards. This has enabled full view of our customers journey and easy insights for different teams across the company.
Recommendations to others considering the product:
Good product. But need to manage to keep costs lower.


    Market Research

Great database application

  • February 26, 2019
  • Review provided by G2

What do you like best about the product?
sql console allows to keep previous commands, also the easy to see the schemma
What do you dislike about the product?
lack of suggestions as you type it should show or sugest what commands to use.
warning that query will take long time.
What problems is the product solving and how is that benefiting you?
Data integration and reconciliation. is conftable to use it.
Recommendations to others considering the product:
Great product with great functionality flexible and easy to manage


    Information Technology and Services

Data Expert

  • February 26, 2019
  • Review provided by G2

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.
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.


    Information Technology and Services

efficient data warehouse solution

  • February 26, 2019
  • Review verified by G2

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.


    Ankit A.

Snowflake has made my life easy

  • February 26, 2019
  • Review verified by G2

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.
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.
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.


    Computer Software

Outstanding performance and stability. Room to improve on support.

  • February 26, 2019
  • Review verified by G2

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...


    Insurance

Fantastic product. Easy to use and works great.

  • February 26, 2019
  • Review verified by G2

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.


    Information Technology and Services

Amazing solution and great company to work with

  • February 26, 2019
  • Review verified by G2

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.


    Financial Services

Snowflake for Big data

  • February 26, 2019
  • Review verified by G2

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.