Snowflake AI Data Cloud
SnowflakeExternal reviews
686 reviews
from
and
External reviews are not included in the AWS star rating for the product.
efficient data warehouse solution
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.
Snowflake has made my life easy
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.
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.
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.
Fantastic product. Easy to use and works great.
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.
Fast and scalable
What do you like best about the product?
Speed of query and ease of use of the web UI. Dialect similar to Redshift so easy to adopt.
What do you dislike about the product?
Tough to organise and share queries between users - some SQL commands are non-intuitive
What problems is the product solving and how is that benefiting you?
Scale across locations, easy to replicate
Recommendations to others considering the product:
N/A
Perfect Data Warehouse in the cloud
What do you like best about the product?
JSON support is amazing. While other engines support JSON format for data types, snowflake does it with performance. It is a breeze to query data stored as JSON because of underlying columnar storage that JSON gets converted to. We also like how easy it is to add additional compute nodes when needed. This was a pain point with some other vendors. With a push of a button (or a simple script) you can add additional compute power. When the demand subsides, you can turnd those off.
What do you dislike about the product?
Cost. It's on the pricier end of things. Between Azure Data Warehouse and AWS Redshift, Snowflake was significantly more expensive even with auto shut off feature enabled. But it seems that some of those costs can be written off due to simplicity of set up and maintenance that would typically go to DBA resource.
What problems is the product solving and how is that benefiting you?
We were in need of a modern, cloud and scalable data warehouse. We have a lot of data that's pretty structured for the most part, and we were looking for a product that can provide quick reads on analytic loads.
Recommendations to others considering the product:
Getting data into snowflake is slightly different from some other ETL processes that you may have encountered. Mind that piece when evaluating.
Great scaleable service, just some smaller company kinks to iron out
What do you like best about the product?
The ease of scaling, access to support, how the service is always getting better
What do you dislike about the product?
Unexpected downtime, was tough to get status updates on these downtimes - that has been getting better generally
What problems is the product solving and how is that benefiting you?
Larger scale processing, ease of scaling up when volumes get too high.
Easy, fast, powerful
What do you like best about the product?
Snowflake is managed in a way that your queries perform optimally without much effort on your part. The database user management and roles is familiar (think PostgreSQL style) and can be done through a user interface or via SQL--both business users and experienced DBA's will be comfortable.
What do you dislike about the product?
I can't honestly think of much. The AWS region limitations are slightly problematic for East coast users, but overall this hasn't affected us hardly at all.
What problems is the product solving and how is that benefiting you?
Real time analytics for lab customers in the healthcare space.
Recommendations to others considering the product:
Consider this as an alternative to other columnar databases like Redshift. The speed is faster, and definitely outperforms MySQL and PostgreSQL on large, aggregate data.
Simple but fast.
What do you like best about the product?
I like the fact that we have got many disparate data sources into 1 place. The queries issued against the data are quite fast and the data is stored optimally, taking up less space than they use in the source systems.
What do you dislike about the product?
Scheduling is needed within snowflake itself. A full fledged client would be preferred to the web interface. More features within the SQL code itself is needed, like correlated sub queries in the select, instead of only in the where clause.
What problems is the product solving and how is that benefiting you?
We have been able to join multiple disparate data sources into one place and are able to query across these data sources to get more insights into the business operations.
Recommendations to others considering the product:
Get one of the recommended ETL tools to get your data into snowflake and give snowflake a trial, you will be amazed at how fast you can get all your business data into snowflake and the the speed of your queries.
ease of use
What do you like best about the product?
Love that the platform integrates with many different cloud based services. Along with the ease of use, The service is great, when a ticket is submitted, they're really good at replying to your issues. When there are service interruptions, they make sure we're the first ones to know.
What do you dislike about the product?
No stored procedures or event handling. Some services require us to pay a little extra even (such as reclustering) as it should already be included in the price. Sometimes the UI lags, but made huge improvements to the new UI.
What problems is the product solving and how is that benefiting you?
Loading large mounts of data in near real time availability. Also the ability to use jdbc connections to various Business Intelligence platforms was a deal sealer.
Recommendations to others considering the product:
Keep creating services to allow the product to be easily useable. Make sure your data is already available in s3, and know how to use cloud based services like amazon web services and/or microsoft azure.
Awesome technology, needs refining
What do you like best about the product?
We love the fact that we can spin up additional warehouses on demand. We like the fact that most admin work is done by the provider
What do you dislike about the product?
Security is not enterprise grade yet. Hard to administer and query security tables. No way to authenticate against multiple SAML providers
What problems is the product solving and how is that benefiting you?
This is our primary Business Intelligence Warehouse
showing 311 - 320