We just raised a $30M Series A: Read our story
2018-07-27T14:45:00Z

What do you like most about Snowflake?

80

Hi Everyone,

What do you like most about Snowflake?

Thanks for sharing your thoughts with the community!

ITCS user
Guest
4040 Answers

author avatar
Top 5LeaderboardReal User

Many features:


1) Separate warehouse and the control user gets on it.


2) Auto caching features


3) Json and XML handling


4) Minimal DBA activity

2021-05-03T14:11:26Z
author avatar
Top 10Real User

Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility.

It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake.

Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake.

2021-02-23T05:18:17Z
author avatar
Top 5Real User

All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse.

2021-09-28T09:30:44Z
author avatar
Top 20MSP

Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake.

2021-08-11T15:04:39Z
author avatar
Real User

The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed.

2021-06-29T06:07:18Z
author avatar
Real User

The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently.

2021-06-03T12:06:30Z
author avatar
Top 20Real User

Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost.

2021-04-15T07:17:20Z
author avatar
Top 5LeaderboardReal User

The way it is built and designed is valuable. The way the shared model is built and the way it exploits the power of the cloud is very good. Certain features related to administration and management, akin to Oracle Flashback and all that, are very important for modern-day administration and management.

It is also good in terms of managing and improving performance, indexing, and partitioning. It is sort of completely automated. Everything is essentially under the hood, and the engine takes care of it all. As a data warehouse on the cloud, Snowflake stands strong on its ground even though each of the cloud providers has its own data warehouse, such as Redshift for AWS or Synapse for Azure.

2021-04-09T16:28:22Z
author avatar
Top 5LeaderboardReal User

Working with Parquet files is support out of the box and it makes large dataset processing much easier.

2021-04-06T15:04:00Z
author avatar
Top 5LeaderboardReal User

I have found the solution's most valuable features to be storage, flexibility, ease of use, and security.

2021-04-01T16:05:50Z
author avatar
Real User

For us, the virtual warehousing is likely the most valuable aspect.

2021-03-02T18:05:02Z
author avatar
Top 20Real User

The pricing is reasonable and matches the rest of the market.

2021-02-25T21:50:48Z
author avatar
Top 20Real User

The technical support on offer is excellent.

2021-02-23T05:38:53Z
author avatar
Top 20Real User

It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud.

It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it.

2021-02-15T18:58:49Z
author avatar
Top 5LeaderboardReal User

Its performance is a big advantage. When you run a query, its performance is very good.

The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution.

It has good security, and we can easily integrate it. We can connect it with multiple source systems.

2021-02-01T10:35:32Z
author avatar
Top 20Real User

Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit.

2021-01-28T11:53:32Z
author avatar
Top 20Real User

The overall ecosystem was easy to manage. Given that we weren't a very highly technical group, it was preferable to other things we looked at because it could do all of the cloud tunings. It can tune your data warehouse to an appropriate size for controlled billing, resume and sleep functions, and all such things. It was much more simple than doing native Azure or AWS development.

It was stable, and their support was also perfect. It was also very easy to deploy. It was one of those rare times where they did exactly what they said they could do.

2021-01-24T15:56:01Z
author avatar
Top 20Real User

The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also.

2021-01-24T08:53:00Z
author avatar
Top 5Real User

Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services.

2020-12-24T16:27:45Z
author avatar
Top 20Real User

The technical support is pretty good, particularly if you are a more technical user.

2020-12-07T18:54:40Z
author avatar
Top 5Real User

The syntax is advanced which reduces the time to write code.

2020-11-10T06:36:00Z
author avatar
Top 20Real User

The cloning functionality has been the most valuable. I have been able to completely copy databases. The data sharing concept is also useful. As compared to, for example, SAP, Snowflake is a lot more open, and it allows a lot more connectivity for other providers than an SAP ecosystem.

2020-11-09T14:15:42Z
author avatar
Top 20Real User

The Mbps they have established is quite a bit faster than any other data warehouse.

2020-10-29T13:02:21Z
author avatar
Real User

The initial setup is very simple.

2020-10-07T07:04:36Z
author avatar
Top 5LeaderboardReal User

It's ultra-fast at handling queries, which is what we find very convenient.

2020-10-06T06:57:48Z
author avatar
Top 20MSP

Can be leveraged with respect to better performance, auto tuning and competition.

2020-10-04T06:40:21Z
author avatar
Top 20Real User

The querying speed is fast.

2020-08-06T06:44:48Z
author avatar
Top 5Real User

The solution is very stable.

2020-07-26T08:19:11Z
author avatar
Top 20Consultant

From a data warehouse perspective, it's an excellent all-round solution. It's very complete.

2020-06-15T07:33:54Z
author avatar
Top 5Real User

The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes.

2020-04-19T07:03:00Z
author avatar
Real User

I like the idea that you can assign roles and responsibilities, limiting access to data.

2020-01-15T08:03:00Z
author avatar
Top 20Real User

It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL.

2020-01-09T06:15:00Z
author avatar
Top 20Real User

The snapshot feature is good, the rollback feature is good and the interface is user-friendly.

2019-12-30T06:00:00Z
author avatar
Top 5Real User

The thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services.

2019-12-12T07:48:00Z
author avatar
Real User

The initial setup is straightforward. You just need to follow the documentation.

2019-12-05T11:14:00Z
author avatar
Real User

They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises.

2019-10-21T17:16:00Z
author avatar
Top 20Consultant

The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications.

2019-10-06T16:38:00Z
author avatar
Real User

As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes.

2019-07-29T10:11:00Z
author avatar
Top 5Real User

The distributed architecture of Snowflake has the capacity to process huge datasets faster and allows us to scale up and down according to our needs.

2018-07-27T14:45:00Z
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
542,823 professionals have used our research since 2012.