Snowflake AI Data Cloud
SnowflakeExternal reviews
666 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Simple to use cloud data warehouse
What do you like best about the product?
Having the ability to spin up/down compute on demand is very useful. Traditional ETL patterns no longer need to be followed to get good results. Native JSON support makes dealing with APIs simple and easy.
What do you dislike about the product?
Cumbersome security model is a pain to use but in reality much better for the data warehouse.
What problems is the product solving and how is that benefiting you?
Having the ability to work with billions of rows of structured and unstructured data makes delivering insights much faster and easier.
Recommendations to others considering the product:
Don't expect stored procedures to act like you expect if you are coming from SQL Server, but just use them for what they can do.
lightning fast, no operation cost, simple to deploy
What do you like best about the product?
Snowflake can be up and running in no time. No learning curve if you are regular rdbms user or developer. no dba experience required. You can optimized the cost by monitoring the usage
What do you dislike about the product?
The company still young so there is a lot changes happen
What problems is the product solving and how is that benefiting you?
Building datawarehouse. The benefit is cost and speed to implement
Choosing Snowflake was one of the best decisions our organization
What do you like best about the product?
Great computational power, back ups, ability to change size on demand.
What do you dislike about the product?
The online interface is pretty good, but could use some improvement. I have experienced issues with complex queries that involve multiple joins and have a lot of partitions
What problems is the product solving and how is that benefiting you?
Snowflake is used company wide by analysts and developers. Great performance and role management helped Snowflake's implementation
Simple and invisible
What do you like best about the product?
Snowflake seamlessly blends into our BI stack, is invisible when we need it be, and is available and transparent when required.
What do you dislike about the product?
The language is a little specific, and just different enough from regular SQL/similar.
What problems is the product solving and how is that benefiting you?
Snowflake forms a seamless, consolidating layer between our BI layers, allowing complex analysis, previously very inefficient.
Easy to use, easy with json objects, easy for ETL
What do you like best about the product?
Snowflake lets me load a lot of formats of data and play around with them. It reads anywhere from .gz to .csv and let's me copy specific coloumns' data out.
I actually use it as a replacement for Ms Excel on my Mac. I had taken a python course and instead of using Pandas, I used Snowflake to good effect.
I actually use it as a replacement for Ms Excel on my Mac. I had taken a python course and instead of using Pandas, I used Snowflake to good effect.
What do you dislike about the product?
Snowflake could bring in the support of a procedural SQL like PL/SQL. That would really make it unmatched.
What problems is the product solving and how is that benefiting you?
We are using Snowflake for in house data warehousing and ETL. We run all our analytical and intelligence generation queries on Snowflake and have realized how fast and efficient it is.
Recommendations to others considering the product:
It is wort giving a shot if you are reconsidering your ETL options.
Cloud native Database with exceptional performance and usability!
What do you like best about the product?
There are few things I liked Snowflake -
-Ease of management
-Complete elastic architecture
-Complete separation of compute and storage
-Compute clusters can be managed by end users
-Simple pricing model
-Dynamic scaling on the fly
-Ease of management
-Complete elastic architecture
-Complete separation of compute and storage
-Compute clusters can be managed by end users
-Simple pricing model
-Dynamic scaling on the fly
What do you dislike about the product?
I mostly liked Snowflake compared to other cloud databases and some aspects needs improvements incl. Geospatial functions and additional libraries.
What problems is the product solving and how is that benefiting you?
I'm using Snowflake to house enterprise data platform where all critical insurance related end to end information is stored in the form of real-time dataware house platform. With Lambda-Snowpipe it has been greatly successful to solve business problems. End users are completely hooked to Snowflake functionality due to agility and usability. Since it enables self service cluster management it's even more popular.
Recommendations to others considering the product:
-Experience snowflake for elasticity and scalability. part from that end users liked it more due to features like ease of use, cloning, on-demand cluster management etc. Security is huge plus on how data is protected.
Snowflake is great for performance and low maintenance
What do you like best about the product?
The performance has been great. We have seen 3 to 8 times improvement on query performance.
There has been very low maintenance work such as tuning hardware or system configuration or query plan optimization.
The auto resume and auto shutdown is great for cost savings.
Also, we are using processing semi-structure data like JSON as well.
There has been very low maintenance work such as tuning hardware or system configuration or query plan optimization.
The auto resume and auto shutdown is great for cost savings.
Also, we are using processing semi-structure data like JSON as well.
What do you dislike about the product?
More improvements in on the Stored Proc front.
What problems is the product solving and how is that benefiting you?
Migrating our on-premise MSSQL Server DW to Snowflake. We are improving performance, doing micro batching during the day, increase uptime (meeting SLAs),
Centralizing our data and reducing complexity.
Centralizing our data and reducing complexity.
Recommendations to others considering the product:
Make sure your solution separates compute from storage.
Evaluate how much technical expertise it takes to administer the system (lower is better).
Really look at cost (per second billing, storage, etc)
Evaluate how much technical expertise it takes to administer the system (lower is better).
Really look at cost (per second billing, storage, etc)
Snowflake > Redshift
What do you like best about the product?
- independent, on-demand scaling of compute and storage
- no maintenance / ops (don't have to worry about vacuum, adding nodes, sort / dist keys, weekly maintenance, etc)
- no maintenance / ops (don't have to worry about vacuum, adding nodes, sort / dist keys, weekly maintenance, etc)
What do you dislike about the product?
Because it's a new comer, the ecosystem is not as well established as Redshift (which has been around for over 6 years)
What problems is the product solving and how is that benefiting you?
It serves as our data warehouse and it replaces Redshift. The biggest benefit is just how little time we have to spend on upkeep, and can invest that into building something that's much more impactful
Scalable cloud data warehouse
What do you like best about the product?
Scalability - you can add as many compute nodes as you need to in order to meet your demand. You can also shut them down as needed to save on the cost.
What do you dislike about the product?
Cost and perceived savings of auto shut off. While the concept is awesome, being able to auto shut off is the only way to make Snowflake come even close in terms of cost to Azure data warehouse and AWS redshift.
What problems is the product solving and how is that benefiting you?
Servers as a data warehouse. Since it is a fully managed cloud service, a business doesn't need database administrators to set it up and perform management.
Recommendations to others considering the product:
Evaluate the cost savings of auto shut off. It may not be as worth it compared to other vendors. Also investigate ETL tools that work with. Even though SnowSQL can ingest data, there may be better options.
The DB for bigdata!
What do you like best about the product?
The Snowflake capacity to deal with a really large amount of data, usually faster but if not you can always bump the warehouse size and get results faster, and this all is done within a few clicks and smooth. Very well documented as well and quick support answers when needed.
What do you dislike about the product?
Lack of UI features for operations and debug. Not able to give hints to the compiler. Some updates that cause unexpected issues sometimes.
What problems is the product solving and how is that benefiting you?
Basic ETL queries over a huge amount of data.
Recommendations to others considering the product:
Talking about a software engineer view I definitely suggest you to give it a try. I'll be amazed by speed, features, and easy implementation, I can even run queries from my Sublime editor. The whole team is way more productive by not having to think about the db solution as much as before.
showing 251 - 260