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

Snowflake Analytics pros and cons

4.2 out of 5
Badge Leader

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

Advanced features like time travel, zero copy cloning, and scalability are most useful, providing significant ROI improvement.
Snowflake requires zero maintenance for data warehousing on the cloud and allows easy data recovery.
It offers scalability and flexibility, with completely decoupled computation from storage, enabling users to analyze substantial data volumes.
Snowflake's inbuilt infrastructure for executing queries, which scales automatically, along with concurrency and the ability to manage costs, provides a seamless experience.
Attributes like data sharing, cloning, time travel, and fail-safe make it convenient for business use and enhance operational efficiency.

CONS

Moving data from legacy systems to Snowflake is challenging and may face compatibility issues.
The cost of Snowflake increases significantly with extensive computations.
Integration with machine learning tools and AI could be enhanced to increase usability.
Snowflake lacks a comprehensive on-premises solution and requires improvements in support for on-premises deployments.
Snowflake's visibility on pricing is complex, making cost estimation challenging for users.
 

Snowflake Analytics Pros review quotes

Hemanthreddy Vakiti - PeerSpot reviewer
Data engineer at a tech vendor with 10,001+ employees
Jun 6, 2026
Snowflake Analytics has positively impacted our organization by saving about eight to ten hours per week, which we can use for advanced analytics and automation tasks.
Abhishek Ankush - PeerSpot reviewer
Ai Engineer at eligarf Technologies
Jan 8, 2026
Snowflake Analytics has played a major role in improving our data model transformations, increasing our productivity by allowing us to do things very quickly and receive results rapidly, and reducing the time and effort required for coding compared to traditional methods and Python.
reviewer2729628 - PeerSpot reviewer
Lead Analytics Consultant at a outsourcing company with 51-200 employees
Aug 13, 2025
The latest interface of Snowsight UI has added good capabilities and the interface is excellent.
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
900,838 professionals have used our research since 2012.
Paresh_Nayak - PeerSpot reviewer
Data Governance Architect at Sterlite Technologies Ltd
Apr 28, 2025
Snowflake Analytics has a bright future and is capturing the market across various domains such as life sciences, BFSI, and supply chain.
KamleshPant - PeerSpot reviewer
Senior Software Architect at USEReady
Jan 9, 2025
Snowflake has a streaming capability to work with real-time streaming data and delta tables.
Manoj Kambli - PeerSpot reviewer
Director at Hexaware Technologies Limited
Jun 27, 2024
Snowflake Analytics' predictive analytics elements, which incorporate AI, are good and easy to integrate.
AyindeHammed - PeerSpot reviewer
BI Developer at DivVerse LLC
Nov 27, 2024
One of the distinctive features of Snowflake is its ability to handle large datasets efficiently.
KR
Data Governance/Data Engineering Manager at National Bank of Fujairah PJSC
Mar 6, 2024
Scaling is very high – there's no problem for scaling purposes. The learning curve is very small. And there are a lot of advanced features like handling duplicates, security, data governance, data sharing, and data cloning.
PradeepSingh1 - PeerSpot reviewer
Director Of Operations at a outsourcing company with 10,001+ employees
Jul 19, 2023
Considering everything I have accessed, the product's dashboard is good since it provides multiple good options, including customization options.
Vimalathithan M - PeerSpot reviewer
Associate Director - Delivery (Technology DWH & Data Engineer) at MOBIUS KNOWLEDGE SERVICES PRIVATE LIMITED
Apr 5, 2024
One of the key advancements in Snowflake Analytics is data sharing.
 

Snowflake Analytics Cons review quotes

Hemanthreddy Vakiti - PeerSpot reviewer
Data engineer at a tech vendor with 10,001+ employees
Jun 6, 2026
One improvement Snowflake Analytics could benefit from is in cost, particularly during peak hours.
Abhishek Ankush - PeerSpot reviewer
Ai Engineer at eligarf Technologies
Jan 8, 2026
In my opinion, Snowflake Analytics can be improved by introducing more features, such as additional integration options.
reviewer2729628 - PeerSpot reviewer
Lead Analytics Consultant at a outsourcing company with 51-200 employees
Aug 13, 2025
We were experiencing errors while running reports and making connections.
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
900,838 professionals have used our research since 2012.
Paresh_Nayak - PeerSpot reviewer
Data Governance Architect at Sterlite Technologies Ltd
Apr 28, 2025
However, if it offered flexibility similar to Oracle and supported more heterogeneous data sources and database connectivity, it would be even better.
KamleshPant - PeerSpot reviewer
Senior Software Architect at USEReady
Jan 9, 2025
AIML-based SQL prompt and query generation could be an area for enhancement.
Manoj Kambli - PeerSpot reviewer
Director at Hexaware Technologies Limited
Jun 27, 2024
The pricing visibility is complex. If you understand pricing, you can estimate costs, but if not, it can be challenging.
AyindeHammed - PeerSpot reviewer
BI Developer at DivVerse LLC
Nov 27, 2024
Navigating the user console can be challenging, particularly when looking for details like the account ID.
KR
Data Governance/Data Engineering Manager at National Bank of Fujairah PJSC
Mar 6, 2024
Machine learning in Snowflake isn't as advanced as in other products. I haven't heard of any successful industry-wide use cases of machine learning implemented in Snowflake. It might take a couple of years to reach the same level as Databricks.
PradeepSingh1 - PeerSpot reviewer
Director Of Operations at a outsourcing company with 10,001+ employees
Jul 19, 2023
I cannot comment on the product's stability because we are still struggling with its performance.
Vimalathithan M - PeerSpot reviewer
Associate Director - Delivery (Technology DWH & Data Engineer) at MOBIUS KNOWLEDGE SERVICES PRIVATE LIMITED
Apr 5, 2024
Implementing everything on-premise is challenging because it require proper support from advisors, DBAs, and others.