Snowflake Reviews & Product Details

What I like best about Snowflake is its fast performance and ability to handle large amounts of data smoothly. It also works well across different cloud providers, which gives flexibility for companies. The interface is user-friendly compared to many traditional data warehouse systems. Review collected by and hosted on G2.com.

What I dislike about Snowflake is that the pricing can become expensive if queries are not managed carefully. Some advanced features also have a learning curve for new users. It is powerful, but smaller businesses may find it more than they need. Review collected by and hosted on G2.com.

I appreciate Snowflake for serving as our central data repository with a secure data warehouse environment that we don't need to host internally. The SQL querying is extremely efficient, and I find the pipelines to other programs easy to set up and maintain. Additionally, I like that Snowflake is set up to automatically push and pull from other services we use to host and maintain data. Review collected by and hosted on G2.com.

Snowflake is not self-explanatory to users without understanding of SQL. The visual interface could be improved to allow querying without SQL easier. The initial setup is relatively complex. Review collected by and hosted on G2.com.

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.

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.

Snowflake lets me share live data without copying it. I can give my clients a secure view of their contracts, hours worked, and end dates. With historical data in Snowflake, I can also run models to forecast seasonal hiring spikes for clients. Snowflake is fully managed, so there’s no indexing, no tuning, and no 2 a.m. crashes right before payroll. Review collected by and hosted on G2.com.

To really use it, you need some SQL or Tableau skills; once you have them, it’s genuinely helpful for working with messy data. I haven’t experienced any problems while using it so far. I highly recommend it 💯 Review collected by and hosted on G2.com.

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.

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.

the user interface was very easy to understand and use. not only that, snowflake has compatibility with various tools to ingest and export data. Review collected by and hosted on G2.com.

pricing is a bit complex to understand and expensive. it does not support native etl transformations as well Review collected by and hosted on G2.com.

I like Snowflake's virtual warehouses, which we can scale up and scale down as needed. The ability to automatically adjust the maximum and minimum clusters based on the number of concurrent users is very useful for us. We use it to support our dashboards like Tableau and Power BI. Setting up Snowflake was very easy for our team since we already had an established cloud platform like AWS, making it a straightforward process. Review collected by and hosted on G2.com.

Everything works well with snowflake. There is nothing to dislike at this moment. Review collected by and hosted on G2.com.

Ease of use / low maintenance – no infrastructure to manage, which is a big relief compared to traditional data warehouses.

Separation of storage and compute – lets you scale performance independently and avoid resource contention.

Performance & scalability – fast queries, especially with large datasets.

Concurrency handling – multiple teams can query data at the same time without slowing each other down.

Simple data sharing – sharing datasets across teams or even organizations is unusually smooth.

Pay-as-you-go pricing – you only pay for what you use, which feels efficient (when managed well).

Strong ecosystem & integrations – works well with modern data tools (dbt, BI tools, etc.). Review collected by and hosted on G2.com.

Semi-structured data isn’t always as smooth as advertised

JSON handling is powerful but can become awkward in complex transformations

Limited control compared to traditional systems

You don’t control the underlying infrastructure

Harder to fine-tune at a low level

Data governance & complexity at scale

Managing roles, permissions, and data access can get messy

Especially painful in large organizations with many teams Review collected by and hosted on G2.com.

Snowflake's simplicity combined with powerful scalability. It separates compute and storage, making it easy to scale performance up or down on demand without complex infrastructure management, while delivering fast, reliable analytics on large volumes of data. Review collected by and hosted on G2.com.

Cost predictability. Because compute usage is consumption-based and can scale very easily, it’s also easy for queries, poorly optimized workloads, or multiple teams to drive up costs unexpectedly without strong governance and monitoring in place. Review collected by and hosted on G2.com.

It is a clean and easy to understand interface that allows us to access our data easily. We've begun utilizing their feature to create your own AI agent and it's incredibly useful, especially in that we can help train it by defining our data. It is greatly increasing the accessibility of our data across the organization Review collected by and hosted on G2.com.

Occasionally, there are some nuances to the sql structure that need to be worked through, though these are minor Review collected by and hosted on G2.com.