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 is highly stable and reliable, offering excellent scalability and performance with fast data processing capabilities.
Snowflake allows seamless integration and connection with multiple data sources, making data sharing and collaboration straightforward.
With advanced features like Time Travel and Zero Copy Cloning, Snowflake enhances data management and recovery processes.
The platform separates compute and storage, optimizing costs by charging only for actual usage.
Snowflake reduces infrastructure management needs, offering a cloud-native solution that automates many maintenance tasks, resulting in lower total cost of ownership.

CONS

Snowflake's initial setup complexity varies based on data ingestion patterns and use cases, especially when handling semi-structured data.
Snowflake lacks support for SQL language-based stored procedures and does not natively facilitate external SQL ecosystems.
Migration from other databases to Snowflake, especially with OLTP features, can be challenging due to differences in stored procedure languages and structures.
Snowflake does not fully support integration with third-party tools, making ETL processes cumbersome.
Snowflake's cost is seen as high and requires better cost transparency and monitoring to avoid unexpected expenses.
 

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: September 2026.
914,322 professionals have used our research since 2012.
Hemanthreddy Vakiti - PeerSpot reviewer
Junior Data engineer at a tech vendor with 10,001+ employees
Jun 6, 2026
Since we are using Snowflake, it has improved the speed and reliability of our analytics processes, which is key to any data engineering or data warehousing project.
Sep 24, 2026
Snowflake's data sharing capability with other enterprises is the best feature they offer, which is excellent for us as a software company.
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.
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.
SD
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.
VivekSingh 1 - PeerSpot reviewer
Senior Enterprise Architect at Boston Scientific
Sep 11, 2024
In addition to the database, Snowflake also provides ingestion capabilities.
 

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: September 2026.
914,322 professionals have used our research since 2012.
Hemanthreddy Vakiti - PeerSpot reviewer
Junior Data engineer at a tech vendor with 10,001+ employees
Jun 6, 2026
One main area for improvement in Snowflake is cost visibility and optimization; while it's flexible and scalable, costs can increase quickly if warehouses are left running unnecessarily or workloads are not monitored carefully, raising the costs of the tool.
Sep 24, 2026
However, Snowflake has been the biggest mistake we have made since we started the company.
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.
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.
SD
Technology Leader at eTCaaS
Dec 26, 2024
Cost reduction is one area I would like Snowflake to improve. 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.
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.