---
title: "Snowflake Reviews 2026. Verified Reviews, Pros & Cons | Capterra"
description: "Is Snowflake the right Data Warehouse solution for you? Explore 97 verified user reviews from people in industries like yours to make a confident choice."
source_url: "https://www.capterra.com/p/148267/Snowflake/reviews/"
page_type: "reviews"
language: "en"
---

Snowflake

4.7 (97)

[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 September 17th, 2026

# Reviews of Snowflake

Ease of use

4.5

Customer Service

4.3

## Pros and Cons in Reviews

AF

Amanda F

Licensed Real Estate BrokerReal Estate, 2 - 10 employeesUsed the software for: More than 2 years.

“With Snowflake, I have been able to make informed business decisions by collecting, modeling and visualizing data across a wide array of sources.“

December 21, 2025

CC

Connor C

Data AnalystNon-Profit Organization Management, 51 - 200 employeesUsed the software for: 6-12 months.

“Some may to many tables did not import correctly and it was hard to find the right data“

March 16, 2026

CC

Connor C

Data AnalystNon-Profit Organization Management, 51 - 200 employeesUsed the software for: 6-12 months.

“Snowflake was super helpful automatically designing our necessary tables based on the data we uploaded.“

March 16, 2026

Rosario T

Sr. People OpsBanking, 51 - 200 employeesUsed the software for: More than 2 years.

“It does not provide a clear guide or manual on how to use it for our new hires to read and learn how to navigate it.“

October 31, 2025

AF

Amanda F

Licensed Real Estate BrokerReal Estate, 2 - 10 employeesUsed the software for: More than 2 years.

“It has been effective and super easy to model, visualize and share data among teams in my organization at the point of making business decisions.“

December 21, 2025

IW

Isla W

Marketing AnalystInternet, 10,001+ employeesUsed the software for: 6-12 months.

“It's not a huge deal, but it's a bit annoying.“

June 27, 2026

PS

Purvesh S

Full Stack EngineerFinancial Services, 2 - 10 employeesUsed the software for: More than 2 years.

“How it is super easy to store, query and analyze massive data without managing hardware is what I like most about Snowflake.“

January 12, 2026

WT

Wei Chun T

Data EngineerInformation Technology and Services, 51 - 200 employeesUsed the software for: 1-2 years.

“Bill is costly if warehouse cost is not monitored and alerts are not set.“

November 25, 2023

## Showing most helpful reviews

Showing 1-25 of 97 Reviews

Sort by:

Most Helpful

Rating

Company Size

Reviewer's Role

Length of Use

Frequency of Use

Brian M.  
Data Analyst  
Computer & Network Security  
Used the software for: 2+ years

### "Snowflake is a winner!"

January 12, 2026

5.0

I thought it was great. I would definitely recommend to all who are considering it an option. From ease of use to results.

Pros

I really appreciate the ease of use. In the beginning of my data analyst role, Snowflake was straight forward in understanding

Cons

The only real issue I had was the data return limits but am not entirely sure if that was a Snowflake issue or company threshold.

Review Source

David W.  
Head of Engineering - Data and BI  
Information Services  
Used the software for: 6-12 months

### "The incredible power of a cloud data platform"

March 29, 2022

5.0

We use Snowflake to aggregate hundreds and hundreds of disparate databases across many different clouds and platforms into one single data warehouse allowing us, for the first time, to give customers visibility of all their data across all our products.

Pros

The concept of Snowflake is so clever - mass amounts of micro-partitions of data, with the storage and compute separated. It is a smart product that enables so much functionality and capability. It is more than simply a database in the cloud, it is truly a feature-rich platform that offers a huge amount of functionality. I also very much like that role-based access is a fundamental part of it. Its data sharing features are terrific too.

Cons

Some things are a little tricky to figure out, like row-level policies the first time you do it, or data masking. There are no triggers. Scheduled tasks are a little limited. Stored procedures are not as simple as I'd like.

Alternatives considered

[Amazon Redshift](https://www.capterra.com/p/227349/Amazon-Redshift/)

Reason for choosing Snowflake

We found Snowflake to be a superior user experience with richer functionality.

Review Source

VR

Verified Reviewer  
System engineer  
Information Technology and Services  
Used the software for: 6-12 months

### "How snowflake is different from other data warehouses present in the market."

April 11, 2022

3.0

Used for monitoring large amount and data and also use for analysis purposes for taking business decisions for the companies.

Pros

The best thing is snowflake is a cloud based Warehouse system.and it’s completely based on shares nothing architecture so its gives faster performance during analysis.one more thing i like about this warehouse that the amount of time that you use the main warehouse here for that specific period of time you have to pay other than the warehouse is off for normal queries.particularly in dml statement mainly its uses the warehouse.so its manage automatically weather to use warehouse or not so it is very much good for saving money That’s why now big giants company are shifting towards snowflake for cost effective purposes and the smarter and faster performance it gives.and it also provides a feature call time travel where you can back up your all deleted data in a period of 90 days.

Cons

There are two things I don’t like about the snowflake is it’s doesn’t support unstructured data loading it’s only support the structure and semi structure data. And other one is it’s only support the bulk loading files so it’s difficult for a small size files loading or adding some few columns on it.

Switched from

[Vantage](https://www.capterra.com/p/133231/Teradata-Database/)

Need more faster and cost effective warehouse for managing data and analysing the data that’s why sifted from teradata to snowflake.

Review Source

IW

Isla W.  
Marketing Analyst  
Internet  
Used the software for: 6-12 months

### "Fast Queries and Scalable Storage, Minor Access Control Hiccups"

June 27, 2026

5.0

Pros

The ease of scaling compute independently of storage is fantastic. We've been able to handle much larger datasets than before without massive upfront infrastructure costs. Plus, querying large amounts of data is genuinely fast. Our marketing analytics workflows are so much smoother now.

Cons

Setting up role-based access controls took a bit to figure out, and the documentation could be clearer on some of the finer points. Sometimes it feels like you need to be a security expert just to grant basic permissions. It's not a huge deal, but it's a bit annoying.

Review Source

PS

Purvesh S.  
Full Stack Engineer  
Financial Services  
Used the software for: 2+ years

### "Robust Data Warehouse of this Era"

January 12, 2026

4.0

Data warehousing is the main benefit that I experience when using Snowflake - I am able to analyze structured and unstructured data in one place.

Pros

How it is super easy to store, query and analyze massive data without managing hardware is what I like most about Snowflake. Data sharing and collaboration is another thing that I rank high about Snowflake.

Cons

Even though the learning curve was a bit steep, I am now used to it and currently there hasn’t been any new feature to customize.

Review Source

AF

Amanda F.  
Licensed Real Estate Broker  
Real Estate  
Used the software for: 2+ years

### "Know More ‘bout Snowflake Prior to Implementation "

December 21, 2025

5.0

It has been effective and super easy to model, visualize and share data among teams in my organization at the point of making business decisions.

Pros

It is my second year using Snowflake in the real-estate agency. With Snowflake, I have been able to make informed business decisions by collecting, modeling and visualizing data across a wide array of sources.

Cons

It has a quite learning curve, but the vendor offered free support - the best thing is how the vendor sends free ebooks for customization whenever they incorporate new features

Review Source

VR

Verified Reviewer  
Sr. People Ops  
Banking  
Used the software for: 2+ years

### "Great data warehouse platform for multi"

October 31, 2025

4.0

Pros

Snowflake is easy to use and implement. It allows the rest of the company to manage their databases and tables to run reports and dashboards on their processes. Since we integrated it with Sigma Computing, we are able to pull data connections and run analysis pretty easy.

Cons

It does not provide a clear guide or manual on how to use it for our new hires to read and learn how to navigate it.

Review Source

VR

Verified Reviewer  
Program Manager, Customer Experience  
Logistics and Supply Chain  
Used the software for: 2+ years

### "Snowflake Gets it Done"

September 25, 2025

5.0

I leverage snowflake tables in almost every aspect of my job day to day. It's unlocked unprecedented visibility into our operation, helping us execute much more effectively

Pros

integrates incredibly easily into our BI tools, allows for easy setup of new tables, can be pickedup without much advance training. Helps us build all of our data dashboards and manage our analysis

Cons

It's so easily integrated into other tools, it can be tough to know what native functionality Snowflake offers as well (i.e. LLM connectivity)

Review Source

JS

Juan S.  
Senior Consultant  
Chemicals  
Used the software for: 2+ years

### "Clean, modern interface with scalable analytics"

August 19, 2025

5.0

We centralized data control, made ELT easier, and provided stakeholders with trusted dashboards. Query performance improved, and teams make quicker decisions, strong day-to-day value following best practices being established.

Pros

Snowflake speeds up data analysis and collaboration with almost instantaneous scaling, open dashboards, and easy data sharing. The interface is clean, and role-based access ensures sensitive datasets are protected while teams query without tripping over one another.

Cons

There is ramp-up in cost controls, roles, and warehouses areas. Customer support is instructed but can be behind on more in-depth performance or billing matters, so close governance and monitoring are crucial in the early stages.

Review Source

CC

Connor C.  
Data Analyst  
Non-Profit Organization Management  
Used the software for: 6-12 months

### "Great system, tough to interact with"

March 16, 2026

4.0

Overall, the system has a good structure, but we have had a few experiences that have made our time with snowflake harder

Pros

Snowflake was super helpful automatically designing our necessary tables based on the data we uploaded. Having so many connections has been incredibly helpful to utilize our data wherever we need.

Cons

The most difficult part was trying to find the data in the new system. Some may to many tables did not import correctly and it was hard to find the right data

Review Source

VR

Verified Reviewer  
Senior Associate  
Accounting  
Used the software for: 1-2 years

### "Powerful tool for data analysis "

September 13, 2025

4.0

Pros

The ability to query data in real time and the multitude of dimensions that can be analyzed using the system

Cons

The complexity of the UI when you first begin using it. There’s a very high volume of layered clicks.

Review Source

HS

Harpreet S.  
Continuous improvement specialist  
Automotive  
Used the software for: 6-12 months

### "Snowflake data hub"

January 16, 2025

5.0

Pros

Easy to store your queries and with some guide non te hnical user can easy navigate

Cons

This software js great and i donot think there is any issue

Review Source

MG

Mithun G.  
PM  
Computer Software  
Used the software for: 2+ years

### "Modern warehouse on cloud technology"

July 31, 2022

5.0

Overall if I ignore the cost factor, I am very much satisfied with Snowflake and with the features and capabilities it exposes. For a fast growing DataWarehouse, Snowflake is a very good choice as it is secure, robust and scalable.

Pros

Snowflake is very easy to use and can easily connect to different cloud platforms like AWS, GCP and Azure. The fact that it can be hosted on any of these platforms makes it portable and easy to use. The access and security is very flexible and scalable. The fact that storage and compute are separate makes it ideal for use with big data warehouses where usage can be monitored easily and can be charged back ti the appropriate business unit. More and more features are getting added to it which makes it a flexible, scalable data warehouse in cloud.

Cons

The warehouse currently does not support procedural languages and some of the datatypes do not align with some other popular databases which makes it difficult for migration to Snowflake. The cost is little bit on the higher side.

Review Source

VR

Verified Reviewer  
Sr. Data Engineer  
Telecommunications  
Used the software for: 2+ years

### "Snowflake: Modern OLTP DB"

February 20, 2023

5.0

Great to have snowflake as out OLTP system. High volume data processing are happening real quick.

Pros

Performance is outstanding. No explicit maintenance is needed. High availability. No need to worry about SQL processing speed, easy scalability.

Cons

Quit expensive while comparing to other database.

Alternatives considered

[Databricks](https://www.capterra.com/p/148499/Databricks/)

Reason for choosing Snowflake

Easy maintenance and high performance.

Review Source

VR

Verified Reviewer  
Associate Director  
Marketing and Advertising  
Used the software for: 1-2 years

### "An outstanding data warehouse tool I have used so far "

June 17, 2024

5.0

Pros

1\. Exceptional design on dashboard and easy controls 2. No maintenance (Logs, Tuning etc) required 3. Pay per use model

Cons

1\. Expensive indeed 2. UI navigation needs to improve 3. Should be more flexible for integrations

Review Source

Matthew C.  
Director, Professional Services  
Marketing and Advertising  
Used the software for: Less than 6 months

### "Impressive product with a promising future"

June 24, 2021

4.0

Overall, Snowflake has made managing, processing, aggregating and sharing data easier across the organization. It still has some work to do in terms of UI to make the user experience smoother, but the underlying technology at its core is solid and solves many issues with backups, data retention and overall user error in working with data.

Pros

The "Time Travel" aspect of Snowflake, being able to pick a point in time and see the state/contents of nearly any table is astonishing. Very useful and impressive feature. What is equally as impressive is the overall performance of the platform. I've worked with Oracle, DB2, MySQL, Vertica, Teradata, ParAccel, and others. Maybe not always in the most optimal configurations, but Snowflake's performance has been overall the best in my experience.

Cons

As a newer platform, there are certain convenience elements that Snowflake lacks. - No auto-complete of object names. - No "easy" import wizard to import data. - Some bugs with the browser-based interface (worksheets did not properly save). - Limited customizations to filter out the tables or objects you don't work with regularly. Always shows full list, oftentimes very large.

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

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

Uddipan M.  
Senior data Engineer  
Computer Software  
Used the software for: 1-2 years

### "Snowflake - The next generation cloud data warehouse"

August 9, 2021

5.0

It's really great, Snowflake offered a lot of flexibility which parallel cloud-based warehouses could not offer the same. Snowflake can scale both vertically and horizontally to cater all needs.

Pros

Snowflake is very easy to use and scale. It provides helpful features like merge, JSON flattening which are very handy options. Snowflake cloud SQL editor is very fast and helps easy developments.

Cons

It can be a costly solution if optimizations are not planned accordingly.

Review Source

JM

Jasmine M.  
Operations Analyst  
Investment Management  
Used the software for: 6-12 months

### "Snowflake review"

July 29, 2024

5.0

Pros

I really liked the easy use of snowflake as a SQL coder. It made my work very easy and I liked that there were tutorials and suggested corrections.

Cons

I did not like having to switch between different user roles in order to access certain files, but I think this was because of my company.

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

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

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.