External reviews
636 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Great noops db
What do you like best about the product?
Separate compute and storage for easy workload management. Don't have to think about distribution strategies or indexes. It's fast. For such a young database, I'm impressed by the feature support.
What do you dislike about the product?
Hands down not being able to load json into a regular table. I HATE how you need to insert json into a one column type variant table then flatten out. This should be natively supported imo.
What problems is the product solving and how is that benefiting you?
Different workloads for different use cases. We demo our product with data served from Snowflake; I love how I can allocate a bunch of resources to that specific use case.
Recommendations to others considering the product:
If cost is a consideration, check out the auto suspend feature for warehouses. If you are only getting queries during certain parts of the day, you can have snowflake shut down compute resources after a given amount of inactivity to save on cost.
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
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.
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
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
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.
showing 101 - 110