My company uses Snowflake Analytics for data lake, data warehouse, data mart, and other related stuff.
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?
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.
Buyer's Guide
Snowflake Analytics
October 2024
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,406 professionals have used our research since 2012.
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.
Buyer's Guide
Snowflake Analytics
October 2024
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,406 professionals have used our research since 2012.
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
Last updated: Mar 8, 2024
Flag as inappropriateDevelopment manager at Amdocs
Highly-recommended, efficient and affordable solution for data processing
Pros and Cons
- "One of the valuable features is the solution’s time travel capability. The solution is highly stable. The solution is highly scalable. The initial setup is straightforward, and the deployment process is quick and efficient. I recommend the solution. Overall, I rate it a perfect ten."
- "The solution’s interface is good but it could be improved."
What is most valuable?
One of the valuable features is the solution’s time travel capability. The loading process exhibits characteristics of low coding for similar loads. Unlike before, where extensive scripting was necessary, Snowflake Analytics simplifies tasks such as file exposure through SQL, a familiar and flexible language for all. Even common commands like the copy command become more straightforward, making coding in this solution more accessible and efficient.
What needs improvement?
The solution’s interface is good but it could be improved.
For how long have I used the solution?
I have worked with the solution for almost three years.
What do I think about the stability of the solution?
The solution is highly stable.
What do I think about the scalability of the solution?
The solution is highly scalable. We cater to enterprise businesses. I rate it a perfect ten.
How was the initial setup?
The initial setup is straightforward, and the deployment process is quick and efficient.
What's my experience with pricing, setup cost, and licensing?
The solution's pricing is affordable.
What other advice do I have?
I recommend the solution. Overall, I rate it a perfect 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: 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
Very flexible and infinitely scalable
Pros and Cons
- "The solution auto-scales and it provides concurrency."
- "Integration into different Python and Jupyter notebooks needs to be improved."
What is our primary use case?
We use the Snowflake platform for analytics and for data integration. We are partners with Snowflake. I'm the managing director.
What is most valuable?
The solution auto-scales and provides concurrency. You can have different virtual warehouses without them impacting each other. It's flexible and infinitely scalable because it's on the cloud.
What needs improvement?
For modeling of data as well as for AI and predictive analytics, they need to improve their integration into different Python and Jupyter notebooks. That is lacking but I understand they're working on it.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
The solution is easily scalable.
How are customer service and support?
Technical support is good, they'll escalate tickets if need be and they'll get engineers on board if that's what's required.
How was the initial setup?
The initial setup is straightforward, just click the button.
What's my experience with pricing, setup cost, and licensing?
The cost depends on the size and on what you're using. I've had customers who spend a million dollars a year and customers that spend $20,000 a year. If you're not using it, it shuts off and you're not paying anything.
What other advice do I have?
I would recommend starting small and growing into it. Don't overbuy. If you're going to get discounts and you're going to buy a block of credits for the year, make sure you need those blocks because you're not going to peak until the second or third year of implementation. It's easier than a traditional environment and allows for focus on the value that can be provided.
I rate this solution 10 out of 10.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Senior Analytics Engineer at TalkDesk
An easy-to-use solution that performs well and provides excellent integrations
Pros and Cons
- "It's not necessary to use a physical server."
- "The UI must be improved."
What is most valuable?
I like the integrations available in the product. We can send the data to our data warehouse if we want to transform it. I like the cloud solution. It's not necessary to use a physical server.
What needs improvement?
The UI must be improved. It would be pretty helpful to have some images showing what we are doing and how we use the tool.
For how long have I used the solution?
I have been using the solution for two years.
What do I think about the stability of the solution?
I rate the tool’s stability a nine out of ten. We don't have any problem with data orchestration or data transformation. It’s pretty good.
What do I think about the scalability of the solution?
I rate the tool’s scalability a nine out of ten. The tool is dedicated to the data team. Around 20 to 30 people use the product in our organization.
Which solution did I use previously and why did I switch?
I have used Redshift and other data warehouses from Google. I used them to extract data in Oracle for 18 years while working in a telecom company. I prefer Snowflake over the others.
How was the initial setup?
The initial setup was a little bit hard. It was especially hard to create a connection with the product team. The product team generated the data, and we had to create some tasks before they were sent to Snowflake. It was difficult because everyone was pretty new to the solution and did not have the necessary knowledge then. The setup was not intuitive. By the end, we understood how to deploy it. The product is deployed on the cloud. The initial deployment took one or two weeks. Later, it takes two or three days to change or update things.
What about the implementation team?
We implemented the product in-house.
What other advice do I have?
Using the product is more about our perception and technical skills in data modeling and querying. If we use it well, the tool runs well more than 90% of the time. It’s easy to use the solution because it has everything that we need. It performs well. People who want to use the solution must create a demo account and try using it. We must optimize our SQL queries. It is helpful to understand the volume of our data before writing codes. Overall, I rate the tool a ten out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Snowflake Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Updated: October 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: