Snowflake AI Data Cloud
SnowflakeExternal reviews
666 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Outstanding performance and stability. Room to improve on support.
What do you like best about the product?
The database is incredibly fast even when using many joins and even with text joins. The functions ROLLUP and CUBE are critical to the way we use Snowflake and those have been unavailable in other systems. Our sales rep Sarah at Snowflake has been wonderful to work with.
What do you dislike about the product?
Support has been working a bug where queries return incorrect results for a while now. This does affect our customers, but the incorrect results cause rows to be shown many times so it's more annoying than it is misinformative. Snowflakes ABSOLUTE REFUSAL to shutdown while overloading it is awesome, but it has caused service interruption on our side due to a bad query hogging all of the resources. Instead of quitting and restarting all processes, Snowflake dutifully worked on churning the data. Good? Bad? I don't know. The query was never going to happen, so we ended up manually having to kill it so all other backed up queries could run. That being said, we are still working on developing our skills with using all of the database tools.
What problems is the product solving and how is that benefiting you?
We use snowflake for the back end of our reporting engine. Midday we will see huge spikes in reporting load and the auto scaling capabilities allow us to get the most out of our money by spinning up more only when it's needed.
Recommendations to others considering the product:
Our previous solution handled building temp tables much better than snowflake does. This was a huge performance drag for us in the beginning so we switched everything we could from building a temp table to either running one larger query or using sub queries. Things are MUCH better now. It also seems like one of the weaker points is moving the data out of Snowflake to the MySQL database or web server. We made some of our own changes to help with this.
Snowflake also offers WAY more management tools than our previous solution did. Make sure you help your DBA get training on these. You can't drive a Ferrari fast if you don't know how to drive stick...
Snowflake also offers WAY more management tools than our previous solution did. Make sure you help your DBA get training on these. You can't drive a Ferrari fast if you don't know how to drive stick...
Amazing solution and great company to work with
What do you like best about the product?
The technology works exactly as described and has been a game changer for us. All of the people that we work with are very customer focused and want to make things work exceptionally well
What do you dislike about the product?
There have been a few outages and we've also encountered some bugs. All of this is par for the course, but of course, we would like to try to minimize and avoid this whereever possible.
What problems is the product solving and how is that benefiting you?
Flexibility, scale and predictability. Since moving to snowflake, we've been able to accelerate the speed of development and analysis. We have far superior capabilities through data sharing, the intuitive web interface and have been able to minimize much of our administrative overhead that we had with our previous solution
Recommendations to others considering the product:
Snowflake has been a game changer in our organization. It addresses so many of the challenges that many traditional solutions have and provides incredible flexibility that will enable a multitude of use-cases. I would strongly suggest that this be one of the top initiatives that you consider and drive.
Snowflake for Big data
What do you like best about the product?
The easy to increase performance power, the separation of database and warehouse.
What do you dislike about the product?
The setup process of snowpipe because it is not easy and confusion. I like copy command setting up process, it is straightforward and easy to maintain
What problems is the product solving and how is that benefiting you?
The SQL Server cannot handle of amount of financial data we have to process on regular basis.
Just works
What do you like best about the product?
No maintenance required, good query performance, good SQL support and features, super easy to scale, reliable so far. Data cloning and sharing is unique and awesome and fits our use case perfectly.
What do you dislike about the product?
Some bugs in the Python connector, some query errors for complex queries, can get pricy if high concurrency is required. Permission management differs from MySQL. We only had a single service outage so far.
What problems is the product solving and how is that benefiting you?
We are building a data warehouse on Snowflake, we have eliminated database maintenance costs and greatly reduced TCO. Query performance has greatly improved.
Recommendations to others considering the product:
Give it a try, rely on the community.
The new generation Big Data Platform
What do you like best about the product?
The performance, its support for semi-structured data and the Acid back-bone. It is like having Hadoop with Transactions and fine role-base security. Data Sharing is also new to the database world. We can now share any data with our Clients without additional burden.
What do you dislike about the product?
It would be nice to be able to self-manage the fail-safe. For instance tables from the fail-safe should be removed explicitely so no storage is vasted.
What problems is the product solving and how is that benefiting you?
Big Data Healthcare Analytics
Recommendations to others considering the product:
Lean how to monitor and handle the costs. You need to do that actively as the easy to use and its flexibility can increase costs quite rapidly.
Performant, Secure, and Scalable Cloud-based Data Warehouse
What do you like best about the product?
Snowflake is easy to set up and use. It provides a lot of flexibility in terms of performance and cost efficiency by its ability to scale clusters up and down in an instant. Snowflake's best feature though, in my opinion, has to be "time travel". Time travel is a concept of deriving data from any given point in time. Snowflake also has a "share" functionality, which allows us to share data across the company with ease. Snowflake's capability to clone has also helped us in our testing efforts.
What do you dislike about the product?
There's not much to be said here. Snowflake was one of the most flexible and scalable warehouse options we found in the market when researching for a cloud-based data warehouse.
What problems is the product solving and how is that benefiting you?
Snowflake allowed us to centralize most (if not all) of our data sources into a theoretical single space, which made reporting to our clients easier. Snowflake allows us to easily join data across various data sources within one single space.
Delivers on everything promised
What do you like best about the product?
The snapshot capabilities. The ability to take snapshots quickly so that we can work with a copy of the data
What do you dislike about the product?
The security model can be a bit tedious.
What problems is the product solving and how is that benefiting you?
Snowflake is helping us to scale our data business in a cost efficient manner.
Recommendations to others considering the product:
If you need the ability to scale up and down quickly, then this is your solution.
Lead Data Engineer
What do you like best about the product?
first: the fast compute and unlimited storage. second: the connection to AWS S3. third: the snow pipeline.
What do you dislike about the product?
Query GUI, it will be nice to have all the features like the generic query analyzer, example: DB VISUAL
What problems is the product solving and how is that benefiting you?
Big data for analytics
Connection to AWS S3
Connection to AWS S3
Recommendations to others considering the product:
this is the product to choose for a big data solution
Snowflake has been amazing for our company
What do you like best about the product?
Probably my favorite thing is how we can spin up the size of Snowflake for our ETL loads and derived tables builds throughout the day.
What do you dislike about the product?
I think what we struggle the most with is applying security roles to all schemas, databases and tables. Snowflake does have robust security but it does take some time to set up.
What problems is the product solving and how is that benefiting you?
We are able to get our important reports out much sooner each day than when we are on Redshift.
Recommendations to others considering the product:
Do a POC to see just how much better Snowflake is if you are struggling with your current database.
Great onboarding and service
What do you like best about the product?
Very fast onboarding - very proactive Sales/Technical account assistance
What do you dislike about the product?
Somewhat lack of technical tools to load data in Snowflake. Community is still somewhat young
What problems is the product solving and how is that benefiting you?
Analyzing large amounts of consumption SVOD data. Able to run really quick queries and build large data backends for our Tableau reports
showing 281 - 290