Try our new research platform with insights from 80,000+ expert users
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

Snowflake Analytics offers inbuilt infrastructure for executing queries without managing data volume, ensuring zero maintenance for data warehousing on cloud systems.
Features like time travel, zero copy cloning, data sharing, and scalability are highly useful for business intelligence and analytics.
The performance and computational power are strong, with the ability to handle large datasets efficiently and provide concurrency.
Snowflake Analytics is cloud-based, allowing fast deployment and eliminating the need for physical servers while being highly scalable and user-friendly.
It supports advanced features for data analysis such as materialized views and streaming capabilities for real-time data handling.

CONS

End-to-end execution of jobs isn't possible with Snowflake Analytics, requiring customization.
Moving data from legacy systems to Snowflake Analytics is not straightforward, and compatibility issues with processors can arise.
The cost becomes significant if there are many computations.
Snowflake Analytics lacks an on-premises option, making deployment challenging and reliant on external support services.
Improving integration with machine learning tools and AI could enhance Snowflake Analytics' usability.
 

Snowflake Analytics Pros review quotes

Jyothirmai Gopereddy - PeerSpot reviewer
Azure Manager at Tredence Inc.
May 29, 2022
Snowflake Analytics' most valuable feature is its inbuilt infrastructure for executing queries, which I don't have to manage based on my data volume as it's taken care of by Snowflake.
AK
Database administrator terdata at a tech vendor with 10,001+ employees
May 29, 2022
The advanced features like time travel, zero copy cloning and scalability have been most useful. Snowflake requires zero maintenance for Data Warehousing on the cloud system.
AnujJain - PeerSpot reviewer
AVP Data Engineering at Genpact - Headstrong
May 31, 2022
The performance has been good.
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,477 professionals have used our research since 2012.
MandarGarge - PeerSpot reviewer
V.P. Digital Transformation at e-Zest Solutions
Jun 29, 2022
Very good flexibility and it offers computation completely decoupled from the storage.
reviewer1554165 - PeerSpot reviewer
Data engineer manager at a tech vendor with 10,001+ employees
Jun 20, 2022
What we found most valuable in Snowflake Analytics are its attributes that are very convenient for business use such as data sharing, cloning, time travel, and fail-safe. It's a good product all in all.
Jayanta Datta - PeerSpot reviewer
Executive Director at Morgan Stanley
Jul 3, 2022
The most valuable feature of Snowflake Analytics is its performance.
Al Krause - PeerSpot reviewer
Managing Director at advanced business horizons
Jul 19, 2022
The solution auto-scales and it provides concurrency.
Swathi-Desai - PeerSpot reviewer
Data Engineer at Imriel
Sep 30, 2022
It helps with business intelligence by providing analytics that can be reported.
reviewer2155545 - PeerSpot reviewer
Data Analyst at a tech services company with 11-50 employees
Apr 14, 2023
The computational power of Snowflake is very good.
Amit Shah - PeerSpot reviewer
Principal Consultant at ATOS
May 11, 2023
I am impressed with the product's data-sharing feature.
 

Snowflake Analytics Cons review quotes

Jyothirmai Gopereddy - PeerSpot reviewer
Azure Manager at Tredence Inc.
May 29, 2022
End-to-end execution of jobs isn't possible with Snowflake, which means we have to do some customization.
AK
Database administrator terdata at a tech vendor with 10,001+ employees
May 29, 2022
Moving data from legacy systems to Snowflake is not that easy. There are some cases where processors are not actually compatible with Snowflake.
AnujJain - PeerSpot reviewer
AVP Data Engineering at Genpact - Headstrong
May 31, 2022
We haven't seen any areas that are lacking.
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,477 professionals have used our research since 2012.
MandarGarge - PeerSpot reviewer
V.P. Digital Transformation at e-Zest Solutions
Jun 29, 2022
If you have a lot of computations, it becomes very costly.
reviewer1554165 - PeerSpot reviewer
Data engineer manager at a tech vendor with 10,001+ employees
Jun 20, 2022
A room for improvement in Snowflake Analytics is Spark, particularly its connector for Spark. An additional feature I'd like to see in the next release of the solution is built-in analytics.
Jayanta Datta - PeerSpot reviewer
Executive Director at Morgan Stanley
Jul 3, 2022
Snowflake Analytics can improve the integration with machine learning tools and AI and it will make the solution more usable.
Al Krause - PeerSpot reviewer
Managing Director at advanced business horizons
Jul 19, 2022
Integration into different Python and Jupyter notebooks needs to be improved.
Swathi-Desai - PeerSpot reviewer
Data Engineer at Imriel
Sep 30, 2022
There are issues while loading data from Snowflake Analytics to the Power BI reporting.
reviewer2155545 - PeerSpot reviewer
Data Analyst at a tech services company with 11-50 employees
Apr 14, 2023
Snowflake should include a WHERE clause for building data pipelines.
Amit Shah - PeerSpot reviewer
Principal Consultant at ATOS
May 11, 2023
The tool should support EIM use cases. I guess the product is already working on it. I look forward to seeing inbuilt AI generative tools in the solution's future releases. The tool's price can be a little lower. The solution's on-premises support is also very limited. We have to rely on other support services to deploy it on-premises.