Snowflake AI Data Cloud
SnowflakeExternal reviews
666 reviews
from
and
External reviews are not included in the AWS star rating for the product.
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
Performance and Ease of use
What do you like best about the product?
Extremely easy to get started. Snowflake supports the most common SQL operations as well as a large library of useful analytic functions. It includes excellent documentation and with performance tuning handled by Snowflake, it's easy for analysts to focus on writing SQL.
What do you dislike about the product?
No complaints so far. It's by far the best database engine I've used.
What problems is the product solving and how is that benefiting you?
Answer transaction-level questions on large datasets at scale.
Recommendations to others considering the product:
It's easy to switch!
great cloud data warehouse
What do you like best about the product?
snowflake is great and it is a very popular tool for data warehouse building in the cloud it lets you import tons of data instantly
What do you dislike about the product?
it is a little bit expensive and it takes awhile to set up
What problems is the product solving and how is that benefiting you?
build data warehouse in the cloud with very little investment
Snowflake Solves problems
What do you like best about the product?
I like that compute and storage are separate and i can scale up my compute. That writes do not block reads.
What do you dislike about the product?
The architecture is not good for web speed apps. There is too much latency per call.
What problems is the product solving and how is that benefiting you?
Lots of problems. We are basing our customer facing flagship product on it and we are using it internally for many uses.
Recommendations to others considering the product:
Do a proof of concept.
Simple to use datawarehouse solution for extremely large data
What do you like best about the product?
Snowflake can handle the extremely large data -- on the order of thousands of TB -- that we have, and provide us with rapid results.
What do you dislike about the product?
Poor documentation -- although clustering is Snowflake's killer feature, figuring out why, after calling 'alter table recluster' on a table, that table is only .001% more clustered than before is painful. It's not clear why you wouldn't just sort the table on insert instead of calling recluster, since recluster on a static dataset incurs the penalty of insertion twice. Not much documentation about how data will be loaded, just vague statements from their tech team that "if your data is naturally clustered, Snowflake will recognize that." Well..... explain what you mean, please.
What problems is the product solving and how is that benefiting you?
Primarily we have been using Snowflake to run adhoc reports on the behalf of clients. We would not be able to do so on nearly any other data warehouse system.
Recommendations to others considering the product:
It's easy to use but pretty expensive and can be a little bit opaque to figure out.
showing 301 - 310