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.
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
- Leave a Comment |
- Mark review as helpful
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
Bad UI
What do you like best about the product?
Relatively quick for being in-browser, snappy design
What do you dislike about the product?
Bad UI, unintuitive, can't process info quickly, wish I could do more with the data for analyst use-cases
What problems is the product solving and how is that benefiting you?
Operational data warehouse
Minimum overhead, good query performance
What do you like best about the product?
Snowflake provides lots of features as auto-starting and auto-pausing virtual warehouses that turn the administration of the data warehouse much easier and cost efficient. The pricing model separating compute and storage is very useful in some cases and enables great cost allocation between departments with the concept of multiple virtual warehouses. Queries in Snowflake also run fast compared to other products like AWS Redshift.
What do you dislike about the product?
Even having JDBC and ODBC drivers, the ecosystem with native integration is still small compared to other more established products.
What problems is the product solving and how is that benefiting you?
Data warehousing with good analytical query performance is what Snowflake delivers. Its technology makes data ingestion easy too. It also delivers great features for cost management.
User Review for Snowflake
What do you like best about the product?
Its pretty fast. Mush faster than contemporaries
What do you dislike about the product?
UI is not responsive and goes down quite a bit
What problems is the product solving and how is that benefiting you?
Creating a Datamart as centralised source of data.
Snowflake makes building a data warehouse / data lake easy
What do you like best about the product?
* Ability to easily and quickly scale storage and compute independently. Lots of scaling options.
* Flexible data structure support (cluster keys, materialized views)
* Snowpipe feature makes it incredibly easy to ingest data from S3 automatically
* Excellent JSON support; can handle nested structures
* Integrates well with our Business Intelligence tooling. Lots of native integration support.
* Excellent community. Lots of events and resources for learning how to effectively use the product.
* Flexible role-based permissions model
* Slack support is responsive
* Flexible data structure support (cluster keys, materialized views)
* Snowpipe feature makes it incredibly easy to ingest data from S3 automatically
* Excellent JSON support; can handle nested structures
* Integrates well with our Business Intelligence tooling. Lots of native integration support.
* Excellent community. Lots of events and resources for learning how to effectively use the product.
* Flexible role-based permissions model
* Slack support is responsive
What do you dislike about the product?
Not much to write about here -- this is a great service! :)
There are still a few technologies we've looked at that are in the early days of building a native integration with Snowflake.
In the past, I've needed to refresh schema role grants when adding new tables; it'd be convenient to express that I want those automatically included in the grant.
There are still a few technologies we've looked at that are in the early days of building a native integration with Snowflake.
In the past, I've needed to refresh schema role grants when adding new tables; it'd be convenient to express that I want those automatically included in the grant.
What problems is the product solving and how is that benefiting you?
Snowflake's capable platform allows us to stitch together disparate data sets and build strategic insights. We've built analytics products that can pull from Product, CRM, and a multitude of Operational data sets. Some of our data sets are huge, but that's not been a problem for Snowflake.
amazing tool
What do you like best about the product?
it is Fast and Robust and handles large amount of Data at ease
What do you dislike about the product?
its compatibility with other interfaces, it cannot be used with .Net Framework
What problems is the product solving and how is that benefiting you?
we have a system which can generate about 20+ millions records a day and we need a system which will integrate with Tableau for reporting and Snowflake solved the purpose
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.
showing 471 - 480