We use Snowflake for data warehouse modeling and reports.
Director Consultoria at tecnoscala consulting
Simple importing, but reporting and documentation could improve
Pros and Cons
- "Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
- "The documentation could improve. They should provide architecture information."
What is our primary use case?
What is most valuable?
Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert.
What needs improvement?
The documentation could improve. They should provide architecture information.
There could be better integration with tools other than the common databases used to receive data. There are other tools that have ETL tools within, such as Tableau. You are able to work with information prior to sending it to Tableau. This feature would be nice to have in a tool from Snowflake.
In a future release, they should make it easier to do reporting. A drag and drop type feature would be good. If not a drag and drop feature, there should be some other easier way to do it than it is now.
For how long have I used the solution?
I have been using Snowflake for approximately six months.
Buyer's Guide
Snowflake
April 2025

Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
851,823 professionals have used our research since 2012.
How are customer service and support?
The experience that we have had until now is that we can use the Snowflake very well from the videos on the web. The knowledge that our company already has regarding this solution has helped. We are producing some very sophisticated solutions. There is plenty of material on the web that you would be able to have lessons and learn.
Which solution did I use previously and why did I switch?
We have worked a lot with Tableau previously.
How was the initial setup?
We deploy the solution on-premises because we are developers, the customer is the one who has it on the Cloud. We helped them with the on-premises deployment and then we install the software and we deployed our solutions made on-premises. We complete any changes that need to be done in order to work in the customer's landscape.
The time of the deployment depends on the solution the customer requires. If it's a small solution, typically it will take approximately two weeks. A medium solution, that takes from two weeks to eight weeks. However, it depends on what you are trying to accomplish with the solution. If you are trying to do a very complex data warehouse, it's not the tool that times the most time, it's the analysis and design that takes the most time for deployment. Once that you have the analysis, design, and you transport them to Snowflake this is not difficult.
In any BI solution, you have a lot of changes because of what you need to do with the end-users, there are a lot of changes to the end-user. This can also take up some time for the deployment for the first time. It can take two to six weeks for a medium-sized project.
What about the implementation team?
On average a small project can take three people. That's in small BI projects, in some customers that we have the project takes a maximum of six weeks in order to have all the data fields. This is not for a whole data warehouse but for sales and customers. Those are all small to medium-sized projects, that require three people maximum for deployment. You might always want to have in addition, an analyst and the senior architect.
Most of our team are technicians.
What other advice do I have?
Snowflake has a lot of capabilities and performance. However, the tool is not a silver bullet and can do everything. If you designed what you need according to the tool, then everything is going to be okay.
This is true for any tool. Many people start the projects without validating what they are going to expect to have at the end, they receive a big surprise. They were thinking that the tool has this capability and it doesn't have it or perhaps it has the capability but the design you have does not work correctly.
If you see the percentage of projects in the different customers in many places, such as in Mexico, Florida, and Miami. Snowflake is a tool that is currently being used but has not been in the past. There is not a lot of history.
I rate Snowflake a six out of ten.
We have not used Snowflake long enough to better rate it. If we had a lot more formal education or had more information or reference manuals our experience would be better.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Consultant

Associate Manager at a consultancy with 501-1,000 employees
A secure and fast solution with inbound and outbound share features and good integrations
Pros and Cons
- "Its performance is a big advantage. When you run a query, its performance is very good. The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution. It has good security, and we can easily integrate it. We can connect it with multiple source systems."
- "I am still in the learning stage. It has good security, but it can always be more secure."
What is our primary use case?
We are using it for our security products. We have a trial account, and we are using the trial database and practicing on top of it. We have the latest version of this solution.
What is most valuable?
Its performance is a big advantage. When you run a query, its performance is very good.
The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution.
It has good security, and we can easily integrate it. We can connect it with multiple source systems.
What needs improvement?
I am still in the learning stage. It has good security, but it can always be more secure.
For how long have I used the solution?
I have been using this solution for a few months. I am in the learning stage.
What do I think about the stability of the solution?
It is stable. Its performance is very good.
What do I think about the scalability of the solution?
It is scalable. We have four users who are using Snowflake.
How are customer service and technical support?
We are going through the online version, and we don't find any difficulty with this.
Which solution did I use previously and why did I switch?
I also use Azure. Snowflake has more advantages than Azure.
How was the initial setup?
There is no installation as such. After you register with Snowflake, you get a demo database, which you can configure and use. It only takes around 30 minutes.
What about the implementation team?
I did it myself.
What's my experience with pricing, setup cost, and licensing?
Currently, we have a trial account, so we don't need a license. After our project starts, we would need a permanent license.
What other advice do I have?
I would recommend this solution to others. We plan to keep using it.
I would rate Snowflake a nine out of ten.
Which deployment model are you using for this solution?
Private Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Snowflake
April 2025

Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
851,823 professionals have used our research since 2012.
Founder & CIO at a computer software company with 11-50 employees
Reasonable pricing with a straightforward setup and a good user experience
Pros and Cons
- "The technical support on offer is excellent."
- "There are always a few operation updates here and there that can be made."
What is our primary use case?
We primarily use the solution to build some cost-effective solutions for a data warehouse, mostly for all non-transactional data.
What is most valuable?
The solution is very fast. It's not clunky or slow.
The product, overall, is quite inexpensive. It's very cheap to use.
The solution is extremely user-friendly and easy to navigate. The user experience is very good.
The initial setup is pretty straightforward. It's simple.
We found that the initial setup was pretty easy.
The solution has been stable and has provided good overall performance.
A company can easily scale the solution. It's not too difficult to pull off.
The technical support on offer is excellent. They're helpful for the most part.
What needs improvement?
There are always a few operation updates here and there that can be made. However, overall, there aren't any features or glaring shortcomings. It's pretty good. We can't complain.
While the solution is quite inexpensive, there is always a push from clients that want it to be cheaper in the future.
For how long have I used the solution?
I have about six years' worth of experience with the product. I've been using it for a while. I'm comfortable with its aspects. I've used it over the last 12 months as well.
What do I think about the stability of the solution?
The stability is very good. There are no bugs or glitches. It doesn't crash or freeze. It's reliable. The performance is good.
What do I think about the scalability of the solution?
The product scales quite well. If a company needs to expand it, it can do so without any problem.
We deal mostly with clients that have medium to large-scale organizations. It works well for both.
How are customer service and technical support?
Technical support has been excellent. I'd rate them nine out of ten. They are knowledgeable and responsive. We are quite happy with the level of assistance we receive if we need help.
Which solution did I use previously and why did I switch?
We've used a few other solutions including MySQL and a few other notable databases.
Right now, we are looking for some other options as well.
How was the initial setup?
The initial setup is quite simple. It's a straightforward process. It's not overly complex. A company shouldn't have any issues with the implementation process.
What about the implementation team?
We are implementors. We can implement the solution for clients if they need us to.
What's my experience with pricing, setup cost, and licensing?
The product is very reasonably priced. It's quite cheap to use. It's less expensive than, for example, Oracle.
What other advice do I have?
We are implementors of the solution.
We are using previous versions of the solution. It may not necessarily be the latest version all the time.
I'd advise other organizations to try it out and play with it a bit to see if it would fit their needs.
Overall, I would rate the solution at a nine out of ten. We've been mostly very happy with it.
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.
Senior Information Management Architect at Raken
I like how quickly the solution can be implemented
Pros and Cons
- "The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also."
- "It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud."
What is our primary use case?
We are a consulting company so our primary use depends on the niche that we are providing the services to and on which of the different versions they have. I think we are mainly using Snowflake Enterprise.
In general, it is being used for integrating information. Snowflake is a database platform, it gives information to support analytic needs, such as advanced data analytics like machine learning. In some of those cases it is also used for descriptive analytics, for instance BI.
How has it helped my organization?
One of example of how Snowflake has improved a client's organization is the democratization, it makes information available to more of the users.
What is most valuable?
The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also.
What needs improvement?
I think that the area of improvement with Snowflake is to improve the administration. It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud.
I also heard from a company we work for that it could be more user-friendly because it provides some tools but they are not user-friendly.
Additionally, it would be very helpful if Snowflake integrated machine learning and some other advanced analytics features within their language or product capabilities. Right now, they do it through some other company where you have to buy these capabilities from other vendors. There are some customers that don't have complex needs for machine learning or advanced analytics so they don't have to buy it from another vendor but can use it from the product itself if they have it.
For how long have I used the solution?
The whole company has been using Snowflake for about three years.
What do I think about the stability of the solution?
In terms of stability, so far it is very stable.
What do I think about the scalability of the solution?
Snowflake is very scalable. Our client companies where we implement Snowflake are medium to large sized. These companies have offices in different parts of the world, not just some regions, but companies with office users in different parts of the world. We are dealing with international companies. Their tendency is to increase the use of the Snowflake platform. It would serve all the analytical needs in these companies.
How are customer service and technical support?
I have not directly experienced the technical support. It's not part of my job to be involved on those kind of issues, but we constantly receive information as a partner from them and we are very in good touch with them and with the people we are working with, meaning the representatives that are within the Latin American market, which is where I work. They are very open and very fast with communication.
How was the initial setup?
The initial setup is easy. Full deployment takes a few weeks. The initial deployment for the first initiatives might take weeks. It's not complex, really. You may have it loaded after a full day and already providing results or interacting, but there are some other companies that have to be implemented to extract and consume the information from the database. But it's very easy.
Which other solutions did I evaluate?
There have been a couple of other solutions that we've been participating in the evaluation process of and some others that have been included in the decision process, including Redshift from AWS and also Azure Synapse from Microsoft.
For instance, AWS Redshift looked like it was easier to implement and to be adopted by the technical users, the programmers and database programmers. So far it has been far easier to adapt this technology. I'm not saying that AWS is a better technology. It's very complex, but at least what I've seen is that for them, it looks like it's been easier to use the first time.
We liked that Snowflake is able to be used as a multi-Cloud service - it can be used in AWS Cloud, Azure Cloud, or Google Cloud. Whereas AWS, or even Synapse, can only be used in their corresponding networks.
What other advice do I have?
I would definitely recommend Snowflake.
On a scale of one to ten, I would give Snowflake an eight.
I give it an eight out of 10 due to its room for improvement in the user interface for the monitoring of the credit consumption and that the user experience is not friendly. And also because the machine learning is lacking some advanced analytic features.
Which deployment model are you using for this solution?
Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
Data Architect and ETL Manager at a manufacturing company with 10,001+ employees
A stable data warehousing solution that is simple to set up and has good support
Pros and Cons
- "The initial setup is very simple."
- "We would like to see more security including more masking and more encryption at the database level."
What is our primary use case?
We use Snowflake for data warehousing.
What needs improvement?
We would like to see more security including more masking and more encryption at the database level.
For how long have I used the solution?
We have been using Snowflake for three months.
What do I think about the stability of the solution?
Stability-wise, this product is good.
What do I think about the scalability of the solution?
Snowflake is quite scalable. We have four people who are using it.
How are customer service and technical support?
So far, technical support has been good.
How was the initial setup?
The initial setup is very simple.
What other advice do I have?
My advice for anybody who is implementing Snowflake is to start small, then prove out the value and you can grow.
I would rate this solution an eight out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Scientist at a computer software company with 5,001-10,000 employees
Good performance and it is easy to write queries
Pros and Cons
- "The querying speed is fast."
- "We would like to have an on-premises deployment option that has the same features, including scalability."
What is our primary use case?
I work as a data scientist and our primary use of Snowflake is for machine learning.
Recently, we were trying to extract data to determine the best configuration settings for one of our products.
What is most valuable?
As it is SQL-like, it is easy to write queries.
The querying speed is fast.
What needs improvement?
We would like to have an on-premises deployment option that has the same features, including scalability.
For how long have I used the solution?
I have been working with Snowflake for six or seven months.
What do I think about the stability of the solution?
From what I have seen and heard, I think that Snowflake is pretty stable. I haven't faced any such problems, myself. I am not aware of the entirety of the lifecycle, but I haven't heard any complaints.
What do I think about the scalability of the solution?
My impression is that this product is pretty scalable.
How are customer service and technical support?
I have not been in contact with technical support, although my team has been and they are okay with it. My impression is that they are good.
What's my experience with pricing, setup cost, and licensing?
The pricing for Snowflake is competitive.
What other advice do I have?
My advice for anybody who is considering implementing Snowflake is that from a user's standpoint, it is a good product. Having a database in a cloud setup means that you don't have to scale and it has got many features already included.
For our use case, we found this Snowflake was good enough and did not need any enhancements. I recommend using it.
I would rate this solution 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: Partner
Associate Data Engineer at a outsourcing company with 201-500 employees
Cheapest tool available in the market for data warehousing
Pros and Cons
- "The tool is very easy to use. The solution’s desktop features are also very easy to use. Also, the product’s SQL-based connectivity is also good. It can connect with any tool."
- "Snowflake needs to improve its programming part. Though the tool has Snowpath, it doesn’t support all features like its competitor, Databricks. Snowflake doesn’t support external data ingestion capabilities. You need to have third-party tools for that. Also, the tool needs to incorporate data integration features in its future releases."
What is our primary use case?
We use the product as a data warehouse.
What is most valuable?
The tool is very easy to use. The solution’s desktop features are also very easy to use. Also, the product’s SQL-based connectivity is also good. It can connect with any tool.
What needs improvement?
Snowflake needs to improve its programming part. Though the tool has Snowpath, it doesn’t support all features like its competitor, Databricks. Snowflake doesn’t support external data ingestion capabilities. You need to have third-party tools for that. Also, the tool needs to incorporate data integration features in its future releases.
For how long have I used the solution?
I have been working with the solution for two years.
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 product is scalable. You can scale the solution’s computation and storage features separately.
How are customer service and support?
My company is a direct partner of the product. We have a lot of Snowflake experts who can resolve any doubts. Hence, I haven’t felt the need to contact customer service and support.
How was the initial setup?
The solution’s setup is easy since it's a SaaS product. The tool’s deployment is fast and wouldn’t take more than two minutes.
What's my experience with pricing, setup cost, and licensing?
Snowflake’s pricing is transparent. It is one of the cheapest cloud database warehouse providers. The tool follows a credit cost model. Everything on Snowflake is charged on the basis of credits. The credits depend on the cloud region and the public cloud provider that we use. Hence, the cost per credit will be different for AWS in Frankfurt and AWS in India. I think North Virginia is the cheapest region in terms of cost per credit. You will be consuming around 16 credits for large data warehouses.
What other advice do I have?
I would rate the solution a nine out of ten. Snowflake is the market leader in data warehousing and cloud database. I don’t think that it has a direct competitor. I would suggest you give Snowflake a try if it fits your use case. You can open up a trial version for 45 days and convert it to a regular account. There are different tiers in the solution like business critical, standard, etc. The tool gets updates every week.
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.
Lead Data Analyst at a wholesaler/distributor with 1,001-5,000 employees
Feature-wise complete, good speed and performance, and easy to configure
Pros and Cons
- "Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
- "Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution."
What is our primary use case?
It was only a workshop with training to know the tool. We were just testing the technology, and it was just a demo of the tool. We wanted is to connect switches with IoT and use Snowflake as an engine to process all the big data. It was on top of AWS, but our infrastructure is on top of the Google Cloud Platform.
The intention was to see if we can process on the front-end that we have. We have a console that processes a big amount of data. Instead of using BigQuery, we used Snowflake to see if it is cheaper than using BigQuery, but Snowflake wasn't cost-effective. In the end, we didn't go for this solution. We just saw how it can be implemented, but we never bought anything.
How has it helped my organization?
We don't have a metric, but I would say that the processing time was a key benefit and value-add. It provided on-time processing.
What is most valuable?
Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit.
What needs improvement?
Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution.
What do I think about the scalability of the solution?
Its scalability is great. We have data processing of one terabyte per month.
How was the initial setup?
It was not complex. Our implementation strategy was to put Snowflake on top of Google Cloud solutions instead of BigQuery, but BigQuery was better in price. So, BigQuery won in this case instead of Snowflake.
What about the implementation team?
We got the guidance directly from Snowflake. They have a technical expert for Latin America.
What's my experience with pricing, setup cost, and licensing?
We used Snowflake to see if it is cheaper than using BigQuery. It was just to maintain the cost or the KPI regarding the cost of connectivity by users. Snowflake wasn't cheaper than BigQuery, and its affordability was the main issue.
What other advice do I have?
My advice is to consider Snowflake when you have more customers. I wouldn't consider Snowflake until I have sufficient customers.
Whether we will consider Snowflake in the future depends on how BigQuery behaves. If the cost of BigQuery starts increasing and becomes similar to Snowflake, we're going to switch. If not, we're going to remain with BigQuery.
We might also consider other similar solutions, such as Yellowbrick, or switch to another cloud solution, such as Azure or AWS, depending on the price. Right now, we are paying about $2,000 per month. Our goal is to have the total cost of everything to be around $3,000 per month. It is more or less our goal for KPI kind of thing.
I would rate Snowflake an eight out of ten.
Which deployment model are you using for this solution?
Private 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.

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