Snowflake AI Data Cloud
SnowflakeExternal reviews
666 reviews
from
and
External reviews are not included in the AWS star rating for the product.
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.
Fast and efficient DB
What do you like best about the product?
That's the fastest and the most agile DB I ever worked with. I also deeply appreciate scale-ability as you can always throw in more computational power if you need so without any hassle
What do you dislike about the product?
Some queries are not optimized as you'd expect them to be, that leads to you writing some workarounds which work "kind of" the way you wanted them to be. Sometimes support team resolves problems, but sometimes they reply something like "it's the way it works, deal with it". I also wish the query details\profile screen was easier accessible from worksheets: the UI is sort of slow in switching from worksheet to query details and if you do that as one off - it's not a biggie, but as you do it more often - that becomes a hassle as UI getting laggy and works slow.
What problems is the product solving and how is that benefiting you?
Big data analysis and pre-computations, kpis became easier with Snowflake. We were able to achieve our tasks of serving data in the way our customers need, with all metrics they need fast enough so they are happy
Recommendations to others considering the product:
Be careful about not using lots of partitions: use clustering, make your queries to skip partitions as early as possible if they don't qualify to make their way in the end result. All in all for me it's like Elastic Search in the DB world: very powerful and agile, easy to tailor to your needs, but you should be careful with the conditions and how you write your queries
Data Solution that's fast and simple
What do you like best about the product?
I like the speed at which you can accomplish a task that is assigned to you by using the variety of tools provided by Snowflake.
What do you dislike about the product?
I only dislike the fact that tables with constraints are not enforced particularly with a primary key.
What problems is the product solving and how is that benefiting you?
We are solving Data Visualization problems and Snowflake excels at this due to its speed. The viz needs to interact with the underlying data table very quickly and we had great success with Snowflake.
We are also solving ETL pipelines. We have seen Snowflake churn through TB's of data in a couple minutes which is pretty awesome and not possible with any other solution to date.
We are also solving ETL pipelines. We have seen Snowflake churn through TB's of data in a couple minutes which is pretty awesome and not possible with any other solution to date.
Recommendations to others considering the product:
If you are looking for a fast, reliable, and easy to use data solution. I would look no further than Snowflake. Faster than Vertica, Hive, and Presto. Well balanced pricing plans and outstanding support.
As good as they say they are
What do you like best about the product?
I like that Snowflake uses a mix of novel solutions and tried and true foundations to deliver a product that they say they deliver. The main thing is the ease of use, and the speed of use.
What do you dislike about the product?
I guess my only critique would be that I didn't fully understand how it worked when we first started using it and therefore was not able to use it to it's full power. Maybe I wasn't privy to those convos?
What problems is the product solving and how is that benefiting you?
We are solving major ETL problems and data governance/organizational issues. In addition we are able to make apps work faster than we ever could have otherwise.
showing 261 - 270