Snowflake AI Data Cloud
SnowflakeExternal reviews
676 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Easy to use zero maintenance true cloud data warehouse
What do you like best about the product?
Snowflake is a zero maintenance true cloud data warehouse. We can control the cost, scale up and down the resources needed to make it fast. It is compatible with ANSI SQL which makes querying data very easy. Also in built support for JSON handling that data easier. Strong security come out of the box with roles and schema level controls.
What do you dislike about the product?
I would want more ways to load data into Snowflake. Also handling of more character types would make some tasks easier. Some of the error messages are not intuitive. Also native integration with traditional databases would make it easier to manage ETL jobs. Some kind of inbuilt scheduling capability would also make it easier to use Snowflake.
What problems is the product solving and how is that benefiting you?
I gather data from multiple data sources in different formats into Snowflake and then stitch it together using ETL. By this I build data marts for marketing, sales, product etc. which are then connected to Tableau to produce dashboards. This has enabled full view of our customers journey and easy insights for different teams across the company.
Recommendations to others considering the product:
Good product. But need to manage to keep costs lower.
Great database application
What do you like best about the product?
sql console allows to keep previous commands, also the easy to see the schemma
What do you dislike about the product?
lack of suggestions as you type it should show or sugest what commands to use.
warning that query will take long time.
warning that query will take long time.
What problems is the product solving and how is that benefiting you?
Data integration and reconciliation. is conftable to use it.
Recommendations to others considering the product:
Great product with great functionality flexible and easy to manage
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.
showing 301 - 310