Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
Fast and efficient DB
What do you like best about the product?
That's the fastest and the most agile DB I ever worked with. I also deeply appreciate scale-ability as you can always throw in more computational power if you need so without any hassle
What do you dislike about the product?
Some queries are not optimized as you'd expect them to be, that leads to you writing some workarounds which work "kind of" the way you wanted them to be. Sometimes support team resolves problems, but sometimes they reply something like "it's the way it works, deal with it". I also wish the query details\profile screen was easier accessible from worksheets: the UI is sort of slow in switching from worksheet to query details and if you do that as one off - it's not a biggie, but as you do it more often - that becomes a hassle as UI getting laggy and works slow.
What problems is the product solving and how is that benefiting you?
Big data analysis and pre-computations, kpis became easier with Snowflake. We were able to achieve our tasks of serving data in the way our customers need, with all metrics they need fast enough so they are happy
Recommendations to others considering the product:
Be careful about not using lots of partitions: use clustering, make your queries to skip partitions as early as possible if they don't qualify to make their way in the end result. All in all for me it's like Elastic Search in the DB world: very powerful and agile, easy to tailor to your needs, but you should be careful with the conditions and how you write your queries
- Leave a Comment |
- Mark review as helpful
Great simple interface where it's easy to add the right resources for the job
What do you like best about the product?
Very clear UI.
Easy to resize resources to get the job done
Python connector works great
Easy to resize resources to get the job done
Python connector works great
What do you dislike about the product?
Pretty inefficient with very wide tables and with INSERT statements
Not 100% stable; things hang or shut down periodically
Not 100% stable; things hang or shut down periodically
What problems is the product solving and how is that benefiting you?
Great for customer and business research with a very large dataset
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.
Data Solution that's fast and simple
What do you like best about the product?
I like the speed at which you can accomplish a task that is assigned to you by using the variety of tools provided by Snowflake.
What do you dislike about the product?
I only dislike the fact that tables with constraints are not enforced particularly with a primary key.
What problems is the product solving and how is that benefiting you?
We are solving Data Visualization problems and Snowflake excels at this due to its speed. The viz needs to interact with the underlying data table very quickly and we had great success with Snowflake.
We are also solving ETL pipelines. We have seen Snowflake churn through TB's of data in a couple minutes which is pretty awesome and not possible with any other solution to date.
We are also solving ETL pipelines. We have seen Snowflake churn through TB's of data in a couple minutes which is pretty awesome and not possible with any other solution to date.
Recommendations to others considering the product:
If you are looking for a fast, reliable, and easy to use data solution. I would look no further than Snowflake. Faster than Vertica, Hive, and Presto. Well balanced pricing plans and outstanding support.
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
As good as they say they are
What do you like best about the product?
I like that Snowflake uses a mix of novel solutions and tried and true foundations to deliver a product that they say they deliver. The main thing is the ease of use, and the speed of use.
What do you dislike about the product?
I guess my only critique would be that I didn't fully understand how it worked when we first started using it and therefore was not able to use it to it's full power. Maybe I wasn't privy to those convos?
What problems is the product solving and how is that benefiting you?
We are solving major ETL problems and data governance/organizational issues. In addition we are able to make apps work faster than we ever could have otherwise.
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.
Love Snowflake Customer Experience
What do you like best about the product?
I love that t he CX team is so prompt and efficient
What do you dislike about the product?
Its a little complicated to use. I would love a video tutorial
What problems is the product solving and how is that benefiting you?
Using it as a data warehouse
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.
showing 411 - 420