We use Snowflake as a data migration platform.
Senior Solutions Architect at a tech consulting company with 201-500 employees
Highly stable, extremely scalable, and easy to install
Pros and Cons
- "Data Science capabilities are the most valuable feature."
- "To ensure the proper functioning of Snowflake as an MDS, it relies heavily on other partner tools."
What is our primary use case?
What is most valuable?
Data Science capabilities are the most valuable feature.
What needs improvement?
To ensure the proper functioning of Snowflake as an MDS, it relies heavily on other partner tools. As a result, our solution architects must devote most of their time to addressing this issue.
For how long have I used the solution?
I have been using Snowflake for two years.
Buyer's Guide
Snowflake
December 2025
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,853 professionals have used our research since 2012.
What do I think about the stability of the solution?
I give the stability a nine out of ten.
What do I think about the scalability of the solution?
I give the scalability a nine out of ten.
How are customer service and support?
The technical support team is good.
How was the initial setup?
The initial setup is straightforward. Since Snowflake is software, the only requirements to start using it are to select a subscription and activate our account.
What other advice do I have?
I give Snowflake a nine out of ten.
Snowflake is being used at the enterprise level.
If an organization is interested in embarking on its cloud journey and Snowflake fulfills its requirements, I would recommend it as a viable solution.
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?
Amazon Web Services (AWS)
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
December 2025
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,853 professionals have used our research since 2012.
Big Data & Cloud Manager at a tech services company with 1,001-5,000 employees
A cloud solution with many useful features and data science capability
Pros and Cons
- "It is a cloud solution with many useful features. It has the data science capability. It can transform data and prepare data for a data science project with scalability."
- "We would like to be able to do modeling with Snowflake. It should support statistical modeling."
What is our primary use case?
We are using it for optimizing costs and using financial data.
What is most valuable?
It is a cloud solution with many useful features. It has the data science capability. It can transform data and prepare data for a data science project with scalability.
What needs improvement?
We would like to be able to do modeling with Snowflake. It should support statistical modeling.
For how long have I used the solution?
I have been using this solution for more than a year.
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 very scalable. We currently have more than 50 users. We can increase its usage.
How are customer service and support?
I have not contacted their support.
Which solution did I use previously and why did I switch?
I used Cloudera One about two years ago.
How was the initial setup?
It is easy. It is a SaaS solution, so there is no installation. Therefore, you don't need the infrastructure team, but you need a few data analysts.
What's my experience with pricing, setup cost, and licensing?
It is pay-as-you-go. Its cost is in the medium range.
What other advice do I have?
I would rate it a 10 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.
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
Vice President of Business Intelligence and Data Engineering at a comms service provider with 201-500 employees
Simple installation, well designed, and reasonably priced
Pros and Cons
- "All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse."
- "There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."
What is our primary use case?
Snowflake is used in my organization for our data warehouse.
What is most valuable?
All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse.
It has very nice features, such as snapshots, marketplace, and it is very easy to receive data-warehouse specifications.
What needs improvement?
There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful.
For how long have I used the solution?
I have been using Snowflake for approximately three years.
How was the initial setup?
The installation is very easy. What is needed is a good extract, transform, and load (ELT) tool and we used Matillion.
What's my experience with pricing, setup cost, and licensing?
The price of the solution is reasonable.
What other advice do I have?
My advice to those wanting to implement Snowflake is it is easy. However, the way to choose to implement your data in the warehouse matters. When we started to implement our data with Snowflake, we also switched to a metadata-driven approach, but the method depends on the people involved in the implementation. Overall, the implementation of Snowflake follows similar principles as any other data-warehouse implementation except many aspects are a lot easier and helpful.
I rate Snowflake an eight out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Director - Data Analytics at a tech vendor with 501-1,000 employees
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.
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.
Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2025
Product Categories
Cloud Data Warehouse Data Warehouse AI Synthetic Data Database Management Systems (DBMS) AI Software DevelopmentPopular Comparisons
Databricks
Azure Data Factory
Teradata
SAP HANA
Oracle Exadata
OpenText Analytics Database (Vertica)
Dremio
VMware Tanzu Data Solutions
Microsoft Azure Synapse Analytics
BigQuery
Amazon Redshift
IBM Netezza Performance Server
Oracle Autonomous Data Warehouse
Apache Hadoop
SAP BW4HANA
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?














