We use this product basically for developing an IoT (Internet of Things). Currently, we are sending data from our S3 (Simple Storage Service) storage. In the future, we are planning to directly stream data to Snowflake.
Principal IT Technologist- BI Platform Architect at Medtronic
Good snapshot and rollback features and has good scaling options
Pros and Cons
- "The snapshot feature is good, the rollback feature is good and the interface is user-friendly."
- "Availability is a problem."
What is our primary use case?
What is most valuable?
In terms of features, we have not yet explored the product completely. So we are still in the proof of concept phase. As of now, the product meets our preliminary requirements. The snapshot feature is good and the rollback feature is good. That is why we have the product and these are the key things we need.
What needs improvement?
The recovery process is very simple and very user-friendly as well. The constraint files could be improved. But the most important things are there. Also, the interface is good to work with and user-friendly.
If I had to say what needs improvement, in my experience is that the availability is a problem. Availability should be high and has to be enhanced.
I still have not explored all of the existing features. Because I have not been deeply involved with using the program it is hard to say what else is missing or what I would need.
For how long have I used the solution?
We have just explored the product for a few months.
Buyer's Guide
Snowflake
March 2025

Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.
What do I think about the stability of the solution?
The stability of Snowflake is very good.
What do I think about the scalability of the solution?
Scalability is very good and very simple.
Within the company, we currently have a total of fewer than 50 people using the product. Their general roles vary from data analyst to data scientist, to IT professionals, and maybe one or two of the upper managers.
How are customer service and support?
I tried using technical support once and they were very helpful. But after that, I have not had any reason to explore the support services.
How was the initial setup?
The initial setup was simple.
What about the implementation team?
The implementation was done by the vendor.
Which other solutions did I evaluate?
Before choosing to work with Snowflake we looked at virtual solutions and we looked at Redshift, we looked at Qubole and a couple of other cloud options. Earlier when we did a mining site, I was working with Alteryx, so I was already familiar with that product and its capabilities to use for comparison. We decided to go with Snowflake because it seemed mature and had what we wanted.
What other advice do I have?
My advice to someone who is looking at Snowflake is that if they are looking at analytics tools in addition to warehousing and certain advantages of cloud computing, then I would suggest Snowflake. But if they are just looking for the warehousing part where you will later just use another solution on top of it, then I would not suggest Snowflake.
On a scale from one to ten where one is the worst and ten is the best, I would rate Snowflake as an eight or nine. Let's say 8.5.
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: I am a real user, and this review is based on my own experience and opinions.

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
March 2025

Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.
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."
- "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: I am a real user, and this review is based on my own experience and opinions.
Senior Data Architect at Tata Consultancy Services
High performance, scalable, and simple setup
Pros and Cons
- "The most valuable features of Snowflake are its performance and power."
- "Snowflake could improve if they had an Operational Data Store(ODS) space."
What is our primary use case?
Snowflake is used for data warehousing.
What is most valuable?
The most valuable features of Snowflake are its performance and power.
What needs improvement?
Snowflake could improve if they had an Operational Data Store(ODS) space.
For how long have I used the solution?
I have been using Snowflake for approximately four years.
What do I think about the stability of the solution?
The stability of Snowflake is good.
What do I think about the scalability of the solution?
The scalability of Snowflake is very good.
I have approximately six customers using this solution but in addition, I am directing more.
How are customer service and support?
The technical support from Snowflake was poor previously, they have improved significantly.
How was the initial setup?
Snowflake has an easy setup and it is quick.
What's my experience with pricing, setup cost, and licensing?
There is a license needed to use this solution. There are a few licensing options available. They have a pay-as-you-go option, but it is recommended to pay upfront.
What other advice do I have?
I would recommend this solution to others.
I 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
Data Engineer at Natwest
Good scalability and has a simple query process
Pros and Cons
- "The solution's computing time is less."
- "Its stability could be better."
What is our primary use case?
We use the solution to build the pipelines in stream sets, including data source, data warehouse, and destination endpoints.
What is most valuable?
The solution's most valuable features are storage, run time, scalability, and minimum query time compared to other vendors.
What needs improvement?
The solution's stability needs improvement.
For how long have I used the solution?
I have been using the solution for seven or eight months.
What do I think about the stability of the solution?
Recently, I encountered an issue with the solution's data warehouse. The resource monitor had exceeded its quota. I rate its stability as an eight.
What do I think about the scalability of the solution?
I rate the solution's scalability as a nine.
Which other solutions did I evaluate?
We use Hive and Hadoop as well. Snowflake is more stable and scalable.
What other advice do I have?
The solution is more straightforward to use than the other IDBMS tools. It has a simple query process. Its computing time is less as well. One can easily have access to it. I rate it as a nine.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Specialist Programmer at Infosys
Simple setup, reliable, and high performance
Pros and Cons
- "The most valuable feature of Snowflake is its performance. We can access the data quickly. Additionally, it handles structured and non-structured data."
- "The solution could improve by allowing non-structured data, such as PDFs, images, or videos. We cannot see the data."
What is our primary use case?
I am using Snowflake for migrating data and table backups.
What is most valuable?
The most valuable feature of Snowflake is its performance. We can access the data quickly. Additionally, it handles structured and non-structured data.
What needs improvement?
The solution could improve by allowing non-structured data, such as PDFs, images, or videos. We cannot see the data.
For how long have I used the solution?
I have been using Snowflake for approximately three years.
What do I think about the stability of the solution?
The stability of Snowflake is good.
What do I think about the scalability of the solution?
Snowflake is a scalable solution.
We have approximately 200 to 300 people using the solution.
How was the initial setup?
The initial setup of Snowflake is easy.
What other advice do I have?
If the use case fits the solution then I would recommend it. For example, if you have large data and want the rational database backed up, this solution would be a good choice.
I rate Snowflake 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?
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Engineer at a photography company with 1,001-5,000 employees
Generates metrics efficiently, but the integration process needs enhancement
Pros and Cons
- "The platform's most valuable features include its ability to effectively summarize and manage large datasets, allowing multiple teams to analyze and generate insights."
- "Improvement is needed in integrating external tools, such as data catalogs, which can be complicated due to differing formats and usage across departments."
What is most valuable?
The platform's most valuable features include its ability to effectively summarize and manage large datasets, allowing multiple teams to analyze and generate insights. Its integration with data lakes for business impact analysis, performance metrics, and KPIs is particularly important.
What needs improvement?
Improvement is needed in integrating external tools, such as data catalogs, which can be complicated due to differing formats and usage across departments. The goal is to enhance collaboration and streamline workflows.
What do I think about the scalability of the solution?
The product's scalability is crucial for managing petabyte-scale data generated daily across various regions, allowing for efficient data validation and handling.
How was the initial setup?
The primary challenges during the initial setup were the high pricing and uncertainties regarding future costs associated with data usage.
The deployment involved consultation among managers, agreement on on-site requirements, scale calculations, and collaboration with engineers for setup approval.
I rate the process a seven out of ten.
What other advice do I have?
Snowflake is integrated through a complex workflow that involves collecting data on the publisher side, using tools like Airflow and Kafka for batch jobs, and frequently importing data into the product from various sources, including S3 and Data Lakes. It creates a smooth data pipeline.
I rate it a seven out of ten.
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Sep 26, 2024
Flag as inappropriatePractice Head at Vyom Labs
Users can pay as they use and not worry about the maintenance of the data warehouse
Pros and Cons
- "The most valuable features of Snowflake are that you have to pay per usage, and you don't have to worry about the maintenance of the data warehouse because it is on the cloud."
- "It would be helpful if Snowflake could create good reports instead of using Power BI reports."
What is our primary use case?
The solution has use cases related to retail stores and sales.
What is most valuable?
The most valuable features of Snowflake are that you have to pay per usage, and you don't have to worry about the maintenance of the data warehouse because it is on the cloud.
What needs improvement?
The solution’s pricing could be cheaper. It would be helpful if Snowflake could create good reports instead of using Power BI reports.
For how long have I used the solution?
What do I think about the stability of the solution?
I rate the solution a nine out of ten for stability.
What do I think about the scalability of the solution?
Snowflake is a scalable solution. We have four to five customers for Snowflake who use it regularly.
How was the initial setup?
The solution’s initial setup is straightforward.
What about the implementation team?
The solution's deployment in a development environment takes only a couple of minutes.
What's my experience with pricing, setup cost, and licensing?
Users have to pay a licensing fee for the solution, which is expensive.
What other advice do I have?
Snowflake is deployed on the cloud. The solution is providing HIPAA compliance, which is sufficient. Users looking for a pay-as-you-use product available on Azure or AWS should consider Snowflake.
Overall, I rate the solution an eight out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner

Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros
sharing their opinions.
Updated: March 2025
Popular Comparisons
Azure Data Factory
Teradata
Microsoft Azure Synapse Analytics
Vertica
Amazon Redshift
Dremio
BigQuery
Amazon EMR
Oracle Autonomous Data Warehouse
AWS Lake Formation
SAP Business Warehouse
IBM Db2 Warehouse on Cloud
Firebolt
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?