Snowflake AI Data Cloud
SnowflakeExternal reviews
721 reviews
from
and
External reviews are not included in the AWS star rating for the product.
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
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
showing 321 - 330