Snowflake Reviews: 4.5/5 — Highly Rated

Performance and scalability. Pay as you go price model doesn't require large upfront invests makes it a great fit even for smaller companies. Feature completeness and still constant innovation with further great features.

I thought long about it but couldn't find anything in this category.

Create data warehouse to bring all data together in a single place for analysis. Now data from different systems can be easily combined for analysis. Manual processes are automated.

It just works. The advantage of this environment is that there is minimal administrative work required to support rapid developments and users of all types. Disk provisioning , performance concerns are a thing of the past.

This is largely a CLI environment. Many activities require writing code.

A single data source for many applications that scale to meet the demand of dashboard users and data scientists.

Tri-Secret Secure : customer held key ensures that service representatives can not "see" our data. Dynamic Compute Sizing : we can resize our compute resources (known as snowflake warehouses) to react to needs of the Business or to minimize cost. Replication : we can replicate entire databases from one region (or cloud) to another easily and very quickly which is important with financial services data.

Account Management : while we can see our consumption (compute and storage) online, we don't have access to see our current credit balance and forecasted usage. Compute Resource Rationalization : we don't have the insight into whether the sizing of our compute resources are appropriate (too large or too small). Sizing becomes more of an art than a science.

We've solved the issue of capacity management. Our previous solution required an upgrade to increase compute or storage sizing. Storage is only limited by the size of our budget and we now can resize compute ourselves. The net result is we have consumed much more data at the same price point as our previous solution which makes everyone (Business users, Finance team, and us) very happy.

Separation of storage and compute make it so simple to manage capacity and ensure fast response times for all warehouse workloads. We can have analysts on one warehouse, another warehouse servicing our API, and yet another one to serve up customer dashboards, all working on the same data without affecting the response times of each other.

Enterprise account required for clustering, which not only increases the number of credits you will use but also drives up the cost per credit. The community forums are not that active and are a hassle to post to because of needing to have a support account that is different than your regular account. No ability to share data with consumers that have an account in a different region.

Flexible data warehouse to drive dashboards for our internal teams and customers. Secure data sharing is also a killer feature that is a million times easier than the old way of transferring csv files all around.

Separation of storage vs compute and very transparent billing

Performance with visualization tools is not the best

Solving problems for good access to data and quick onboarding of users

It is web-based and is intuitive. There are support forums to use also.

Nothing as it gives me everything I need to be successful with my position.

It is great to use with data and see what areas we are succeeding in.

Its ease of use. The solution feels natural for people that have worked with relational databases before because of its implementation of basic SQL. However, combining structured and semistructured data in a query is extremely simple, and the performance is impressive. You can pull millions of rows in an instant by just setting the correct warehouse size.

There is little to dislike about Snowflake. Its performance and ease of use are incredible. However, Snowflake can still be considered a newcomer to the market, so the breadth of solutions that integrate and communicate with Snowflake is somewhat reduced compared to other products (SQL Server, Oracle, Redshift, etc.)

We needed to improve the performance of our ETL processes. We had ETLs that ran for close to 15 - 20 hours to move data into the data warehouse. After multiple reviews, we identified that there was little we could do with our ETLs. But moving the DWH to Snowflake was the solution to all our problems.

Snowflake is the easiest cloud data mart I’ve used.

Snowflake does not allow you to extend the length of table names - you have to know what you’re looking for

Snowflake is allowing me to bring data to decision makers faster.

The biggest benefit to using snowflake for us has been the ease of use when it comes to data management and tool interaction. When we migrated from Redshift we also saw a huge increase in performance due to the improvement in the way that concurrency impacted our looker instance. I highly recommend! The administration tooling/UI in snowflake is amazing. I don't need to have highly trained database admins handling everything. Its easy to understand and work with functionally makes it much more accessible to less technically skilled individuals.

The biggest issue we are facing now is implementing snowpipe. Some of the problems has been due to the lack of documentation on how errors are handled.

The biggest problem that we have successfully tackled has been increased number of users we can have using Looker, due to the concurrency increase.

The Snowflake data warehouse uses a new SQL database engine with a unique architecture designed for the cloud

I like this tool, nothing that i can think about. So far so good

Snowflake is a top cloud data warehousing solution