# Page 3 | Snowflake Reviews 2026. Verified Reviews, Pros & Cons | Capterra > Page 3 - Is Snowflake the right Data Warehouse solution for you? Explore 96 verified user reviews from people in industries like yours to make a confident choice. Source: https://www.capterra.com/p/148267/Snowflake/reviews --- Snowflake 4.7 (96) [View alternatives](https://www.capterra.com/p/148267/Snowflake/alternatives/) Provider data verified by our Software Research team, and reviews moderated by our Reviews Verification team. [Learn more](https://www.capterra.com/our-story/) * * * Last updated April 8th, 2026 # Page 3 - Reviews of Snowflake ## Showing most helpful reviews Showing 51-75 of 96 Reviews Sort by: Most Helpful Rating Company Size Reviewer's Role Length of Use Frequency of Use VR Verified Reviewer Performance/Optimization Lead - Global Data Management Pharmaceuticals Used the software for: 1-2 years ### "Did a proof of concept for my company comparing Snowflake to other databases that we use." December 26, 2017 5.0 Pros The three features of many great features that stand out are: -The REAL separation of compute and storage gives the ultimate flexibility. You can match workloads to the proper level of compute without having one workload collide with another. You can optimize what you spend by only using what you need with the ability to change the size of your compute multiple times a day and the ability to stop and resume compute nodes easily. -No other database I have ever used can handle concurrency like Snowflake. Additional clusters are automatically spun up if a query is queued -There is no tuning that needs to be done as this is a data warehouse as a service. No other database comes close to the Snowflake performance without additional tuning. I can put in some time and tune my Oracle, Teradata or HANA database to get similar or slightly better performance but the level of DBA needed to do this is costly. This is especially helpful when the query patterns to be run against the database are unknown. Cons One of the positives above can also be a negative. Snowflake is a service and not software that you can run in your own data center or your own cloud VPC. This CON can be overcome with end to end encryption where you own the key and other Snowflake features. Review Source Nitin P. Product Analyst Information Technology and Services Used the software for: 1-2 years ### "Great data warehouse software" April 14, 2022 5.0 Pros Snowflake is being utilized as a data warehousing system based on cans. We're utilizing Snowflake and additional tools like HVR and Dell Boomi to create a data lake. Currently, different business teams are using different systems for reporting and analytics purposes. We're now working on a centralized solution for the entire company. Cons Snowflake has its limitation when dealing with unstructured data Review Source LD Likhitha D. Data analyst Computer Software Used the software for: 2+ years ### "A cloud based Data platform" May 28, 2024 4.0 Pros Ease to access because of its cloud based platform Roles can be easily assigned Cons UI when we scroll to the bottom of the results and go to a different worksheet and come back the page displays the top of the results which is very annoying Review Source Pinki K. Manage Data in Snowflake Data Warehouse Computer Software Used the software for: 6-12 months ### "Fast and easy Data warehouse." October 16, 2022 4.0 Its been very good experience to use snowflake. Our product performance is increased by using this tool. Pros Its very fast and easy to use. Execution of query is very fast and manage caching for improving performance. For getting data from different different databases its easy to get the data with snowflakes. Cons As I have used Sql server so some times it’s difficult to find syntax. Finding error if you have long query and showing ambiguous error then its very difficult to resolve as not suggest any line number. Tabs are not movable which I don’t like. Review Source RM Ryan M. Senior Research Analyst E-Learning Used the software for: 6-12 months ### "Snowflake is a great way to store data" July 7, 2022 5.0 It has been very positive. The primary motivation for the switch is the price and although I wasn't involved in those pricing discussions, it seems that everyone at my company is happy with the price and the value for the price. Pros I like that it has a really good interface that is easily accessible. We were using AWS before this and it was really hard to get the connections right. Keeping track of the drivers and everything was really complicated and I never got it to work as seamlessly as Snowflake Cons I don't know if there are any data visualizations that I could do in the program. That would be a cool value add. If that feature already exists, then I apologize to Snowflake. Another quirk is that not everything worked in the exact way that I wanted it to. There were some weird syntax things that didn't allow me to directly transfer my AWS queries, I had to go through and change them and there is one query that I still cannot figure out where the translation error is. Switched from [Amazon Redshift](https://www.capterra.com/p/227349/Amazon-Redshift/) Price Review Source VR Verified Reviewer Senior Manager Information Technology and Services Used the software for: 2+ years ### "Snowflake - Speed in the Cloud!" November 20, 2019 5.0 Maintaining on-premise database systems is expensive and maintenance heavy. Moving to a cloud database like Snowflake cuts down costs and is easy to maintain also. Since Snowflake supports a variety of flat file formats as sources, it becomes easier to bulk load data as flat files in storage spaces like AWS S3. Migrating data from cloud storage to Snowflake becomes much more easier. Pros Snowflake is a database and a storage warehouse on the cloud. Since it's scalable on demand, retrieving data through Snowflake Warehouses is lighting fast. All the computing power required to run the SQL queries are taken care by the Warehouse size we choose. If a query is taking too long to run a quick switch to a bigger warehouse does wonders. Migrating and loading data into Snowflake is a breeze too via Snowflake Stages and COPY TO commands. Cons Snowflake doesn't enforce constraints, especially primary keys. So, care should be taken while doing INSERTs and UPSERTs to maintain data integrity. This lack of this feature is understandable since it's projected more as a storage warehouse. Review Source VR Verified Reviewer Security Sr. Manager Architecture & Planning Used the software for: 6-12 months ### "Excellent enterprise product for scaled data analytics" September 10, 2021 5.0 Pros Snowflake Marketplace is well thought out and the data connector fabric is easy to understand and implement Cons Initial upfront documentation was a little difficult to navigate but once we got a hang of it, setting up everything else was relatively simple Review Source SS Shreyansh S. Freelancer Computer Software Used the software for: 6-12 months ### "Review for Snowflake" September 22, 2021 5.0 Snowflake is very appropriate assuming your association needs to begin little with negligible speculation, and afterward develop at any speed. It is additionally useful for groups that definitely know SQL from chipping away at another stage, like MS SQL Server. It matches all around well with incorporation errands on account of its local capacity to deal with JSON information, for both import and questioning. In the event that your instruments can just associate by JDBC (no local Snowflake connector) you might have a few issues with enormous informational collections. This is actually a restriction of utilizing JDBC, not Snowflake, but rather it is something to know about. Pros This is a cloud-based application that gives me a safe stage to the simple sharing of information with my customers. I feel sure to associate with my various colleagues as a result of its high level security and successful programming. Through this instrument, I am equipped for incorporating, dissecting, and the whole information in an exact structure and with investigation also, because of which I generally have a straightforward thought regarding the information extraction and its exchange from numerous mists. Cons Security jobs and access are difficult to comprehend and oversee Rollout of new components appears to intensely support US West coast, every other person needs to pause Visual interface doesn't permit you to oversee custom capacities and schedules. For those, it is code as it were. The board of tables and perspectives is visual Review Source RG Robert G. Developer Construction Used the software for: Less than 6 months ### "Solid Modern platform for EDW" April 28, 2022 4.0 Their customer service and training have been solid - I think MS takes the edge here for training but Snowflake wins for customer service (at least on non-business critical issues) Pros Exceptionally easy to scale up or out based on needs, and some nice cost-saving features like auto-suspend/resume for compute stuff. It supports ANSI SQL so it's not the end of the world to port over code from legacy SQL platforms. It also has a ton of integrations with your cloud provider of choice (as long as it's GCP, AWS, or Azure). According to their roadmap it will support Python eventually as well as their current SQL and JavaScript syntax for stored procs. Just a ton of functionality out of the box. Cons Pricing isn't the MOST transparent at first glance, but is fairly intuitive/controllable once you understand it . The current WebUI is absolute garbage. Luckily that's being deprecated for "Snowsight". Role inheritance and object ownership also has a decent learning curve compared to SQL Server, for example. This isn't a knock against Snowflake, but users should not expect this to have the same sort of OLTP-type performance and a typical relational DBMS. Just know the limits. Alternatives considered [Azure Synapse Analytics](https://www.capterra.com/p/170434/SQL-Data-Warehouse/) Reason for choosing Snowflake Multi-Cloud capabilities, more mature ecosystem, Data Marketplace Review Source Nathan Patrick T. Chief Information Officer Health, Wellness and Fitness Used the software for: 1-2 years ### "A Promising Solution Marred by Poor Support and Pricing Structure" April 30, 2020 4.0 From the tech support side, some of the engineers did not know the product well. It took several conversations to resolve simple issues. Pros The ability to load data in using tools like Alteryx is a major plus. Snowflake also integrated well with our data science platform. The management of users and access was very simple to use and understand. Cons Building out incremental loading was difficult and did not save us time in comparison to our incumbent solution. The pricing structure for usage was nebulous. We did not fully understand the pricing model until that renewal period at the end of the year which included fees that were not mentioned during the sales process. Alternatives considered [Azure Synapse Analytics](https://www.capterra.com/p/170434/SQL-Data-Warehouse/) Reason for choosing Snowflake At the time, Snowflake offered a product that appeared less expensive with comparable features. In the end, it was just as costly and the features did not fulfill our needs. Review Source AK Andrew K. Senior Program Manager, Data Operations Information Technology and Services Used the software for: 6-12 months ### "Great SQL interface, especially for novice users" December 1, 2020 5.0 Overall it's been very easy to get onboarded and up to speed using snowflake. At my last company, their SQL platform was so complicated I was too intimidated to use it, so I would always have to ask analysts for help getting the data I needed. With Snowflake, I feel that everything I need to do is straightforward, or easy to figure out with some trial & error and reading the documentation. I've even gotten several complete SQL-newbie colleagues to begin using Snowflake and they've had a great experience as well. Pros Snowflake's Worksheets interface is easy for SQL novices to figure out because it's simple and straightforward, which is exactly the opposite of many competitors. On other platforms, novices are easily intimidated because of the complexity, but Snowflake does a great job of keeping it simple and clean. Their documentation is also good, but it's not as novice-friendly as I would like. Cons Script error messages could be more specific and helpful with identifying errors and troubleshooting. For example, linking directly to the relevant section of their documentation, based on the type of error. Again, this is something that advanced users probably wouldn't mind too much, but for novice or even intermediate users, this can be the difference between spending a few minutes troubleshooting versus hours of head-scratching. Review Source EM Emmet M. Staff Software Engineer Information Technology and Services Used the software for: 6-12 months ### "Skip Redshift, Snowflake scales reliably" August 25, 2020 5.0 Snowflake supports both our analytics (dashboards and ad-hoc queries) and machine learning, including PySpark clusters. Our data scientists have found it a pleasure to work with, with rich analytics query support. The cloud-based technical architecture provides significant advantages over other offerings, including the critical ability to segment usage patterns and scale reliably. Pros We switched from Redshift to Snowflake for two primary reasons: 1. Snowflake's virtual warehouses allow scaling reliably, whereas Redshift becomes unstable; 2. First-class JSON support. Having switched to Snowflake, data warehouse administration has gone from nightmare to almost nothing. We continue to scale our data and analytics, and Snowflake handles it easily. Cons Snowflake's approach to sales and support is a blend of on-demand cloud offering and enterprise tool. They could improve certain aspects, such as simplifying the set up of Snowpipe to stream data from AWS. But these are minor features involved in initial setup. Review Source UL Urvashi L. Programmer Analyst Information Technology and Services Used the software for: 6-12 months ### "Snowflake in AIA" February 4, 2024 5.0 Pros The ease of using this software. It’s very easy and functional for data work. As a beginner of SQL , you can still smoothly use it. Cons I don’t have any complaints about this Software Review Source VD Vandit D. Business Analyst Management Consulting Used the software for: 6-12 months ### "Fast, Secure easy transition from sql" July 29, 2021 5.0 Overall the speed is ready incredible and I don't mind opening the csv and getting my results. Would've loved to have the option to view multiple outputs. Pros Processing is very fast, as someone who switched over from Microsoft Sql server this works very fast and has the same documentation. The documentation library is also very helpful and the forums are always readily available to compare commands from SSMS vs Snowflake Cons It doesn't let you customize column order after the results have been generated. It also downloads a csv everytime you want see the output which just creates more work. Review Source AH Aleksandr H. Sr. Software Engineer Computer Software Used the software for: 2+ years ### "Great Data Warehouse Product" August 1, 2022 5.0 This is a very good product. I've had a very good experience with Snowflake. Pros If you know SQL this is an easy product to use. I love that it can search on JSON and it allows us to create very custom User Defined Functions that can use multiple languages such as JS and Python as well as SQL. Cons Setting up the permissions can be confusing and complicated. Alternatives considered [Amazon Redshift](https://www.capterra.com/p/227349/Amazon-Redshift/) Reason for choosing Snowflake We chose Snowflake since it has a better feature set and was much more stable. Review Source VR Verified Reviewer Staff BI & Analytics Engineer Computer Software Used the software for: 1-2 years ### "Totally satisfied from Snowflake" October 20, 2022 4.0 Pros Configuring the Warehouses can give you endless possibilities. Cons There are some implicit casts in data types sometimes that seem to be the default behavior Review Source VR Verified Reviewer BI Developer Used the software for: 1-2 years ### "Snowflake is an affordable solution that enables analysts and non-technical folk to build DWs." March 12, 2018 4.0 We have a lean team of data engineers and as a result cannot automate as many data sources as we'd like. In the interim, our analysts utilize Snowflake to incorporate data into our multifaceted reports. Pros We use Snowflake to capture some of our larger third party data exports that won't fit into Google Sheets. The process of uploading data is straightforward and keeps our business reporting streamlined despite lean engineering resources on our end. There is a SQL interface to make modifications to data before final exports and data viz. Cons The UI is clunky and not the most intuitive. The error messages could be more detailed and expanded. The support for Mac seems to be more limited. Encountered issues with data produced via Mac and support took months to fully resolve. Review Source VR Verified Reviewer Tech Lead Information Technology and Services Used the software for: 1-2 years ### "Best cloud data warehousing solution for all reporting needs. " October 12, 2022 5.0 Pros We can schedule the data synchronization timelines, and store the data for analytical and reporting purposes. Cons I don't find any thing to dislike, it serves the purpose of data warehousing for reporting. Review Source VR Verified Reviewer SEO Manager Chemicals Used the software for: 1-2 years ### "Snowflake is an excellent choice for centralizing data and acting as a database "hub"" June 22, 2022 4.0 Pros Snowflake is incredibly flexible and versatile. There are numerous ways to get data into Snowflake, even if there is not already an API built out for the source. The tool has many pre-built integrations as well. Cons Though it is very flexible, one thing that Snowflake does not handle is unstructured data. This can be a problem if your sources heavily rely on this type of data. They say they are going to support it in the future, but as of right now, they do not. Review Source VC Vipul C. Data Engineer Marketing and Advertising Used the software for: 1-2 years ### "Vipul Chona - Snowflake Review" September 3, 2021 5.0 Pros very easy to integrate with all our other tools Cons Honestly having a tough time coming up with what I like lease. Maybe some of the UI Alternatives considered [Amazon S3](https://www.capterra.com/p/174285/Amazon-S3/)[Google Cloud](https://www.capterra.com/p/268690/Google-Cloud-Platform/) Review Source VR Verified Reviewer Cofounder & CTO Used the software for: 6-12 months ### "Best warehouse in the market " April 5, 2018 5.0 Pros It's fast. It's simple. It's scalable. And best of all, we saved forty percent from switching off of redshift. Cons You can't connect easily from a sql editor outside of their browser or the command line. That makes it less convenient. Review Source Catherine H. Analyst Financial Services Used the software for: Less than 6 months ### "Transition Extremely Difficult" June 16, 2020 4.0 The ramp up has been difficult. There are a couple key features missing that might overpower the strengths of the software. Pros The interface is very attractive, it is extremely fast to query huge datasets, and there is a strong online community of users to learn from. Cons I think it has the possibility to be a great software for querying huge databases, but some of the basic uses of that data are hard to come by - it is difficult to interface with Microsoft products. Review Source VR Verified Reviewer Strategy Intern Marketing and Advertising Used the software for: Less than 6 months ### "Fast, sleek, sexy" July 7, 2020 5.0 Grabbing data from our data warehouse is 10x more effective and way faster than it used to be. Snowflake is awesome. Pros Snowflake is a FAST alternative to a software like microsoft sql server. The data is well organized in the cloud, which allows you to pull from it quickly. SQL queries that used to take 20 minutes now only take 10 seconds. The interface is user-friendly and looks great. Cons There are a couple of nuances that you need to know when you start using Snowflake. If you have someone to help you learn the few things that are unique about writing code with snowflake, you won't have a problem. Switched from [Microsoft SQL Server](https://www.capterra.com/p/1417/SQL-Server/) Speed. Review Source TB Tanya B. Head of Marketing Health, Wellness and Fitness Used the software for: 6-12 months ### "Seamless experience connecting multiple clouds!" December 12, 2022 4.0 Pros We used Snowflake after multiple attempts with other clouds and to say it was powerful is the least. It connects all data sources and allows to create a solid data warehouse essential for all BI reporting etc. Cons Complicated Billing (on purpose?), sometimes waiting for query load can be long and bothersome, could still use UI improvements Review Source Nathan B. Product Manager Financial Services Used the software for: 6-12 months ### "A great example of a data warehouse solution" November 11, 2022 3.0 Pros I love how straightforward and performant the solution was Cons Data visualisation was a little lacking, meaning you had to tether to a system like Google Data Studio or Sigma/Tableau to make sense of the data Review Source Similar Products Featured ## Send me user reviews about this product ### Fill out the form and we'll send a list of the top-rated software based on real user reviews directly to your inbox.