I mostly build or design data warehouse analytics solutions using Snowflake.
IT Consultant at Independent Consultant
Straightforward deployment, stable, and scalable
Pros and Cons
- "Snowflake has three great features: Snowpiping is proving to be very valuable, Time Travel is excellent, and Snowpipes are another great functionality the solution has made available."
- "Snowflake needs transparency over costs and pricing."
What is our primary use case?
How has it helped my organization?
The productivity across the teams that use Snowflake I believe is higher than it would be without the solution.
What is most valuable?
Snowflake has three great features: Snowpiping is proving to be very valuable, Time Travel is excellent, and Snowpipes are another great functionality the solution has made available.
What needs improvement?
Snowflake needs transparency over costs and pricing.
Buyer's Guide
Snowflake
May 2026
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
896,942 professionals have used our research since 2012.
For how long have I used the solution?
I have been using the solution for three years.
What do I think about the stability of the solution?
I give the stability an eight out of ten. We rarely have issues.
What do I think about the scalability of the solution?
I give the scalability an eight out of ten.
Which solution did I use previously and why did I switch?
I have used many on-premise solutions in the past and also Azure Synapse Analytics.
How was the initial setup?
The initial setup is straightforward. I give the setup an eight out of ten.
A basic implementation is quick and we only have to set up Snowflake and the cloud service. We need one engineer and one designer for the implementation.
What about the implementation team?
Depending on the complexity of the implementation, we may need to use a third party or help from the vendor.
What's my experience with pricing, setup cost, and licensing?
Part of the problem with the pricing is that it is very difficult for businesses to get an idea of how expensive it might be until they actually start using Snowflake. Until they start pushing large amounts of data through, we will not really know. I believe that it is very difficult for businesses to make a commitment.
What other advice do I have?
I give the solution an eight out of ten.
My advice is to start Snowflake and not spend too much time thinking about how we could use the solution or what it could be used for. The key is just getting started.
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.
Architect at a tech vendor with 10,001+ employees
Increases productivity, is stable, and scalable
Pros and Cons
- "Snowflake is faster than on-premise systems and allows for variable compute power based on need."
- "Snowflake can improve its machine learning and AI capabilities."
What is our primary use case?
In our organization, data is often spread out over multiple on-premise and cloud-based platforms. Snowflake is an agnostic platform, meaning it can be used regardless of which cloud provider we use and can serve as a single source for all of our data. Our use case then is to ensure that all data is located in one place, utilizing Snowflake as the platform.
How has it helped my organization?
With Snowflake, productivity can be increased. Snowflake is faster than on-premise systems and allows for variable compute power based on need. We are currently experimenting with ways to reduce processing time from eight hours to six hours or even less.
What is most valuable?
The vendor claims that the provision of warming sensors quickly enables warmth to compute nodes, which is their Unique Selling Point. From my experience, this has proven to be true.
What needs improvement?
For the past year and a half, I have experimented with different proof of concept. I have wanted to use Snowflake, however, I have not been able to do so. Microsoft Azure is superior to Snowflake in terms of its machine learning and artificial intelligence capabilities. Snowflake has its own unique products, but Azure surpasses it in those areas. Snowflake can improve its machine learning and AI capabilities.
For how long have I used the solution?
I have been using the solution for one and a half years.
What do I think about the stability of the solution?
I found that Snowflake is highly stable, which is a reflection of the quality of its network.
What do I think about the scalability of the solution?
I have gone to the extremes from a scalability perspective and I give Snowflake's scalability an eight out of ten.
How are customer service and support?
As a premium customer for all these solutions, we have received excellent support overall with no issues encountered thus far. However, it is possible that some users of the free version may be experiencing some issues. I cannot confirm this, but from my experience, there have been no difficulties.
How was the initial setup?
I give the initial setup a seven out of ten for ease and time required.
What about the implementation team?
We are leveraging Snowflake, a cloud-based platform, both independently and in collaboration with the vendor. Our objectives for utilizing Snowflake are distinct from those of the vendor.
What's my experience with pricing, setup cost, and licensing?
Comparing Snowflake to on-prem options such as Oracle or SAP, it seemed more cost-effective. With Vantage, a one-time purchase allows for use as many times and to a large capacity, whereas Snowflake, Azure, and similar services become increasingly expensive as the scale increases. Determining the best point of cost-effectiveness requires further study.
Which other solutions did I evaluate?
I have tested all the different alternatives to Snowflake as well. It is hard to determine which one is the most suitable, as each has its own advantages and disadvantages.
What other advice do I have?
I give the solution an eight out of ten.
Deciding between Azure Synapse and Snowflake can be difficult, as the best choice depends on one's own use case. Ultimately, it comes down to the available connectors; the product with more connectors is likely the better option. When making a decision, one should consider which other sources they would want to get data from and where they want to send data to. This can help inform their product selection.
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
Snowflake
May 2026
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
896,942 professionals have used our research since 2012.
Vice President, Data Architecture and Management at a financial services firm with 10,001+ employees
SQL-driven and suitable for massive compute, but has REST API limitations and doesn't support extensive writebacks
Pros and Cons
- "It's user-friendly. It's SQL-driven. The fact that business can also go to this application and query because they know SQL is the biggest factor."
- "Room for improvement would be writebacks. It doesn't support extensively writing back to the database, and it doesn't support web applications effectively. Ultimately, it's a database call, so if we are building web applications using Snowflake, it isn't that effective because there is some turnaround time from the database."
What is our primary use case?
We're using it more for data warehousing and distribution.
Snowflake is a SaaS platform, so I'm using whatever is the latest version.
How has it helped my organization?
It's definitely for compute. The best use case of Snowflake is massive compute. With the parallel reads that we can do from Snowflake, we can combine data from disparate sources, consolidate it, and provide it to end clients through custom stored procedures.
What is most valuable?
It's user-friendly. It's SQL-driven. The fact that business can also go to this application and query because they know SQL is the biggest factor. So, we can provide all the data, and the analysts, data scientists, and product strategists can go and analyze the data themselves.
What needs improvement?
Room for improvement would be writebacks. It doesn't support extensively writing back to the database, and it doesn't support web applications effectively. Ultimately, it's a database call, so if we are building web applications using Snowflake, it isn't that effective because there is some turnaround time from the database.
I'd like them to look into the limitations of REST API. Snowflake came up with this native API concept, but it has got a lot of limitations. I'd like to see it provide better service-based APIs so that it can provide data as a service.
For how long have I used the solution?
I've used Snowflake for over three years.
What do I think about the stability of the solution?
Its stability is fine, but of late, I get loads of messages saying there's some sort of outage or some sort of issue in the application. I keep getting these notifications from Snowflake, which gives a false impression that something wrong is happening, and it might be underlying in the backend. It doesn't seem that stable.
What do I think about the scalability of the solution?
Its scalability is high. I'd rate it an eight out of ten in terms of scalability.
At this time, we have no plans to increase its usage.
How are customer service and support?
Their support is good.
Which solution did I use previously and why did I switch?
Prior to Snowflake, it was a completely Greenfield requirement.
How was the initial setup?
It was very straightforward.
What about the implementation team?
It required just two people. One from the Snowflake perspective, and one from my team members' perspective to get the configuration running. That's it.
What was our ROI?
We haven't yet seen a return on investment because some of the applications are yet to be fruitful and make revenue. We have used Snowflake for the past three years at this point, but we have not yet made great revenue.
What's my experience with pricing, setup cost, and licensing?
It's expensive.
What other advice do I have?
Snowflake is very useful as a data lake and as a data warehouse. Also, it has a lot of features with respect to data science. We are not there yet, but if there are any specific use cases around compute, data distribution, and data sharing, then Snowflake is a tool to be considered.
I'd rate Snowflake a seven out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Senior Consultant at a consultancy with 10,001+ employees
Reasonably priced, simple to set up, and expands well
Pros and Cons
- "The solution is stable."
- "Potential new users should just definitely give it a shot."
- "I don't know about GCP, if they have connected for GCP. If they don't, they should allow for it."
What is our primary use case?
Basically, if at all, we wanted to have an interface for data warehouses on the cloud which worked on Azure or AWS. Snowflake, provides a more intuitive, rapid user interface where people can connect and maintain warehouses and share data among the people in the companies easily. Its pricing model and the model have made maintaining virtual warehouses simpler.
What is most valuable?
I appreciate the Snowflake marketplace, where you can drop data and allow other people throughout the world to access it. You can go to the Snowflake marketplace and connect to some data. If somebody else publishes, for example, COVID-19 data or weather data, you can sign up for new data sets and bring them into your warehouse, which I found very interesting.
You can connect to different cloud sources, including Azure and AWS.
You can report out, and all the cloud technologies have connected to Snowflake, allowing you to move the data or get the data into Snowflake.
The initial setup was pretty simple.
It scales really well.
The solution is stable.
The solution is reasonably priced.
What needs improvement?
I don't know about GCP, if they have connected for GCP. If they don't, they should allow for it.
Overall, they're doing great. I don't have any specific complaints or improvements that need to happen.
For how long have I used the solution?
I've used the solution for a couple of years now.
What do I think about the stability of the solution?
The solution is quite stable since everything is in the cloud, and the data these days has become cheap with storage and everything in the cloud. Through clusters and warehouses, sizes can be increased or decreased based on usage, and they can be turned on and turned off. Sustainability-wise, I think it's a pretty good solution.
What do I think about the scalability of the solution?
It is scalable. The warehouses or auto-scaling features in the warehouses are great. You can go from small to medium to large all the way up to extra large, and there are different auto-scaling tasks that can happen. You can turn it on and turn it off based on the usage or auto-turn it on and turn it off. That's a pretty nice feature to have and we find it both sustainable and scalable for sure.
I work for clients, so last time when I worked for a client, there was a group of 100 people who were actually signed up to use Snowflake.
How are customer service and support?
I've never dealt with technical support. We did have people from Snowflake working with us directly, and we never ran into any issues that needed troubleshooting. The personnel from Snowflake, of course, would resolve whatever came up.
Which solution did I use previously and why did I switch?
I come from an Azure background as well, so Microsoft also comes with Azure Synapse, where it's a similar functionality as Snowflake, where it's warehousing on the cloud. Azure Synapse is also good. I'm unaware of AWS or GCP, and I heard that Google Cloud Platform also has Big Query and big data capabilities, which are tough competitors for Snowflake and other cloud warehousing tools.
How was the initial setup?
The implementation process was pretty straightforward. I didn't set it up, though. I used an already set up version. I just had to connect. I had to push data from Azure to Snowflake, create tables there, and have data loaded into those tables, and that's it. I wasn't doing anything else, so I didn't work on the infrastructure of Snowflake.
You would need a group of two or three people to maintain the product.
What about the implementation team?
I work for a consulting firm, so I don't work for the client, so I really don't know what the company used for deployment.
What's my experience with pricing, setup cost, and licensing?
Licensing was based on the warehouse. I don't recall it being very expensive.
What other advice do I have?
I'm a consultant and end-user.
I'm not currently using the solution right now and do not recall the last version I was on.
Now, I'm working for a different client on a different platform altogether. My company, as such, doesn't use Snowflake since we are in consulting. We have expertise in something, and then we help the clients deliver that solution on the technology.
Potential new users should just definitely give it a shot. They should start off with a POC, proof of concept, for the data that they have, and then, if everything works well and they can migrate in a cost-effective way.
I would recommend Snowflake to start off with since it's just picking up over the last couple of years. If I have to recommend anything, however, it would be more Microsoft tools I would recommend since that all comes as a package. You can do Synapse and Azure Data Factory, which is for ETL. You can also do Azure Data Lake Storage. There are different things that you can do when you buy something in a package like that. That said, I definitely recommend Snowflake if someone wants to give it a shot.
I'd rate the solution eight 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.
Data Consultant at Omaze
Data warehousing solution that is straightforward to setup and used to analyze e-commerce advertising data
Pros and Cons
- "The most valuable feature has been the Snowflake data sharing and dynamic data masking."
- "The cost efficiency and monitoring of this solution could be improved. It's easy to spend a lot on Snowflake and it does offer monitoring tools but they're pretty basic."
What is our primary use case?
We use this solution to ingest e-commerce advertising and web analytics data and completing an analysis. There are 60 people using this solution in our business.
How has it helped my organization?
We are working with a TV advertising agency and they were able to set up a Snowflake data share to share ad spend with us and it was very quick to integrate.
What is most valuable?
The most valuable feature has been the Snowflake data sharing and dynamic data masking.
What needs improvement?
The cost efficiency and monitoring of this solution could be improved. It's easy to spend a lot on Snowflake and it does offer monitoring tools but they're pretty basic.
For how long have I used the solution?
I have been using this solution for three years.
What do I think about the stability of the solution?
This is a stable solution.
What do I think about the scalability of the solution?
This is a scalable solution.
How are customer service and support?
I would rate the technical support for this solution a four out of five.
Which solution did I use previously and why did I switch?
We previously used Amazon Redshift.
How was the initial setup?
The initial setup was straightforward.
What about the implementation team?
We did have a consultant help us.
What was our ROI?
We do see a return on investment.
What's my experience with pricing, setup cost, and licensing?
Pricing is based on usage. It is the most expensive of our data tools.
What other advice do I have?
I would advise others to check costs when implementing any changes, such as new BI tools or a new data source. Set up different warehouses for your different tools so that you can track cost.
I would rate this solution a nine 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.
Sr Manager at Publicis Sapient
Standard and competitive pricing, excellent starting place, with straightforward in-house deployment
Pros and Cons
- "I like the ability to work with a managed service on the cloud and that is easy to start with."
- "From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced."
What is our primary use case?
The primary use case is for building a database and data link.
What is most valuable?
I like the ability to work with a managed service on the cloud and that is easy to start with.
What needs improvement?
From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced.
For how long have I used the solution?
I have been using Snowflake for three years now.
What do I think about the stability of the solution?
The stability is reliable and a standard product.
What do I think about the scalability of the solution?
The scalability is very good and we have around two hundred data sets currently operating.
How are customer service and support?
Technical support is good. It is readily available and they are very responsive.
How would you rate customer service and support?
Positive
How was the initial setup?
The initial setup was straightforward.
What about the implementation team?
You can do the implementation in-house since it is a managed service and only takes a few hours.
What's my experience with pricing, setup cost, and licensing?
The pricing is economical as compared to traditional solutions like Oracle and competitive pricing.
What other advice do I have?
I would rate Snowflake a nine 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. Partner
Business Intelligence Analyst at Clarivate Analytics
Data storage and processing solution that facilitates the building of connectors between different data sources
Pros and Cons
- "My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."
- "This solution could be improved by offering machine learning apps."
What is our primary use case?
My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources. The ultimate goal is to provide reporting and analytics to all departments in the company.
What needs improvement?
This solution could be improved by offering machine learning apps.
For how long have I used the solution?
We have used this solution for one year.
What do I think about the stability of the solution?
This is a stable solution.
What do I think about the scalability of the solution?
This is a scalable solution.
Which solution did I use previously and why did I switch?
Before Snowflake, we used Azure.
What about the implementation team?
I worked with a Microsoft partner to set up the entire thing. This took three months.
What was our ROI?
We have not yet experienced ROI.
What other advice do I have?
Overall, this is a helpful tool with a friendly interface.
I would rate this solution an eight 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.
Manager at SSM VIT Global Solutions
It can exchange data with downstream systems and other vendor partners as well
Pros and Cons
- "I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well."
- "The most valuable aspect of Snowflake is its scalability."
- "There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure."
What is our primary use case?
My current client is migrating from an on-premise data warehouse to the cloud, and they need to consolidate the data lake. I'm using Snowflake to develop the data lake and build data bots for certain functionalities. I've also used Snowflake to aggregate and clean data for my client's analytics.
What is most valuable?
I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well.
What needs improvement?
There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure.
For how long have I used the solution?
I started using this product about two years ago at my last company. Now, I'm a registered Snowflake partner, so working with Snowflake for one of my clients.
What do I think about the stability of the solution?
My clients haven't faced many stability challenges. It is a relatively new product that's still evolving. They're using it mainly for POCs, so they haven't faced any problems.
What do I think about the scalability of the solution?
The most valuable aspect of Snowflake is its scalability. The volume of data, which I have seen across almost in terms of five terabytes and other terabytes of data, I didn't see issues.
How are customer service and support?
Snowflake technical support is good. At my previous company, they had a customer success officer for critical accounts, and they were accessible. When I registered as a partner, I also got a quick response from support. I would rate their support eight out of 10.
How would you rate customer service and support?
Positive
How was the initial setup?
Setting up Snowflake isn't complex. I've not seen any challenges.
What's my experience with pricing, setup cost, and licensing?
They have different pricing structures based on data usage. I think they have three or four tiers you can scale through. Most of the clients see an advantage from this type of licensing. That's the reason they go for it. It's priced competitively with other solutions.
What other advice do I have?
I rate Snowflake eight out of 10.
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.
Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros
sharing their opinions.
Updated: May 2026
Product Categories
Cloud Data Warehouse Data Warehouse AI Synthetic Data Database Management Systems (DBMS) AI Software DevelopmentPopular Comparisons
Databricks
Teradata
Azure Data Factory
SAP Business Data Cloud
MongoDB Atlas
SAP HANA
VMware Tanzu Data Solutions
Oracle Exadata
OpenText Analytics Database (Vertica)
Dremio
Amazon Redshift
IBM Netezza Performance Server
Microsoft Azure Synapse Analytics
BigQuery
Amazon EMR
Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- What are the key reasons for choosing Snowflake as a data lake over other data lake solutions?
- What is the major difference between AWS Redshift and Snowflake?
- What is the biggest difference between Apache Hadoop and Snowflake?
- Which solution do you prefer: Oracle Exadata or Snowflake?
- Which is better - Azure Synapse Analytics or Snowflake?
- How to achieve sub-second query performance with JSON data (~1B rows) in Snowflake?
- Which is better for Snowflake integration, Matillion ETL or Azure Data Factory (ADF) when hosted on Azure?
- Which ETL or Data Integration tool goes the best with Amazon Redshift?
- What are the main differences between Data Lake and Data Warehouse?
- What are the benefits of having separate layers or a dedicated schema for each layer in ETL?
















