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's distributed architecture provides scalability and rapid data processing, making it capable of handling both structured and semi-structured data efficiently.
The separation of storage and compute in Snowflake enables independent scaling, ensuring cost-effectiveness and flexibility in resource management.
Data sharing features, such as Time Travel and cloning, allow for seamless data access and collaboration across various platforms, enhancing business operations.
Snowflake is renowned for its outstanding performance, providing fast query responses and the ability to quickly integrate with other systems.
Technical support from Snowflake is highly regarded, contributing to its usability as a managed service in the cloud with minimal maintenance requirements.

CONS

Snowflake needs to enhance its support for geo-spatial queries as its spatial features are limited.
Pricing remains a significant issue, with many customers finding Snowflake expensive.
There is a need to improve support for SQL-based stored procedures to ease migration from on-prem solutions.
ETL functionality in Snowflake requires improvement; it is currently inadequate compared to other tools like Talend.
Integration with external tools and more robust connectors are areas where Snowflake can advance to enhance user experience.
 

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,221 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,221 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.