Snowflake

By Snowflake, Inc.

4.6 out of 5 stars

How would you rate your experience with Snowflake?

Compare this with other toolsSave it to your board and evaluate your options side by side.
Save to board

Snowflake Reviews & Product Details

Pricing

Pricing provided by Snowflake.

Standard

$2
Compute/Hour

Snowflake Media

Snowflake Demo - Snowflake
The Data Cloud
Snowflake Demo - Snowflake's unique architecture
Makes it possible to create as many independent compute clusters as you need.
Snowflake Demo - Use the standard SQL your team knows
Create databases, query and analyze data.
Snowflake Demo - Data Sharing
Easily share live data with customers or partners.
Play Snowflake Video
Product Avatar Image

Have you used Snowflake before?

Answer a few questions to help the Snowflake community

Snowflake Reviews (695)

View 1 Video Reviews
Reviews

Snowflake Reviews (695)

View 1 Video Reviews
4.6
695 reviews

Review Summary

Generated using AI from real user reviews
Users consistently praise Snowflake for its ease of use and scalability, allowing teams to manage large datasets efficiently without the burden of infrastructure management. The platform's ability to separate compute and storage enhances performance and cost control, making it a preferred choice for data analytics. However, many users note that cost management can be challenging, especially with unpredictable usage patterns.

Pros & Cons

Generated from real user reviews
View All Pros and Cons
Search reviews
Filter Reviews
Clear Results
G2 reviews are authentic and verified.
TB
Security Engineer
Mid-Market (51-1000 emp.)
"Snowflake’s Secure Data Sharing and Time Travel Make Daily Analysis Effortless"
What do you like best about Snowflake?

I use Snowflake every day to review access logs and keep an eye on user behavior. The secure Data Sharing feature is genuinely one of the most valuable parts of the platform, since it allows us to share datasets across teams without copying anything. I’ve worked with other data platforms before and I still remeber how much time we used to lose to ETL jobs and infrastructure management. Role Based Access Contril (RBAC) is solid as well, especially once its configured correctly. I also appreciate Time Travel, because it makes it simple to jump back and check historical data fastest whenever I need to. Review collected by and hosted on G2.com.

What do you dislike about Snowflake?

RBAC is powerful, but it isn’t very straightforward at first. I had to spend some time testing and adjusting different roles to make sure I wasn’t over permissioning anything. Credit usage is another area you really need to keep an eye on as you go, since its easy to lose track if you’re not paying attention. Review collected by and hosted on G2.com.

TR
Software Engineer
Mid-Market (51-1000 emp.)
"Smooth, Scalable Data Platform with Flexible Compute/Storage Separation"
What do you like best about Snowflake?

Snowflake has been part of my daily workflow for quite some time and it scales smoothly without requiring any manual effort on my end. Its integrations with tools like Python, Tableau, APIs and cloud storage services have been reliable, stable and straightforward to maintain over time. I also appreciate the separation of compute and storage, which keeps the such as workload isolation, data sharing and suppot for external stages help me handle different use cases more cleanly and efficiently. Review collected by and hosted on G2.com.

What do you dislike about Snowflake?

I haven’t run into any issues so far, everything is ok works as expected for regular use. New users provide $400 credits in the first months. Review collected by and hosted on G2.com.

Rakshith B.
RB
Associate Data Analyst Consultant
Mid-Market (51-1000 emp.)
"Snowflake Makes Scaling and Fast Queries Effortless"
What do you like best about Snowflake?

Snowflake’s standout feature is the way it separates storage from compute, which makes scaling both straightforward and efficient. Query performance stays fast even when working with large datasets, and the UI is clean, simple, and easy to navigate. It also integrates smoothly with other tools, which helps streamline data workflows and cuts down on the effort needed for infrastructure management. Review collected by and hosted on G2.com.

What do you dislike about Snowflake?

One downside of Snowflake is that costs can rise quickly if usage isn’t monitored closely. The pricing model can also feel a bit complex to understand at first. In addition, there’s a learning curve for new users, especially when it comes to optimizing queries and managing warehouses efficiently. Review collected by and hosted on G2.com.

Sanyam S.
SS
Senior Software Engineer
Enterprise (> 1000 emp.)
"Easy-to-Use Cloud Data Management for Integration, Governance, and Migration"
What do you like best about Snowflake?

It is a cloud-based data management tool. It’s one of the best tools for data integration, governance, and migration, and it’s easy to use with a UI-friendly interface. Anyone can use it easily and they also provide customer support if need any help, they provide trainings also to the users and help them manage their data.. I also find it easy to use, thanks to a user-friendly interface and an overall UI that feels intuitive and straightforward. Review collected by and hosted on G2.com.

What do you dislike about Snowflake?

As of now, the cost for some services is pretty high, but it does provide good-quality service overall, so I think it’s good. Review collected by and hosted on G2.com.

Prashanth Sai A.
PA
Data engineer
Enterprise (> 1000 emp.)
"Cost-Effective, Easy-to-Use Snowflake with Great Performance and Support"
What do you like best about Snowflake?

the cost is less compared to other Datawarehouse's, The UI is so neat and easy to understand,the user experiance is also good, we can integrate snowflake with dbt and other tools, the query performance is also good, And the support team is always reachable, It has new ai features like cortex code , its a game changer Review collected by and hosted on G2.com.

What do you dislike about Snowflake?

I used snowflake polaris iceberg catalog , It can be improved Review collected by and hosted on G2.com.

Chaim and Liora S.
CS
Senior Data Engineer
Mid-Market (51-1000 emp.)
"Excellent for Analytics: Transparent Costs, Easy UI, and Straightforward Integrations"
What do you like best about Snowflake?

Snowflake is excellent for analytical workloads. The cost is relatively transparent, and there are plenty of tools available to help optimize both cost and performance. The UI is easy to use, and integration with 3rd-party vendors is straightforward. You can also easily access data that is external to Snowflake, which helps reduce vendor lock-in risk. Review collected by and hosted on G2.com.

What do you dislike about Snowflake?

By the nature of being a cloud vendor, the UI has limitations in that it is browser based. This is the same story though for all cloud based data processing platforms. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
CI
Mid-Market (51-1000 emp.)
"SQL-Agnostic, Easy to Adopt, and Packed with Capabilities"
What do you like best about Snowflake?

Snowflake is SQL-agnostic, so you don’t need to learn other programming languages to get started. It’s an easy ecosystem to enter and stay in. A lot of open-source tools natively support Snowflake, like dbt, Dagster, and Fivetran. Snowflake also has built-in AI features like Cortex code, which is very good to use. On top of that, there’s a wide variety of capabilities—such as API integrations, external stages, different user profiles, and security policies—and all of these can be

implemented using just SQL.

the user experience has been good with the introduction of workspaces , i am loving this new workspaces layout where i can structure and store my files in an organized way Review collected by and hosted on G2.com.

What do you dislike about Snowflake?

I really liked snowflake as a data warehouse but there are too many features are open source tools all bundled inside snowflake , and snowflake has introduced a lot of AI features like cortex analyst which are good for UI friendly POC's but I prefer code-agnostic tools Review collected by and hosted on G2.com.

Sachin K.
SK
Software engineer
Small-Business (50 or fewer emp.)
"Scalable, Seamless, and Cost-Effective Data Warehousing"
What do you like best about Snowflake?

I really enjoy Snowflake's scalability and performance, which have streamlined our data analytics process. The way it handles large volumes of data without compromising speed is impressive. I appreciate the seamless integration with our existing tools, making life so much easier. I also really enjoy Snowflake's automatic scaling, like having a super smart assistant that adjusts resources based on demand. The data sharing feature is a game-changer for collaboration with partners and internal teams; it works seamlessly. Snowflake's solid integrations with tools like Tableau and Power BI make visualization and gaining insights a breeze. The initial setup was pretty straightforward thanks to their solid documentation and helpful team, allowing us to start loading and querying data within a day. Review collected by and hosted on G2.com.

What do you dislike about Snowflake?

Honestly, one thing that can be a bit of a pain is Snowflake's cost management - it can get tricky to optimize costs, especially with complex queries or large data volumes. And sometimes, the learning curve for advanced features can be a bit steep, especially for new users. Review collected by and hosted on G2.com.

Will K.
WK
Senior Software Engineer
Enterprise (> 1000 emp.)
"Robust Data Warehouse with Fast Analytics"
What do you like best about Snowflake?

I use Snowflake as a data warehouse for analytics and debugging queries on production data. I find it pretty fast, even for big, complicated queries, which is very valuable to me. The web UI is solid, making my interaction with the software pleasant. I also appreciate the handy SQL extensions that make coding a little easier. Review collected by and hosted on G2.com.

What do you dislike about Snowflake?

I would love more SQL extensions (like SELECT * EXCLUDE or UNION BY NAME). Also it's frustrating when someone is running a very long-running query and causes my queries to be delayed. Basically, I wish it had all the fancy extensions that DuckDB has. For example, DuckDB lets you use dot notation to call functions (i.e., s.upper() instead of upper(s)), which is nice. Also, it would be very handy if you could somehow make temp tables local to a specific session. I sometimes would like to save something in a temp table, but then I have to move to a schema that I have write access on, which is a bit annoying. Also, it would be very neat if you could give the optimizer hints about whether or not to materialize CTEs. Occasionally it makes the wrong decision and makes queries that should be fast take forever. Review collected by and hosted on G2.com.

Akshat G.
AG
Programmer Analyst
Information Technology and Services
Enterprise (> 1000 emp.)
"Effortless Analytics and Fast Scaling with Snowflake"
What do you like best about Snowflake?

Snowflake is very easy to use and quick to implement compared to traditional data warehouses. I like how compute and storage are separated, which makes scaling simple and cost-efficient for different workloads. Integration with BI tools and cloud services is smooth, and query performance is consistently strong. Because of its simplicity and reliability, it’s used very frequently for analytics and reporting. Review collected by and hosted on G2.com.

What do you dislike about Snowflake?

Cost can become difficult to track, especially with frequent queries and multiple users running workloads at the same time. Some advanced features require a deeper understanding to optimize properly, and debugging performance issues isn’t always straightforward. While support and documentation are good, fine-tuning usage to control costs takes effort. Review collected by and hosted on G2.com.

Questions about Snowflake? Ask real users or explore answers from the community

Get practical answers, real workflows, and honest pros and cons from the G2 community or share your insights.

Samuel S.
SS
Samuel Schwartz
Last activity almost 3 years ago

What's the best way to manage change data capture in Snowflake?

Verified User
G2
Verified User
Last activity almost 4 years ago

How often are the upgrades made to the Snowflake and how does it impact the current users ?

Pricing Options

Pricing provided by Snowflake.

Standard

$2
Compute/Hour

Enterprise

$3
Compute/Hour

Business Critical

$4
Compute/Hour
Snowflake Comparisons
Product Avatar Image
Databricks
Compare Now
Product Avatar Image
Amazon Redshift
Compare Now
Product Avatar Image
Google Cloud BigQuery
Compare Now
Snowflake Features
On-Premise
Cloud
Data Distribution
Data Integration
Data Compression
Data Quality
AI/ ML Integration
BI Tool Integration
Data lake Integration
Product Avatar Image
Snowflake