Snowflake AI Data Cloud
SnowflakeExternal reviews
666 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Fast Data storage
What do you like best about the product?
Snowflake is easy to use, and abstracts away a lot of the annoying problems of database management I had to deal with when running my own.
What do you dislike about the product?
There's poor visibility into query optimization, but that's not so bad because it runs so fast. I also don't know how optimally I use all of my warehouses.
What problems is the product solving and how is that benefiting you?
Storing large quantities of data without worrying about scaling databases
Seems to just do what it says
What do you like best about the product?
Ease of use, nice docs, full ansi SQL support
What do you dislike about the product?
docs are not as usable as they used to be.
What problems is the product solving and how is that benefiting you?
large data store
I think Snowflake could be an excellent choice as a data warehouse
What do you like best about the product?
Snowflake provides the flexibility to use the data warehouse by multiple analysts at the same time.
What do you dislike about the product?
I think you can add more features to the web interface.
The way I see it, it eventually should have most of the features a modern IDE has, in terms of syntax highlighting, autocomplete, refactoring.
One simple example: it could be great if I could collapse a query. It happens a lot that you run multiple queries from the same worksheet.
Another
The way I see it, it eventually should have most of the features a modern IDE has, in terms of syntax highlighting, autocomplete, refactoring.
One simple example: it could be great if I could collapse a query. It happens a lot that you run multiple queries from the same worksheet.
Another
What problems is the product solving and how is that benefiting you?
Security analytics.
Recommendations to others considering the product:
Before start using a data warehouse, you should understand the use case. It's weird to start paying for running queries. It's not very intuitive.
We are used to purchase a product and pay for that. It's strange to pay differently if someone was running a inefficient query.
We are used to purchase a product and pay for that. It's strange to pay differently if someone was running a inefficient query.
Finally, Cloud-based data warehousing done right.
What do you like best about the product?
Big data capabilities with the familiarity of SQL. No need to learn a new language.
Auto-scaling of computing resources and data sharing functionality.
Auto-scaling of computing resources and data sharing functionality.
What do you dislike about the product?
Compilation times on somewhat complex queries is high. We use materialized views to address this problem and take advantage of caching, but we believe there is room for improvement here.
What problems is the product solving and how is that benefiting you?
Making semistructured data available for analysis, allowing power users to directly query the DW without interfering with production resources and the potential of the data sharing capabilities have been a big win for us.
Recommendations to others considering the product:
Do ELT instead of ETL. Take advantage of SnowPipe, Alooma, Fivetran or any other streaming service/architecture to get your data into Snowflake.
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
showing 291 - 300