I primarily use it in the realm of machine learning products and general data analytics.
Incredibly user-friendly and requires minimal maintenance
Pros and Cons
- "It is an all-in-one platform that provides the capabilities needed for various analytics tasks, including data warehousing for machine learning."
- "One area that could benefit from enhancement is the user interface for more visual ESM features."
What is our primary use case?
What is most valuable?
What I find most valuable about Snowflake is that it is an all-in-one platform that provides the capabilities needed for various analytics tasks, including data warehousing for machine learning. It is incredibly user-friendly and requires minimal maintenance, making it a convenient choice for handling data analytics and machine learning workloads efficiently.
What needs improvement?
One area that could benefit from enhancement is the user interface for more visual ESM features. Improving the visual representation of security components, like boxes and links, could make it easier to understand and manage security aspects within the platform.
For how long have I used the solution?
I have been using Snowflake Analytics for three years.
Buyer's Guide
Snowflake Analytics
November 2024
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
824,053 professionals have used our research since 2012.
What do I think about the stability of the solution?
It is a quite stable solution. I would rate it as a ten out of ten for stability.
What do I think about the scalability of the solution?
Snowflake is scalable, but its limits are connected to the cloud resources it uses. These cloud resources can restrict how much data you can handle and store, affecting the extent of scalability. I would rate it as a ten out of ten for scalability.
How are customer service and support?
I find Snowflake's technical support to be highly responsive. They are exceptionally quick to address issues, especially when they are critical, with response times typically less than thirteen minutes. I would rate the support as a nine out of ten.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
How was the initial setup?
Snowflake is a fully cloud-based service that doesn't require installation or complex configuration. It is an online platform where you define parameters and create users, tables, and objects without the need for extensive maintenance or operational tasks. Setting up Snowflake is typically a quick process, taking just a matter of minutes to prepare for use.
What was our ROI?
Snowflake can save a considerable amount of time, with potential time savings often reaching 50% or more for various data-related tasks. However, the exact percentage depends on the specific tasks and data complexity, so it can vary.
What's my experience with pricing, setup cost, and licensing?
Snowflake offers a pay-as-you-go pricing model among other options. It is an affordable solution. I would give it a nine out of ten in terms of affordability.
What other advice do I have?
Overall, I would rate Snowflake Analytics as a ten out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer:
Data Engineer at Imriel
Scale resources flexibly while managing large datasets and improved cost savings
Pros and Cons
- "Its structure aids in storing, managing, and analyzing large datasets in the cloud, using various relationships like one-to-one and many-to-one, ensuring consistency in the data structure."
- "Improvements are needed in importing and exporting large datasets to and from reporting tools."
What is our primary use case?
We use Snowflake Analytics for programs where we write stored procedures which are imported into tables and later used for generating reports via reporting tools.
What is most valuable?
Snowflake Analytics is flexible in nature, allowing for the addition of more data tables without affecting the main structure. It supports scalability by enabling the scaling of resources up and down depending on demand, which is facilitated through cloud computing platforms.
Snowflake also helps in improving cost savings. Its structure aids in storing, managing, and analyzing large datasets in the cloud, using various relationships like one-to-one and many-to-one, ensuring consistency in the data structure.
What needs improvement?
Improvements are needed in importing and exporting large datasets to and from reporting tools. A better recording system for tracking changes to the data structure, including user IDs and timestamps, is needed for increased transparency.
For how long have I used the solution?
I have used Snowflake Analytics for one year.
What do I think about the stability of the solution?
During the development stage, there were many maintenance issues, however, these were minimized over time.
What do I think about the scalability of the solution?
Snowflake Analytics is highly scalable as data can be added to the structure without necessitating comprehensive changes. It handles scaling effectively, particularly in a cloud-based environment.
How are customer service and support?
We did not need to escalate many questions to tech support compared to other tools, indicating minimal reliance on Snowflake's tech support.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
I have experience with AWS as a cloud data warehouse.
How was the initial setup?
The initial setup involved creating a Snowflake account and installing the ODBC driver, taking a couple of days. Moving from development to production took 24 continuous hours.
What about the implementation team?
Four people were involved, with a lead taking charge, while I supported the task.
What was our ROI?
By using clones, we allowed multiple teams to work simultaneously on data without affecting the main dataset. This saved time and maintained consistency, though I am not sure about the financial aspects.
What's my experience with pricing, setup cost, and licensing?
The project managers handled pricing. We minimized time requirements by using indexes and constraints. Clones and servers were used efficiently to address cost issues.
Which other solutions did I evaluate?
What other advice do I have?
Snowflake requires skilled developers, unlike other tools. It is suitable for managing large, structured, and analyzable datasets.
I would rate Snowflake eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Dec 3, 2024
Flag as inappropriateBuyer's Guide
Snowflake Analytics
November 2024
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
824,053 professionals have used our research since 2012.
Assistant Manager Operations at Tech Mahindra Limited
A solution that is fast at work and easy to deploy with a need to consider making its prices more affordable
Pros and Cons
- "Features like the fact that the solution is very fast and available on the cloud are some of the valuable attributes of the solution."
- "The solution's high price can be an area of concern that needs improvement."
What is our primary use case?
My company uses Snowflake Analytics for data lake, data warehouse, data mart, and other related stuff.
What is most valuable?
Features like the fact that the solution is very fast and available on the cloud are some of the valuable attributes of the solution.
What needs improvement?
We are satisfied with the solution since Snowflake brings in a lot of new features now and then.
The solution's high price can be an area of concern that needs improvement.
For how long have I used the solution?
I have been using Snowflake Analytics for four years. My company has a partnership with Snowflake Analytics. I am using the solution's latest version.
What do I think about the scalability of the solution?
Scalability-wise, I rate the solution a nine out of ten.
Around 50 users use the solution in my company.
Our company's clients consist of medium and enterprise-sized businesses.
How are customer service and support?
The support provided by Snowflake is fine since they are fast and helpful. I rate the technical support an eight out of ten.
How would you rate customer service and support?
Positive
How was the initial setup?
I rate the setup phase a nine or ten on a scale of one to ten, where one is difficult and ten is easy. The solution's setup phase was easy.
The solution is deployed on the cloud.
The deployment time taken for the solution was six months.
There was nothing much involved in the deployment process. The deployment process involved just exporting the base objects.
What's my experience with pricing, setup cost, and licensing?
On a scale of one to ten, where one is a low price, and ten is a high price, I rate the pricing a seven. The solution's pricing is high.
There are no costs in addition to its standard licensing price.
What other advice do I have?
After considering the pricing part of the solution, those planning to use it can start using it. The pricing of the solution falls on the higher side. Feature-wise, the solution is really good. If a company can afford the tool, the solution is good in its category.
Overall, I rate the solution a seven out of ten.
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
Data storage and management solution that requires no maintenance and offers easy integration with other systems
Pros and Cons
- "The advanced features like time travel, zero copy cloning and scalability have been most useful. Snowflake requires zero maintenance for Data Warehousing on the cloud system."
- "Moving data from legacy systems to Snowflake is not that easy. There are some cases where processors are not actually compatible with Snowflake."
What is our primary use case?
We use this solution to move on-prem data to a cloud data warehouse where we have a requirement for more computation storage or when we need a plugin to work with specific technologies like ML, AI and Data Science.
What is most valuable?
The advanced features like time travel, zero copy cloning and scalability have been most useful. Snowflake requires zero maintenance for Data Warehousing on the cloud system. It is more secure compared to any other data platforms that we have used. The tri secret key is the feature that gives a lot of confidence to customers.
What needs improvement?
Moving data from legacy systems to Snowflake is not that easy. There are some cases where processors are not actually compatible with Snowflake. If Snowflake could offer compatible versions of other legacy system objects, that would be more convenient for anyone to move to Snowflake.
When comparing MySQL with Snowflake, MySQL is faster in executing the complex queries compared to Snowflake. This is the only factor where Snowflake lags behind competitors in the market.
For how long have I used the solution?
I have been using this solution for four and a half years.
What do I think about the scalability of the solution?
This is a scalable solution.
How are customer service and support?
The customer service and support for this solution is good. We had previously failed to retrieve data after the time travel period. We had to raise a ticket with technical support team and they helped us. They charged us for this but were able to help us retrieve it.
How would you rate customer service and support?
Positive
How was the initial setup?
The initial setup is straightforward. The beauty of Snowflake is that you can select the configuration you need. For example, if you have a requirement of a one terabyte load with high availability and 10 users, Snowflake will set it up for you to match these requirements.
What was our ROI?
The ROI you receive using this solution depends on your use case and if you are starting from scratch or migrating from a legacy system. We have experienced a 40 to 50% improvement in ROI compared to legacy systems.
What's my experience with pricing, setup cost, and licensing?
When using Snowflake, you pay based on your usage. They calculate how much CPU has been used. If you use excess warehouse storage, you are charged one credit per hour. If you are in Asia, you are charged $3 per credit. If you have 10 users running parallel with the same excess, you will be charged $30.
Pricing for storage is calculated in the same way. You will pay upfront for the storage that you know you will need to consume. There is this option of prepaid consumption as well as post paid consumption. If you pay upfront, you will charged $20 per hour, per terabyte. If you paying after use, you will be charged $40 per terabyte.
What other advice do I have?
There is close to zero maintenance required for this solution.
You don't need to use traditional warehouses, vacuuming or indexing. A database administrator or system admin is not required.
I would rate this solution a nine out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Analyst at Wespath Benefits and Investments
Intuitive solution that provides variety of tools for performing advanced analytics
Pros and Cons
- "It ensures the optimization of the application development while maintaining the user-friendly nature of its UI."
- "Machine learning should be improved."
What is our primary use case?
We use it for our full application operational analytics, including building, storing, and analyzing the data. It provides us with detailed insight, making it easy to extract needed reports. Everything related to business intelligence, whether it's reporting or analytical modules, is stored on the Snowflake Analytics platform.
What is most valuable?
It's an intuitive platform that allows organizations to rapidly adapt, providing the ability to quickly analyze and make data-driven decisions. It ensures the optimization of the application development while maintaining the user-friendly nature of its UI.
What needs improvement?
Machine learning should be improved. Some of the solutions, such as Databricks, offer an option to directly write and integrate Python code on the spot, but Snowflake doesn't have that feature yet. Adding it would be useful, as it would facilitate building models.
For how long have I used the solution?
I have been working with Snowflake Analytics for a year.
What do I think about the stability of the solution?
It is a stable platform.
What do I think about the scalability of the solution?
It offers good scalability.
How are customer service and support?
I am highly satisfied with their level of customer service and support. I would rate it nine out of ten.
How would you rate customer service and support?
Positive
How was the initial setup?
The initial setup was done seamlessly.
What about the implementation team?
There was no requirement for installation. They provided us with a link, giving us access to the cloud.
What's my experience with pricing, setup cost, and licensing?
It is an expensive solution, but the kind of usability and flexibility it proactively provides for the organizations justify the price.
What other advice do I have?
Snowflake Analytics is a really good choice for organizations that are looking at a cloud analytics platform for reporting, data modeling, and advanced analytics without machine learning requirements.
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?
Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data engineer at Esprit
A robust, quick, and easy-to-use solution that can analyze a huge amount of data
Pros and Cons
- "It's a scalable solution because you can analyze a huge amount of data in the solution."
- "The solution needs to consider including some updates in the future."
What is our primary use case?
Using Snowflake, I can say it is built as a robust solution. Also, its analytical functioning is really quick.
What is most valuable?
Using Snowflake to load data from different sources is a valuable feature of the solution.
What needs improvement?
The solution needs to consider including some updates in the future. There is a need to add some new features to the solution to facilitate my work with Snowflake.
For how long have I used the solution?
I have been using Snowflake Analytics for a year and two months. I'm using it because I'm a data engineer, and so I am a customer of Snowflake.
What do I think about the stability of the solution?
In my experience, I didn't face any crashes or anything related to data. So I think it's stable.
What do I think about the scalability of the solution?
It's a scalable solution because you can analyze a huge amount of data in the solution. In my company, around ten developers are using the solution.
How was the initial setup?
The initial setup is easy because it is a cloud solution. So you don't need to install anything. You can just connect to your account and write SQL queries or write the procedures. So you can manipulate it on the website directly, and also it's user-friendly.
What's my experience with pricing, setup cost, and licensing?
The solution has some gold and premium plans, which I read in its documentation.
What other advice do I have?
I would tell others to use the solution if it is available for them on the cloud since I think it's very easy to manipulate data and work with it. Also, it is not very difficult because it is based on SQL queries, JavaScript, and Python.
Overall, I rate the solution an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Vice President --Analytics & Digital Transformation at Polestar Solutions & Services India Pvt Ltd
Comes with a simple learning curve, making it easy to understand and learn for users
Pros and Cons
- "Scalability-wise, I rate the solution a ten out of ten."
- "The product's cost is an area of concern where improvements are required."
What is our primary use case?
I use the solution in my company for the real estate and housing industry. The tool is also used in the CPG industry.
How has it helped my organization?
The benefits that my company has experienced from the use of the product stem from the fact that it is easy to maintain the platform. The most important part about the product is that it is designed with the help of SQL, so users need not have a specific skill set to run the product. Any person with knowledge of SQL can easily use the product.
What is most valuable?
The most significant feature of the product that has an impact on data analytics stems from the fact that the tool offers functionalities to help users with data warehousing and AI features. The features of the product are available in such a way that there is a separation in the nature of the computation and storage part the tool offers, making the overall tool very fast. The product is easy to use since it uses SQL or structured query language. Most of the people or technicians in the market are comfortable with SQL or structured query language, making it a tool that is easy to use and understand since it is easy to learn about the solution. Developers or programmers with knowledge of SQL can easily move to Snowflake Analytics, as the product comes with a simple learning curve.
What needs improvement?
The tool needs to introduce a desktop client so that users can handle the design part, as it is one area where the product lacks and needs to improve. Instead of having to visit the product's web portal, the tool should be installed on a desktop client through which users can indulge in the development process on their local systems.
The product's cost is an area of concern where improvements are required. One part of the cost is attached to the product, and the other part is attached to the solution provider. There should be more transparency provided to users, stating which costs are attached to the product and the prices managed by the solution provider.
For how long have I used the solution?
I have experience with Snowflake Analytics for five years. My company has implemented the product for some of our clients.
What do I think about the stability of the solution?
Stability-wise, I rate the solution a nine out of ten.
A lot of features are offered under different tools from Snowflake Analytics. Recently, the product has started to use Python language, along with other languages like SQL. Users need to rely on and use the cloud to carry on with the development phase attached to the solution.
What do I think about the scalability of the solution?
Snowflake Analytics offers the same amount of scalability as the other solutions in the market because it is a tool that is available on the cloud. Scalability-wise, I rate the solution a ten out of ten.
My company deals with around six to seven customers of the product.
I would say that around 100 people use the tool.
How are customer service and support?
There is a different team in my company that connects with the solution's technical support.
How was the initial setup?
The product's initial setup phase is easy in the areas of development and implementation.
The product's deployment phase needs users to follow the standard procedures used under the CI/CD deployment process. You can design it with the help of the CI/CD deployment process. The deployment process is simple.
The solution is deployed on the cloud.
What's my experience with pricing, setup cost, and licensing?
The product's licensing cost varies depending on the models and different structures offered by the solution. I feel that the cost of the product is fine. I rate the product's licensing cost a five or six on a scale of one to ten, where one is low price, and ten is high price.
What other advice do I have?
The product is useful in areas like data warehouse and data analytics since such functionalities of the tool are widely used by my company's clients.
Considering the ease of use that the product provides to support my company's teams' daily operations, I would say that the tool offers help in the area of projects and support.
The product handles data security and compliance areas by providing high security as the tool offers container services, making it highly secure for users during data sharing. The users can have permission authority, without which others cannot see the data that is highly secured within the container.
I recommend the product to those who plan to use it.
The product is easy to scale out. The solution is available on the cloud, and its basic development nature falls under the SQL side, which is something that makes it favorable for development teams across the world. It is easy to learn about the product and start working on it, meaning it has a simple learning curve.
I rate the overall tool a nine out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
A scalable and stable solution that helps to generate insights
Pros and Cons
- "I am impressed with the product's data-sharing feature."
- "The tool should support EIM use cases. I guess the product is already working on it. I look forward to seeing inbuilt AI generative tools in the solution's future releases. The tool's price can be a little lower. The solution's on-premises support is also very limited. We have to rely on other support services to deploy it on-premises."
What is our primary use case?
We use the product to generate insights.
What is most valuable?
I am impressed with the product's data-sharing feature.
What needs improvement?
The tool should support EIM use cases. I guess the product is already working on it. I look forward to seeing inbuilt AI generative tools in the solution's future releases. The tool's price can be a little lower. The solution's on-premises support is also very limited. We have to rely on other support services to deploy it on-premises.
For how long have I used the solution?
I have been working with the solution for four years.
What do I think about the stability of the solution?
I would rate the product's stability a nine out of ten since it is stable and reliable.
What do I think about the scalability of the solution?
I would rate the tool's scalability a nine out of ten. My company has more than 1000 users for the tool.
How are customer service and support?
The solution's support responds fast.
How would you rate customer service and support?
Positive
How was the initial setup?
I would rate the solution's setup a nine out of ten. Being a SaaS product, the setup is straightforward. The solution's setup becomes complex only when you need to create a specific cloud platform which is virtual or public. If you have a CI/CD pipeline ready, then deployment can be automated. The tool's deployment doesn't take more than a day to complete.
What's my experience with pricing, setup cost, and licensing?
The solution's price is high and I would rate it an eight out of ten.
What other advice do I have?
I would rate it an eight out of ten. The solution is very easy to use. The tool is a SaaS product. You can leverage your overall data analytics strategy with the solution. It has a lot of features and you shouldn't consider it for data storage alone. In the future, we will be able to leverage the solution of ML-oriented used cases as well.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
Buyer's Guide
Download our free Snowflake Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Popular Comparisons
Amplitude
Adobe Analytics
Mixpanel
Glassbox
Buyer's Guide
Download our free Snowflake Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions: