Try our new research platform with insights from 80,000+ expert users
Jayanta Datta - PeerSpot reviewer
Executive Director at Morgan Stanley
Real User
High availability, performs well, and helpful support
Pros and Cons
  • "The most valuable feature of Snowflake Analytics is its performance."
  • "Snowflake Analytics can improve the integration with machine learning tools and AI and it will make the solution more usable."

What is our primary use case?

Snowflake Analytics is used for data warehousing, reporting, and analytics. 

What is most valuable?

The most valuable feature of Snowflake Analytics is its performance.

What needs improvement?

Snowflake Analytics can improve the integration with machine learning tools and AI and it will make the solution more usable.

In a future release of Snowflake Analytics, transactional processing should be supported natively within the solution. The transactional process means, for example, you go to a bank, you draw money, you deposit money. These are all real-time transactions. Thousands or millions of people who draw money and deposit money participate in using transactional systems, such as ATM withdrawals. We want this to be supported by the Snowflake system.

For how long have I used the solution?

I have been using Snowflake Analytics for approximately five years.

Buyer's Guide
Snowflake Analytics
May 2025
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.

What do I think about the stability of the solution?

Snowflake Analytics has high availability.

What do I think about the scalability of the solution?

The scalability of Snowflake Analytics is excellent.

We have approximately 1,000 users using this solution.

How are customer service and support?

The technical support from Snowflake Analytics is outstanding.

How was the initial setup?

The initial setup of Snowflake Analytics is easy. It took three to six months to do the entire deployment.

I rate the initial setup of Snowflake Analytics an eight out of ten.

What about the implementation team?

There are 10 to 15 people required for the implementation of Snowflake Analytics. We did the implementation ourselves.

We use two to three people that support the solution. However, we have full support from Snowflake.

What's my experience with pricing, setup cost, and licensing?

The cost of Snowflake Analytics is low, any small organization can use it.

I rate the price of Snowflake Analytics a four out of five.

What other advice do I have?

I can advise using Snowflake Analytics only if you have your analytical use case or data warehousing need, where you have large data volumes. The use of Snowflake Analytics with smaller volumes and for transactional systems will not help organizations at this point in time.

I rate Snowflake Analytics a 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?

Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Javed Chowdhary - PeerSpot reviewer
Lead Software Engineer - Data Cloud at Mastercard
Real User
Top 10
Serves as a cost-saving tool and offers good performance
Pros and Cons
  • "Snowflake Analytics is pretty easy to use with the connectors for integration with the tools and systems in my company."
  • "Snowflake's Snowpark is an area of concern where improvements are required."

What is our primary use case?

I use the tool for data warehousing, analytics, and machine learning.

What is most valuable?

The most valuable feature of the solution Stems from the fact that the tool offers a virtual warehouse along with multiple other features.

What needs improvement?

Snowflake's Snowpark is an area of concern where improvements are required. Snowflake's Snowpark is a pretty new concept. Snowflake's Snowpark should improve my adding new libraries and getting the codes deployed quickly.

For how long have I used the solution?

I have been using Snowflake Analytics for more than five years. I am an end user of the product. I am also a developer who builds platforms for others with the help of Snowflake Analytics. There is no version of the product in general, as it is a full-fledged product.

What do I think about the stability of the solution?

It is a stable solution. Stability-wise, I rate the solution a ten out of ten.

What do I think about the scalability of the solution?

The scalability of the product is pretty good. It is a highly scalable product. I rate the product's scalability a nine out of ten. Users can scale up or scale out the solution.

I use the solution daily in my company.

Presently, there aren't many uses of the solution in my company. In the future, I believe that the number of users of the product in my company will increase.

How are customer service and support?

My company is in contact with a technical person from Snowflake Analytics, who helps us. I rate the technical support a seven or eight out of ten.

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

I have experience with Oracle, Microsoft SQL Server, and AWS.

My company started to use Snowflake Analytics since we did not want to have an on-premises product. Snowflake Analytics was also cost-effective for our company.

How was the initial setup?

I rate the product's initial setup phase an eight or nine on a scale of one to ten, where one is a difficult process, and ten is an easy process. The setup process is straightforward.

The deployment requires users to have an account, and since it is a SaaS solution, Snowflake Analytics manages all the Infrastructures based on which the tool provides the user login details. The user creation is also pretty smooth with the product, so a user can start using it quickly.

The solution is deployed on the cloud services offered by AWS.

The solution can be deployed in a week, along with the licensing part.

For the deployment of the product, one architect from Snowflake, one person from AWS, and two admin developers, are required.

What about the implementation team?

For my current project, a third-party involvement was there in the installation phase of the product. Previously, I was involved in the product's installation process, which involved the licensing part and setting up of the environment.

What's my experience with pricing, setup cost, and licensing?

I rate the product price a seven on a scale of one to ten, where one is low price, and ten is high price. There are some additional costs based on the number of users or data warehouses.

Which other solutions did I evaluate?

Against Snowflake Analytics, my company has an option called Databricks. For our company's primary use cases, we prefer Snowflake Analytics.

What other advice do I have?

Snowflake Analytics has supported our company's data warehousing and analytics part by helping us reduce our overall costs involved in such areas. The product also offers a better performance than the on-premises tools that are available.

Snowflake Analytics has improved our company's data-driven decision-making processes since the go-to-market timeline has been reduced with the use of the product. Earlier, the go-to-market timeline was such that my company used to take over a month to get new data for the end users. My company can get the data within a week or before, allowing users to use it for their analytics. The tool has reduced the go-to-market timeline.

The benefits from the product's scalability and performance features stem from the fact that it helps with the costs and reduced go-to-market timeline to get things up and ready for the end users, which is drastically much less than what the on-premises products offer.

The product's maintenance can be taken care of by two people.

The scalability of the product has impacted our company's data-driven decision-making since I have a lot of data with me currently. For initial loads, my company uses small warehouses, but after a while, it will be big warehouses. Based on the aforementioned details, my company makes data-driven decisions, like how much warehouse size we need or whether we need to scale up or scale out.

Snowflake Analytics is better than the other platforms that work on either a cloud or an on-premises version. Snowflake Analytics can improve in areas like scalability and in the way the queries are written.

Snowflake Analytics is pretty easy to use with the connectors for integration with the tools and systems in my company.

Others who plan to use the solution can benefit from it. I recommend others consider or try out a PoC phase or exploration process of the product to see whether the tool fits their use cases.

I rate the overall tool an eight out of ten.

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Snowflake Analytics
May 2025
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.
SaurabhSingh4 - PeerSpot reviewer
Data Analyst at Wespath Benefits and Investments
Real User
Top 5Leaderboard
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Omar AKIL - PeerSpot reviewer
Big Data & Cloud Manager at Micropole
Real User
Top 20
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?

I primarily use it in the realm of machine learning products and general data analytics.

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.

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:
PeerSpot user
KumarRajeev - PeerSpot reviewer
Senior Software Engineer at a consultancy with 10,001+ employees
Real User
Top 10
Efficient data management with enhanced warehouse capabilities and good performance
Pros and Cons
  • "The most important feature is the warehouse functionality."
  • "When we insert data into a large table, it takes a lot of time."

What is our primary use case?

I use Streamlit apps and Snowflake Analytics for analytics, data warehousing, migration, creating reports, and segregation. It is used to create reports for analytics for users.

How has it helped my organization?

We don't have to transfer the data as Snowflake's data sharing capabilities allow us to handle data more efficiently. It stands out against the other tools in the market.

What is most valuable?

The most important feature is the warehouse functionality. Increasing the warehouse size helps cater to large amounts of data without worrying about performance issues.

What needs improvement?

When we insert data into a large table, it takes a lot of time. This performance issue can be improved.

For how long have I used the solution?

I have been using Snowflake Analytics for almost four years. I have used it myself.

What do I think about the scalability of the solution?

If you increase the size of the warehouse, the performance is taken care of. It scales well with large data volumes.

What's my experience with pricing, setup cost, and licensing?

We don't handle the price part. However, our customer is happy with our services regarding Snowflake Analytics.

What other advice do I have?

I would recommend Snowflake Analytics, even with the performance issue related to large table insertions.

I'd rate the solution eight out of ten.

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Flag as inappropriate
PeerSpot user
reviewer2098053 - PeerSpot reviewer
Technical Consultant at a financial services firm with 10,001+ employees
Consultant
Top 20
Provides multiple development tools to build applications and integrate

How has it helped my organization?

In one project, the vendor also uses Snowflake for analytics, housing the data within their Snowflake instance. Previously, we retrieved this data via FTP and then employed a Python program to read and load it into our tables. However, by leveraging Snowflake, we can now directly access this data.

What is most valuable?

Snowflake provides multiple development tools. You can build applications with Snowflake and integrate them with Java and Python. You can write code in Python and Java and use secure features.

What needs improvement?

Some functionalities available through SQL are inaccessible in Python or Java within Snowflake. Snowflake must enhance its support for these programming languages to offer full flexibility and capacity, allowing developers to use them.

Currently, there are restrictions. For example, using Spark Engine with Snowflake allows you to write code but not call external functions or packages. Snowflake must improve its programmatic capabilities to support better engineers and developers, especially those transitioning from big data technologies.

For how long have I used the solution?

I have been using Snowflake Analytics for two years.

What do I think about the scalability of the solution?

Snowflake Analytics offers scalable data warehousing solutions that can effectively handle large volumes of data. Increasing the capacity of the data warehouse can enhance its scalability, making it more adept at capturing and managing big data.

What other advice do I have?

The organization is completely focused on moving its processes and data to Snowflake. Once this is done and the business starts consuming and extracting data from Snowflake, value realization will occur.

Initially, we began with our SaaS platform on AWS. When transitioning data from AWS to Snowflake, we found a seamless integration between the two platforms, making it easier to access data from Snowflake. This integration retrieves and uses data, contributing to the wide acceptance and adoption of Snowflake Analytics.

The data creation and consumption teams have separate roles, allowing for a clear delineation of responsibilities. This ensures the consuming team only accesses the products or data relevant to their tasks. We maintain efficient data management and security by creating roles for the consumer team and providing access accordingly.

Data-driven decisions have improved significantly. Previously, we had multiple small copies of the data scattered across different locations. With Snowflake, we've consolidated everything into one golden copy of the data. Someone who needs a subset of that data can create views or access specific subsets directly. This setup allows us to track who has access to the data and its origin. Consumers don't need to go to multiple places to get the data. They know the central location to access or request the data and the available data products. This centralization will help in making more informed, data-driven decisions.

I recommend Snowflake Analytics if you are looking for a reliable and well-regarded solution. It has gained significant traction in the market. Snowflake is an excellent choice for analytics purposes. While companies need to research other available tools, Snowflake is a good option.

Overall, I rate the solution an eight out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Luiz Cesar Gosi - PeerSpot reviewer
Senior Analytics Engineer at TalkDesk
Real User
Top 5Leaderboard
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
MandarGarge - PeerSpot reviewer
V.P. Digital Transformation at e-Zest Solutions
Real User
Provides great performance and flexibility
Pros and Cons
  • "Very good flexibility and it offers computation completely decoupled from the storage."
  • "If you have a lot of computations, it becomes very costly."

What is our primary use case?

Snowflake replaces enterprise data warehouses that have traditionally been on-premise and had to be managed by the enterprises themselves. We are a services company and we create these data platforms for our enterprise customers in a variety of industries including health care, education, travel and tourism. We create and build services around Snowflake and part of my job is to assess its suitability for our enterprise customers. We are partner of Snowflake. 

What is most valuable?

The solution is completely managed and that's fantastic. Its a true SaaS kind of Data platform. You can create analytical products as a SaaS offering, nothing needs to be installed and no licenses needed. The solution can run on AWS, Azure and on Google Cloud and you can choose the underlying cloud on which Snowflake creates your databases, uses different services, stores your accounts and stores your data. It offers high flexibility. It offers computation completely decoupled from the storage so you pay fees for computation cost only, and storage is very very cheap. For example, within the enterprise data warehouse, if the total compute time is two hours a day but the traditional setup has to be maintained and managed round the clock, and the data also has to be permanently stored, them moving to Snowflake would ensure that the enterprise pay much less for storage, and pay for only 2 hours of computation. Performance-wise also it's a good solution. 

What needs improvement?

In your data platform, if you have a lot of computations, Snowflake can becomes costlier with. There can be some complexity when designing your warehouses or enterprise data, but that is based on your requirements and not the underlying warehouse that you choose.

For how long have I used the solution?

I've been using this solution for about 4-5 years.

What do I think about the stability of the solution?

It's extremely stable because it's backed up, load-balanced and has the elasticity that the underlying cloud (AWS, Azure, GCP) provides. 

What do I think about the scalability of the solution?

The solution is scalable and has the concept of creating virtual resources, so as an example, I can buy 10 gigabytes of data capacity, then decide to process that data every day, Snowflake then takes care of creating multiple databases/storages, and scales by itself. I don't need any calculations of load or throughput worked out beforehand. For most other similar products, such as RedShift or Azure Synapse, you have to work out your average load and peak loads beforehand , and provision the warehouse and other services. In Snowflake, you don't need to do that, it auto-scales up and down.

How are customer service and support?

Customer service has and support are at par with any professional Data Platform service.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup is straightforward. You buy an account, and add the number of accounts you need, and that's it. It takes about five minutes. 

What's my experience with pricing, setup cost, and licensing?

The solution can become expensive when you increase your computation. So one has to design the solution very carefully and optimally. Leverage it heavily for Storage, but for compute, make sure the resources (e.g. Virtual Warehouses, Snowpipe, Streams, Tasks etc.) as well as the transformations are used in the most optimum way. For example, during the design time, the technical team has to wisely think if your data marts can be Views or Tables (View consumes compute, but Tables consume Storage), how frequently your data marts need an update, whether you should write lesser but complex queries of more but simpler transformation queries and stored procedures and many other things. But its ease of use, decoupling of Compute from Storage, ability to share data, and highly managed behavior make it worth the money.

What other advice do I have?

I highly recommend Snowflake wherever possible. 

I rate this solution 9 out of 10. 

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
PeerSpot user