I primarily use Snowflake for hosting and analyzing data. It acts as a data warehouse where data is stored, analyzed, and moved from stage to stage, ultimately exposing it to end users. Additionally, there is an increasing trend in implementing AI capabilities, allowing me to write SQL queries for insights into structured and unstructured data.
Snowflake AI Data Cloud
SnowflakeExternal reviews
676 reviews
from
and
External reviews are not included in the AWS star rating for the product.
A game changer for cloud based data warehousing
What do you like best about the product?
We build a centralised data warehouse on Snowflake to aggregate logistic data from Europe, Asia and North America. We use this setup to power real-time dashboards for our operations and customer service team. One of my favourite feature of Snowflake is its seamless integration with our existing ETL tool like Apache Airflow. The native support for semi structured data like JSON helped us on board external vendor feeds with minimal efforts. What I like best about Snowflake is its easy to use SQL interface and its learning curve is almost negligible for our team.
What do you dislike about the product?
While the implementation overall was smooth, but the cost structure required some time to optimise. Our initial test runs were costlier than expected until we tuned warehouse sizes and auto suspend settings. Additionally, role based access control was a bit complex to configure initially.
What problems is the product solving and how is that benefiting you?
Our team’s daily productivity has gone up and we no more wait hours for batch jobs or struggles with performance bottlenecks. We have also build an automated alerting system using Snowflake which has reduced our manual monitoring efforts by at least 30%.
Snowflake as datawarehouse
What do you like best about the product?
- database itself is by far the most feature rich, includes all analytics, statistics, ML, AI and many more
- enables batch and streaming processing, provides native SCD solution
- very secure by design
- scaleable performance from tiny to huge sandboxes (VPS)
- zero copy cloning db/schema/table enables you to have production env for testing in couple minutes
- enables batch and streaming processing, provides native SCD solution
- very secure by design
- scaleable performance from tiny to huge sandboxes (VPS)
- zero copy cloning db/schema/table enables you to have production env for testing in couple minutes
What do you dislike about the product?
- as any other cloud solution it gets quite expensive if you don't pay attention to proper ELT solution
What problems is the product solving and how is that benefiting you?
company data warehouse runs fully in snowflake, connecting to it via tableau.
Great tool
What do you like best about the product?
Unlimited possibilities with flexible costs
What do you dislike about the product?
It can be much to setup making it can feel overwelming
What problems is the product solving and how is that benefiting you?
Single source of truth, Delta loads
Snowflake Review is a Powerful, Scalable Data Platform for Daily Use
What do you like best about the product?
What I like best about Snowflake is its speed, scalability, and how easy it makes working with complex SQL queries. I deal with layered CTEs, large datasets, and performance analysis daily, and Snowflake handles it smoothly with minimal latency. The ability to scale compute resources on demand is a big advantage—especially when running resource-intensive queries.
What do you dislike about the product?
What I dislike about Snowflake is that while it's powerful, some parts of the user experience and debugging process could be improved.
What problems is the product solving and how is that benefiting you?
Snowflake is solving several key problems related to data scalability, performance, and accessibility, which directly benefits my daily work.
1.) Scalability and Performance
2.) Data Centralization
3.) Secure Data Sharing
4.) No Infrastructure Management
1.) Scalability and Performance
2.) Data Centralization
3.) Secure Data Sharing
4.) No Infrastructure Management
Very efficient and user friendly
What do you like best about the product?
Ease of use and you can integrate with other applications conveniently.
What do you dislike about the product?
I could not think of any features that I dont like. So far so good.
What problems is the product solving and how is that benefiting you?
With help of Snowpark packages I can integrate python with SQL and I can implement data science packages. Which is useful for one of my recommendation project.
Users maximize data management with seamless third-party integration and AI capabilities
What is our primary use case?
What is most valuable?
The independence of the compute and storage within Snowflake is key. The integration with third-party solutions like DBT, Airflow, and Fivetran is highly beneficial. The scalability options it provides, addressing issues without tying workloads into one virtual machine, enhance functionality. The fast pace of delivering new AI features also brings excitement about future possibilities. Further, being able to perform AI and Machine Learning in the same location as the data is quite advantageous.
What needs improvement?
There is a need for a tool to help me estimate the cost of using Snowflake. Enhancements in user experience for data observability and quality checks would be beneficial, as these tasks currently require SQL coding, which might be challenging for some users. It would also help if Snowflake provided clear guidelines on how requests impact warehouse size.
For how long have I used the solution?
I began using Snowflake in 2021.
What do I think about the stability of the solution?
Snowflake as a SaaS offering means that maintenance isn't an issue for me, and I have not experienced any cases where it was down.
What do I think about the scalability of the solution?
While Snowflake provides the ability to scale resources, the expected return on investment is not always achieved. The billing doubles with size increase, but processing does not necessarily speed up accordingly.
How are customer service and support?
The technical support from Snowflake is very good, nice, and efficient. I rate it ten out of ten.
How would you rate customer service and support?
Positive
How was the initial setup?
Setting up Snowflake in 2021 was challenging, especially due to the strong security requirements at the enterprise level. It involved back-and-forth communication with Snowflake and Azure support. However, the documentation has improved over time, which would likely streamline the process now.
What was our ROI?
I assume I achieve a certain level of return on investment, though I am skeptical about the calculations. However, I am generally happy after adopting Snowflake.
What's my experience with pricing, setup cost, and licensing?
It is complicated to understand how requests impact warehouse size. Unlike competitors such as Microsoft and Databricks, Snowflake lacks transparency in estimating resource usage.
Which other solutions did I evaluate?
Snowflake's main competitor is Databricks. Databricks was initially built for big data and machine learning, and then moved to SQL capabilities, while Snowflake followed the opposite trajectory.
What other advice do I have?
New users should not proceed on their own without leveraging the experience of others who have already implemented Snowflake. Establishing a framework for operation and change management is crucial. Define a clear operating model for Snowflake adoption, and start with a small warehouse to adjust as needed. I rate Snowflake a 9.5 out of ten because there is room for expecting further improvements.
Scalable and User-Friendly Cloud Data Platform
What do you like best about the product?
The ability to manage very large data sets, straightforward queries and fast performance. Their integration with powerBI which is our preferred reporting tool is very easy to use also. Their design is quite slick and modern. They also take data security very seriously but also allow for cross team collaboration.
What do you dislike about the product?
It can take some time to familiarise yourself with snowflake when moving from other platforms and the cost of maintenance can tend to increase over time due to the pay per use model.
What problems is the product solving and how is that benefiting you?
We use snowflake to manage very large data sets of in-product usage data that help inform business decisions. The speed at which the system can handle complex queries into such a large dataset has saved a lot of time and improved our teams productivity.
We also use it to merge data from multiple sources to provide a more wholisitic 360 degree view of our customers.
We also use it to merge data from multiple sources to provide a more wholisitic 360 degree view of our customers.
Snowflake as data warehouse
What do you like best about the product?
It does not require to manage infrastructure
Available on AWS, Azure, and Google Cloud, providing multi-cloud flexibility.
Snowflake is parallel processing for fast query execution.
Available on AWS, Azure, and Google Cloud, providing multi-cloud flexibility.
Snowflake is parallel processing for fast query execution.
What do you dislike about the product?
I Think there is no dislikes according to me
at this moment
at this moment
What problems is the product solving and how is that benefiting you?
Snowflake , we can directly connect to other cloud storage buckets esaily.
Snowflake Works with Power BI, Tableau easily
Snowflake Works with Power BI, Tableau easily
Easy enough to use for non-data person.
What do you like best about the product?
Easy to use layout and coding assistance is helpful.
What do you dislike about the product?
For me, who's not really a database person, I can't really find any faults.
What problems is the product solving and how is that benefiting you?
I just needed an easy access to extract data from our data warehouse on a regular basis with minimum customization. After my scripts were set up, it's very easy for me to just use and make minor modifications.
Transformation in data querying speed with good migration capabilities
What is our primary use case?
I started working with Snowflake when I was with Fidelity Investments around 2016-2017. We used Snowflake on AWS cloud because Snowflake doesn’t have an on-premise offering. You need to use it with AWS, Azure, or Google Cloud.
As a consultant now, I assist enterprise customers, though I don't have Snowflake deployments yet.
What is most valuable?
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses. One key feature is the separation of compute and storage, which eliminates storage limitations.
It also has tools for migrating data from legacy databases like Oracle. Its stability and efficiency enhance performance greatly. Tools in the AI/ML marketplace are readily available without needing development.
What needs improvement?
Cost reduction is one area I would like Snowflake to improve. The product is not very cheap, and a reduction in costs would be appreciated.
What do I think about the stability of the solution?
Snowflake is very stable, especially when used with AWS. It works best with AWS compared to Google Cloud and Azure.
What do I think about the scalability of the solution?
Snowflake is very scalable and has a dedicated team constantly improving the product. There are no problems on the scalability side.
How are customer service and support?
Snowflake's technical support is excellent. During my time at Fidelity, I received great support in migrating data to Snowflake, with quick responses and innovative solutions.
How would you rate customer service and support?
Positive
How was the initial setup?
The initial setup was rated six out of ten due to the time required for migrating existing data to Snowflake. Configuration and data migration are major steps involved.
What's my experience with pricing, setup cost, and licensing?
Snowflake's pricing is on the higher side, rated as eight out of ten. If there were ways to reduce costs, it would be a positive improvement.
What other advice do I have?
Snowflake is a great solution if you have substantial data volume. For those considering Snowflake, be prepared for the necessary initial investment in time and resources.
I rate the overall solution nine out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
showing 31 - 40