No more typing reviews! Try our Samantha, our new voice AI agent.

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Snowflake demonstrates excellent performance with fast query speeds and scalability, allowing real-time access to data without downtime.
The separation of compute and storage provides flexibility, enabling users to scale resources independently based on their needs.
With strong data-sharing capabilities, Snowflake supports seamless integration with various data sources and offers features like dynamic scaling and Time Travel for versioning.
Snowflake's cloud-native architecture significantly reduces infrastructure management, offering cost efficiency and simplifying data operations.
The platform's advanced features, such as automated performance tuning and compatibility with multiple data formats, make data processing efficient and powerful.

CONS

Snowpipe auto-ingest is not fully automatic and requires improvements in connector fine-tuning to connect with system sources effectively.
The pricing and cost transparency of Snowflake is a major concern for users, as it appears to be higher compared to other options.
Snowflake lacks the support for SQL-based stored procedures, complicating porting stored procedures from other systems.
Users encounter challenges with data governance and access control, which could use enhancements.
There is a lack of built-in ETL and ELT functionalities, making users rely on third-party tools for these operations.
 

Snowflake Pros review quotes

SunilPatil1 - PeerSpot reviewer
Asset Builder at Genpact - Headstrong
Oct 27, 2025
We utilize Time Travel with Snowflake because this is a very useful feature; everyone finds it crucial because in conventional data platforms, it's very difficult to handle these kinds of things.
reviewer2403603 - PeerSpot reviewer
Senior Data Engineer at a tech services company with 11-50 employees
Nov 13, 2025
Snowflake has evolved significantly over time; initially, they started with scalability, but more recently, they have introduced streaming capabilities, real-time and dynamic tables, along with various connectors.
AmolDhormare - PeerSpot reviewer
Data Integration Developer at a tech services company with 1,001-5,000 employees
Jan 8, 2026
Snowflake has positively impacted us by making everything cloud-native, significantly reducing the systems and application running process.
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.
893,438 professionals have used our research since 2012.
Andrejs Nikitins - PeerSpot reviewer
Data Analyst at Mastercard
May 7, 2026
From my experience, Snowflake is the most stable, user-friendly, and simply the nicest tool that I have been working with, and I have had experience working with many databases and different solutions.
Snehasish Das - PeerSpot reviewer
Technology Leader at eTCaaS
Dec 26, 2024
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses.
Mikalai Surta - PeerSpot reviewer
Head of Big Data Department at IBA Group
Jul 9, 2025
The reduced infrastructure management is the big difference compared to on-prem warehousing with Snowflake Data Cloud.
reviewer1438647 - PeerSpot reviewer
Data Architect at a tech services company with 10,001+ employees
Apr 16, 2025
The technical support from Snowflake is very good, nice, and efficient.
VivekSingh 1 - PeerSpot reviewer
Senior Enterprise Architect at Boston Scientific
Sep 11, 2024
In addition to the database, Snowflake also provides ingestion capabilities.
reviewer1614864 - PeerSpot reviewer
Center Head - Goa Regional Delivery Center. at a tech services company with 51-200 employees
Sep 10, 2024
I don't think it is difficult to maintain.
AyindeHammed - PeerSpot reviewer
BI Developer at DivVerse LLC
May 13, 2024
The tool's performance is good. I think it's the best in the game right now. It usually charges per query. For example, if you run a SQL query on Snowflake with the same number of data records, it would take less than half the time compared to running it on Microsoft. It has good documentation. You can pick up Snowflake if you have previous knowledge of SQL.
 

Snowflake Cons review quotes

SunilPatil1 - PeerSpot reviewer
Asset Builder at Genpact - Headstrong
Oct 27, 2025
Currently there isn't end-to-end or B2B sharing of data.
reviewer2403603 - PeerSpot reviewer
Senior Data Engineer at a tech services company with 11-50 employees
Nov 13, 2025
If more connectors were brought in and more visibility features were added, particularly around cost tracking in the FinOps area, it would be beneficial.
AmolDhormare - PeerSpot reviewer
Data Integration Developer at a tech services company with 1,001-5,000 employees
Jan 8, 2026
Snowflake is very good overall, but it could improve documentation for supporting different structures.
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.
893,438 professionals have used our research since 2012.
Andrejs Nikitins - PeerSpot reviewer
Data Analyst at Mastercard
May 7, 2026
Snowflake can be improved in terms of its recent switch to a new user interface, which feels less intuitive compared to the old one.
Snehasish Das - PeerSpot reviewer
Technology Leader at eTCaaS
Dec 26, 2024
The product is not very cheap, and a reduction in costs would be appreciated.
Mikalai Surta - PeerSpot reviewer
Head of Big Data Department at IBA Group
Jul 9, 2025
Pricing is quite high for Snowflake Data Cloud, which is an area that could be improved.
reviewer1438647 - PeerSpot reviewer
Data Architect at a tech services company with 10,001+ employees
Apr 16, 2025
The billing doubles with size increase, but processing does not necessarily speed up accordingly.
VivekSingh 1 - PeerSpot reviewer
Senior Enterprise Architect at Boston Scientific
Sep 11, 2024
The addition of more AI capabilities in Snowflake would help us more.
reviewer1614864 - PeerSpot reviewer
Center Head - Goa Regional Delivery Center. at a tech services company with 51-200 employees
Sep 10, 2024
From an improvement perspective, Snowflake can evolve in terms of writing costly, expensive queries with less cost and try to see if pipeline development can be made a little easier.
AyindeHammed - PeerSpot reviewer
BI Developer at DivVerse LLC
May 13, 2024
I can only access Snowflake from the web. It would be better if we could have an app that we can install locally on our laptops to connect to the server without needing to go to the web page. Apart from that, it's hard to point out any limitations in the tool.