Snowflake AI Data Cloud
SnowflakeExternal reviews
666 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Snowflake review
What do you like best about the product?
computation and storage are decoupled so we can keeping on adding storage without adding unnecessary computing power
What do you dislike about the product?
AD group are not fully supported. We have to manually manage user groups locally
What problems is the product solving and how is that benefiting you?
DW is hijacked by some heavy SQL queries, which makes DW performing worse for other users.
We can see clear benefits
We can see clear benefits
High quality, cloud-scale database platform
What do you like best about the product?
Our model is to share access to various portions of an analytics warehouse in a multi-tenant, multi-cloud environment. Snowflake has been tremendously easy to implement and configure to support our model. Customer provisioning is straightforward and cost per customer metrics are easy to collect. Managing the per-tenant shares is a piece of cake.
What do you dislike about the product?
One current snag in the customer onboarding model for us is that there is a manual finalization step on Snowflake's side for setting up a new customer reader link to our primary account. This is a one-time step per customer that can be performed ahead of time, so it's not a crisis, but having this be fully automated would be a huge win for us.
What problems is the product solving and how is that benefiting you?
Isolating views and access for customers to a central analytics platform while being able to measure and control costs on a per-customer basis
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.
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
showing 281 - 290