Snowflake AI Data Cloud
SnowflakeExternal reviews
676 reviews
from
and
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
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
Easier, faster, cheaper. I love it.
What do you like best about the product?
Having data and compute decoupled has been amazing. We save lots of money by suspending the warehouse when it's not in use.
What do you dislike about the product?
I only just learned about the cluster key feature. I'd like more proactivity towards what tuning I can do.
What problems is the product solving and how is that benefiting you?
We provide an analytics database to our customers. The flexibility of data types along with the hands off approach to performance and tuning have been very valuable. Having data and compute decoupled has been a big cost saver for us.
Really good product
What do you like best about the product?
Snowflake has the best balance between price and computing power. Redshift tiers are expensive on either storage or computing, snowflake provides best of both worlds
What do you dislike about the product?
The ecosystem is somewhat immature - you have to figure out the best ETL/data infrastructure around Snowflake
What problems is the product solving and how is that benefiting you?
Reporting - we have massive amounts of data and using SQL our front end tool (Tableau) is getting bogged down
Recommend Snowflake For Quick/Easy Data Analytics
What do you like best about the product?
It is wicked fast! Queries run faster than out 128 GM memory Oracle DB even when just running the small compute size. Also, everything is simple and they regularly improve the product.
What do you dislike about the product?
The worksheet functionality could be improved. Would be nice to save worksheets externally. Had issues with them not saving properly and all SQL scripts I had saved were lost.
What problems is the product solving and how is that benefiting you?
Bringing in data from disparate sources, cleaning it, and finding new insights.
Benefit to us was setting up quickly and not worrying about any DB administration.
Benefit to us was setting up quickly and not worrying about any DB administration.
showing 261 - 270