Snowflake AI Data Cloud
SnowflakeExternal reviews
676 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Like a speeding bullet
What do you like best about the product?
easy usage, SQL oriented, excellent sales team
What do you dislike about the product?
nothing, at this point nothing is of concern for our team
What problems is the product solving and how is that benefiting you?
Integration of Enterprise data into a cogent cloud-based environment
Xtreme USer of Snowflake
What do you like best about the product?
Usability of Snowflake is great. Best in class
What do you dislike about the product?
Not much .. may be its flexibility is an issue
What problems is the product solving and how is that benefiting you?
Migrating all my DWH to snowflake has been so easy
Extremely versatile cloud-based data warehouse product
What do you like best about the product?
Provides very fast update and query performance for a reasonable cost. Cloud-based deployment keeps database management to an absolute minimum.
What do you dislike about the product?
Still not as mature as some other RDBMS products but is rapidly developing functionality.
What problems is the product solving and how is that benefiting you?
We are implementing near real-time data warehousing, bringing insights to users far faster than before.
Recommendations to others considering the product:
Just start -- easy to deploy so get started with a proof-of-concept project that can easily be developed into a live system.
Snowflake is Snowballing
What do you like best about the product?
1) Speed (single execution) - everything is ridiculously fast. I'm no longer restrained by what I can do because of speed constraints found on other systems.
2) Storage - super cheap storage is huge for me as a developer. My job is so much easier when I can log and save more data.
2) Storage - super cheap storage is huge for me as a developer. My job is so much easier when I can log and save more data.
What do you dislike about the product?
1) latency between executions. We execute a lot of statements at once, but the throughput of those statements is slow. It would help if we could submit multiple statements in a batch.
2) Need real stored procedures... the current development preview of procedures is disappointing. I would not call them "procedures". I would call them "internal APIs". Looping in the current procedure just submits SQL statements that have the same latency problems as item 1. Makes them pretty much unusable for row by row processing of many rows in a loop (which is the only REAL reason you should ever have to use looping in a SQL language). We have two situations for looping at speed row by row for thousands of rows... row by row processing of data where some rows could have an error, while others do not. The other is just super complicated calculations that just are more maintainable in a loop (lead and lag functions might make it possible, but more difficult to maintain).
3) support has gone down hill since the early days... we are now getting responses from front line support with responses that are not helpful at all. We always have to get to 2nd tier support before we are helped at all. Front line support just responds with stuff that we already know that doesn't help us at all.
2) Need real stored procedures... the current development preview of procedures is disappointing. I would not call them "procedures". I would call them "internal APIs". Looping in the current procedure just submits SQL statements that have the same latency problems as item 1. Makes them pretty much unusable for row by row processing of many rows in a loop (which is the only REAL reason you should ever have to use looping in a SQL language). We have two situations for looping at speed row by row for thousands of rows... row by row processing of data where some rows could have an error, while others do not. The other is just super complicated calculations that just are more maintainable in a loop (lead and lag functions might make it possible, but more difficult to maintain).
3) support has gone down hill since the early days... we are now getting responses from front line support with responses that are not helpful at all. We always have to get to 2nd tier support before we are helped at all. Front line support just responds with stuff that we already know that doesn't help us at all.
What problems is the product solving and how is that benefiting you?
1) Reporting on a decent size data warehouse that isn't perfectly optimized. Reports that were taking 50 minutes in the past on old systems, take minutes with Snowflake with data structure changes.
2) Transactional processing - We are recently using Snowflake for a "middle layer" of integrating between multiple systems. We use snowflake to keep track of many jobs that are sending and receiving data between many systems.
2) Transactional processing - We are recently using Snowflake for a "middle layer" of integrating between multiple systems. We use snowflake to keep track of many jobs that are sending and receiving data between many systems.
Faster performance
What do you like best about the product?
The parallel processing of queries and throughput of the query
What do you dislike about the product?
Not support dynamic query executions in snowflake
What problems is the product solving and how is that benefiting you?
Faster datload. Completed dev dataload early in the day helped reporting team to petovide reports business as day starts
Recommendations to others considering the product:
Evaluate it as per your need first. Snowflake can be connected to
Great platform for your DW needs!
What do you like best about the product?
Ease of use, speed and customer service - overall excellent
What do you dislike about the product?
There is nothing I can think of that I dislike about the platform.
What problems is the product solving and how is that benefiting you?
Healthcare insights
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.
showing 291 - 300