We use the solution for data storage and integration purposes.
Soullution Architech at a tech services company with 51-200 employees
Has good stability and processes the data efficiently
Pros and Cons
- "The solution's customer service is good."
- "Its transaction application needs improvement."
What is our primary use case?
What is most valuable?
The solution's most valuable feature is path application.
What needs improvement?
They should improve the performance of the solution's transaction application.
What do I think about the stability of the solution?
It is a stable solution.
Buyer's Guide
Snowflake
August 2025

Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
866,685 professionals have used our research since 2012.
What do I think about the scalability of the solution?
We have 20-30 solution users in our organization.
How are customer service and support?
The solution's customer service is good.
How was the initial setup?
The solution's initial setup was very straightforward.
What's my experience with pricing, setup cost, and licensing?
The price for the solution's license depends on the use cases.
What other advice do I have?
I recommend the solution to others and rate it as a nine. It efficiently processes the data and gets reports as well.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.

Solutions Architect at a recruiting/HR firm with 1-10 employees
Easy to query, provides accurate results
Pros and Cons
- "Very easy to use and easy to query."
- "The cost of the solution could be reduced."
What is our primary use case?
We use Snowflake as a data warehouse and analytics platform. I'm a solution architect and we are customers of Snowflake.
What is most valuable?
It's very easy to use, easy to query, and it provides pretty accurate results. It's a market leader.
What needs improvement?
The price could be reduced, it's quite high.
For how long have I used the solution?
We've been using this solution for about three months.
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 highly scalable.
How are customer service and support?
I haven't used the technical support.
How was the initial setup?
The initial setup is very easy, especially if you have cloud knowledge. We have around 150 users.
Which other solutions did I evaluate?
We moved from Red Shift to Snowflake because of scalability and the independence it provided.
What other advice do I have?
I rate this solution eight out of 10 and recommend it to other users.
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.
Buyer's Guide
Snowflake
August 2025

Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
866,685 professionals have used our research since 2012.
Data & Analytics Practitioner (BIDW, Big Data) at a tech vendor with 10,001+ employees
Internally optimizes well, scales automatically, and offers great performance features
Pros and Cons
- "I like the fact that we don't need a DBA. It automatically scales stuff."
- "It's not that flexible when compared to Oracle."
What is our primary use case?
We are using the Matillion as the ETL tool and Snowflake has storage and there is no data warehouse component for storage.
What is most valuable?
I like the fact that we don't need a DBA. It automatically scales stuff.
Snowflake has better performance features; it automatically knows the difference between the data volume. It adjusts itself.
The performance is great. It internally optimizes well.
The product is stable.
The solution is scalable.
What needs improvement?
There are certain special features that are not available. For example, in Oracle, we have an SQL field. We have functions, procedures, packages, et cetera, which you can create similarly in Snowflake. However, it's not that flexible when compared to Oracle.
For how long have I used the solution?
I've used the solution in the last year.
What do I think about the stability of the solution?
The product is stable and the performance is excellent. There are no bugs or glitches. It doesn't crash or freeze. It's extremely reliable.
What do I think about the scalability of the solution?
Snowflake scales well. If a company needs to expand, it can do so.
Which solution did I use previously and why did I switch?
We also use Matillion. I find Snowflake a bit better.
What other advice do I have?
We're partners.
While I can't speak to the version number we are using, we're always on the latest version of the solution.
Snowflake is a good product. It is quite robust and scalable. However, a few of the functions are a little complex in Snowflake.
I would rate the solution at a nine out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer. partner
Chief Data Architect - Europe at a computer software company with 10,001+ employees
Data sharing and data marketplace aspects are amazing, but it should support integration with some of the Azure and AWS native services
Pros and Cons
- "We find the data sharing and data marketplace aspects of Snowflake absolutely amazing."
- "There is a scope for improvement. They don't currently support integration with some of the Azure and AWS native services. It would be good if they can enhance their product to integrate with these services."
What is our primary use case?
We are using it as a data lake. We are using it as a data warehouse and a data mart. It is basically the entire BI and analytics platform.
I am using its latest version.
What is most valuable?
We find the data sharing and data marketplace aspects of Snowflake absolutely amazing.
What needs improvement?
There is a scope for improvement. They don't currently support integration with some of the Azure and AWS native services. It would be good if they can enhance their product to integrate with these services.
It would also be great if it can support stored procedures.
For how long have I used the solution?
I have been working with it for four years.
What do I think about the stability of the solution?
It is stable.
What do I think about the scalability of the solution?
It is scalable.
What's my experience with pricing, setup cost, and licensing?
You need to be aware of the bloating costs. It is easy to use, but if you don't use it wisely, then your monthly bill can bloat a lot. You need to be a bit aware of its consumption cost.
What other advice do I have?
I would rate it a seven out of 10.
Disclosure: My company has a business relationship with this vendor other than being a customer. Integrator
Director - Data Analytics at Sunera Technologies
Great performance, good technical and community support, and resizable according to your needs
Pros and Cons
- "Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
- "There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."
What is our primary use case?
We are using it for a migration from on-prem to cloud.
What is most valuable?
Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake.
What needs improvement?
There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it.
For how long have I used the solution?
It has been almost two years.
What do I think about the scalability of the solution?
A great feature of Snowflake is that you can resize your warehouse according to your needs. Whenever we are expecting a huge amount of data, we can scale it up. It does that automatically as well, which is the best thing. We don't have to worry about that, and there is also no need for a database administrator. We do not need any DBA for this.
How are customer service and technical support?
We have contacted them only for the basic setup. Most of the time, we were able to get the right solution at the right time. We got great support from them.
They're doing a pretty great job in providing all the information. They have a great community and great coverage, and there is a lot of information available over the internet.
How was the initial setup?
Its setup was quite straightforward. I did not find any complexity with that.
What's my experience with pricing, setup cost, and licensing?
I am not much aware of the price, but based on what I have analyzed so far, its cost is reasonable as compared to on-prem data warehouse solutions. It provides a great deal for production.
What other advice do I have?
One of the concerns related to Snowflake is about longevity in terms of how long can we use Snowflake. It is a big question in the market. It is a new baby in the market, and we don't know for how long will it trend. It has some big competitors. Firebolt claims to be the number one in this area. They have much better features than Snowflake. I would not say that Snowflake is the best and in the right position at this point in time. Snowflake is good for the next year, but Firebolt is going to bring it down.
I would rate Snowflake an eight out of 10.
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 Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
Easy to use, flexible, and very stable
Pros and Cons
- "The solution is very easy to use."
- "The solution needs more connectors."
What is our primary use case?
The solution is primarily used as a data warehouse.
What is most valuable?
The solution is very easy to use.
The product is very stable and flexible. The performance is good.
The product is quite scalable.
What needs improvement?
The solution needs to offer more functionality related to machine learning and artificial intelligence.
The solution needs more connectors.
For how long have I used the solution?
I've been using the solution for close to two years.
What do I think about the stability of the solution?
The solution is very stable and extremely reliable. There are no bugs or glitches. It doesn't crash or freeze. The performance is very good.
What do I think about the scalability of the solution?
The scalability of the solution is very good. If a company needs to expand it, it can do so with ease.
We have about 100 people on the product currently.
How are customer service and technical support?
Technical support overall has been good. They are helpful and responsive. We have no complaints.
Which solution did I use previously and why did I switch?
I have some experience with Teradata.
How was the initial setup?
There is no installation process, as it is run as software as a service on the cloud.
For deployment, I would say two to five people would be enough. It depends on the size of the project and can have from one person to 20 people supporting it. It really depends on the implementation. The people would likely be admins, engineers, and managers.
What's my experience with pricing, setup cost, and licensing?
The product requires the purchase of an annual license.
Which other solutions did I evaluate?
Before choosing this solution, we looked at SQL Server and Teradata.
What other advice do I have?
We're customers and end-users.
We're using the latest version of the solution. I can't speak to the exact version number.
I'd rate the solution at a nine out of ten. We've been mostly very happy with its capabilities.
I'd recommend the solution to other users and companies.
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.
General Manager of Data Science at a non-profit with 501-1,000 employees
Good data ingestion capability, scalable based on the requirement, and very stable
Pros and Cons
- "The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently."
- "They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."
What is most valuable?
The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently.
What needs improvement?
They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production.
They should also make its initial setup easier. Its customization and configuration are not very straightforward.
Their technical support is awesome, but it is just too expensive.
For how long have I used the solution?
I have been using this solution for about two years. I am currently using its latest version.
What do I think about the stability of the solution?
It is very stable.
What do I think about the scalability of the solution?
It is very simple to scale up and down depending on the project or situation, which is an advantage.
How are customer service and technical support?
They are fantastic but just too expensive. They charge hourly rates and are very expensive.
How was the initial setup?
Its setup is not very straightforward. Its customization and configuration are not very straightforward. For two large data factories, the configuration is too complicated. They should work on it.
What other advice do I have?
It is a good solution. At the moment, I can't find another product that is better than Snowflake, but it needs better ETL functionality, easier configuration, and cheaper support. All products have got some limitation.
I would rate Snowflake an eight out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
ML Lead at a tech services company with 201-500 employees
Well-distributed with different data engines, great stability and scalability, and easy to deploy
Pros and Cons
- "It is a very well-distributed system. It has different data engines for different applications. Many applications can use different computational engines at the same time. In terms of data processing, the feeling was similar to working with a relational database but in a scalable way."
- "The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."
What is our primary use case?
It was used in my previous company for a massive data warehouse. It was used for events and actions from other data sources. We had its latest version.
What is most valuable?
It is a very well-distributed system. It has different data engines for different applications. Many applications can use different computational engines at the same time. In terms of data processing, the feeling was similar to working with a relational database but in a scalable way.
What needs improvement?
The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage.
They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python.
For how long have I used the solution?
I worked on it a lot in the past 12 months in my previous company.
What do I think about the stability of the solution?
Its stability is absolutely great. There are no problems with its stability.
What do I think about the scalability of the solution?
It is scalable. There are no problems with the scalability of this solution. There were 50 or 60 users using it at the same time.
How are customer service and technical support?
I don't have much experience with their technical support. When we asked them some technical questions related to Spark integration, they were quite supportive. Their support was fine.
Which solution did I use previously and why did I switch?
I have used BigQuery on Google Cloud Platform and Spark on an internal cloud.
How was the initial setup?
It was quite straightforward. There is no problem with that. However, managing the database and roles and access is complicated. Its deployment didn't take a long time.
What other advice do I have?
I would rate Snowflake 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.

Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros
sharing their opinions.
Updated: August 2025
Popular Comparisons
Databricks
Azure Data Factory
Teradata
Oracle Exadata
OpenText Analytics Database (Vertica)
Dremio
Microsoft Azure Synapse Analytics
VMware Tanzu Data Solutions
Amazon Redshift
BigQuery
Oracle Autonomous Data Warehouse
SAP BW4HANA
Apache Hadoop
Amazon EMR
AWS Lake Formation
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?