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
666 reviews
from
and
External reviews are not included in the AWS star rating for the product.
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)
Snowflake - Easy and Best Cloud DWH
What do you like best about the product?
The best thing that I like about Snowflake is that we can create number of database,and the feature to include AI in that really help us to integrate and make our work process easier and its very easy in implementation
What do you dislike about the product?
Sometime the query performace and the new UI feature.
What problems is the product solving and how is that benefiting you?
We were having different data sources and we can integarate all these in different Databases with different user access and its benefiting me in different ways like having different roles for same users and Credits consumption can also be tracked
The best data storage solution
What do you like best about the product?
The ease of infrastructure and data querying
What do you dislike about the product?
UI can be better and can trace the path of other cloud providers
What problems is the product solving and how is that benefiting you?
We use snowflake for variety of reasons. mainy ML nowadays. Many clients have their data in snowflake.
One of the best Data warehousing tool for your ETL needs!
What do you like best about the product?
- Simple and Modern UI.
- User management and Provisioning is much simpler once you implment the Single sign on with provisioning functionality.
- Roles and permission management is straight forward, snowflake has detailed documents for priviledges syntex etc.
- Manging databases, schema and it's objects is a breeze (be it via worksheet or via snowflake UI).
- Setting up resource monitor helps a lot to track your credits consumption and get alerts for exhausting credit quota depending on the alerts that you set.
- Dashboard and budget functionality is also there, by which getting insights of credit usage by warehouse, by role, etc. all details are easily available.
-Snowflake supports various Warehouse sizes from Xsmall to 4XL to support you ETL needs, with auto pause and clustering features.
- User management and Provisioning is much simpler once you implment the Single sign on with provisioning functionality.
- Roles and permission management is straight forward, snowflake has detailed documents for priviledges syntex etc.
- Manging databases, schema and it's objects is a breeze (be it via worksheet or via snowflake UI).
- Setting up resource monitor helps a lot to track your credits consumption and get alerts for exhausting credit quota depending on the alerts that you set.
- Dashboard and budget functionality is also there, by which getting insights of credit usage by warehouse, by role, etc. all details are easily available.
-Snowflake supports various Warehouse sizes from Xsmall to 4XL to support you ETL needs, with auto pause and clustering features.
What do you dislike about the product?
As of now everything is working fine and nothing that I dislike as of now.
What problems is the product solving and how is that benefiting you?
Snowflake is solving the ETL needs for our data warehousing solutions, while simplfying the Administration work.
Snowflake Review
What do you like best about the product?
How accessible it is to get data using SQL
What do you dislike about the product?
The interface is not as pretty as periscope
What problems is the product solving and how is that benefiting you?
Storing data, giving access to data
Snowflake - Your life saver
What do you like best about the product?
The Time Travel feature of Snowflake, I love the most.
What do you dislike about the product?
It's hard at first, but when you learn to use it is really easy. I use it daily.
What problems is the product solving and how is that benefiting you?
We are using it to store all kinds of files in Data Lake. It is helping us store, manage, analyse and use data, data bases and connect to different applications on daily basis.
showing 31 - 40