2018-07-27T14:45:00Z

What do you like most about Snowflake?

Julia Miller - PeerSpot reviewer
  • 2
  • 54
PeerSpot user
Get the report
Helped 765,234 peers since 2012
64

64 Answers

Sushrit Moundekar - PeerSpot reviewer
Real User
Top 5Leaderboard
2024-01-19T08:02:27Z
Jan 19, 2024

The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.

Search for a product comparison
Iqbal Hossain Raju - PeerSpot reviewer
Real User
Top 5
2023-09-20T16:36:59Z
Sep 20, 2023

The product's most important feature is unloading data to S3.

DominicMackenzie - PeerSpot reviewer
Real User
Top 5Leaderboard
2023-08-25T06:41:00Z
Aug 25, 2023

It is very fast and the performance is great.

TT
Real User
Top 5Leaderboard
2023-05-09T07:52:00Z
May 9, 2023

The solution's customer service is good.

Rahul-Sahay - PeerSpot reviewer
Real User
Top 5Leaderboard
2023-04-19T08:33:00Z
Apr 19, 2023

Data Science capabilities are the most valuable feature.

Ankit  Shukla - PeerSpot reviewer
Real User
Top 5
2023-03-17T11:42:28Z
Mar 17, 2023

This solution has helped our organization by being easy to maintain and having good technical support.

Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
KR
Real User
Top 20
2023-03-14T09:35:41Z
Mar 14, 2023

The features I found most valuable with this solution are sharing options and built-in time zone conversion.

MF
Consultant
Top 20
2023-03-01T14:18:18Z
Mar 1, 2023

Snowflake has three great features: Snowpiping is proving to be very valuable, Time Travel is excellent, and Snowpipes are another great functionality the solution has made available.

AB
Real User
Top 10
2023-02-09T15:51:31Z
Feb 9, 2023

Snowflake is faster than on-premise systems and allows for variable compute power based on need.

Sreenivasan Ramanujam - PeerSpot reviewer
Real User
Top 10
2023-02-03T21:20:00Z
Feb 3, 2023

Scaling is a big plus point of Snowflake.

DA
Real User
Top 20
2023-02-03T18:34:13Z
Feb 3, 2023

It's user-friendly. It's SQL-driven. The fact that business can also go to this application and query because they know SQL is the biggest factor.

Adnan Shafiq - PeerSpot reviewer
Real User
Top 5
2023-01-13T12:06:53Z
Jan 13, 2023

The most valuable feature of Snowflake is it's an all-in-one data warehousing solution.

Luis Miguel Goez - PeerSpot reviewer
Real User
Top 10
2022-10-25T17:55:23Z
Oct 25, 2022

A user-friendly and reliable solution.

it_user1251369 - PeerSpot reviewer
Real User
2022-08-12T17:10:40Z
Aug 12, 2022

The most valuable feature is the clone copy.

Azhagarasan Annadorai - PeerSpot reviewer
Real User
Top 5Leaderboard
2022-05-26T18:57:43Z
May 26, 2022

Its ability to optimize the cost with features such as Pause/Auto-resume Compute engines (aka warehouses), a zero-copy clone of tables, zero cost to xfer AWS s3 files to tables within the same region, monitor cost using snowsight dashboards, etc.

Hussain Modu - PeerSpot reviewer
Real User
Top 20
2022-05-26T13:46:16Z
May 26, 2022

This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere.

MedhaValvekar - PeerSpot reviewer
Real User
Top 5
2022-05-12T13:24:21Z
May 12, 2022

Time travel is one feature that really helps us out.

OA
Real User
2022-03-18T12:43:18Z
Mar 18, 2022

It is a cloud solution with many useful features. It has the data science capability. It can transform data and prepare data for a data science project with scalability.

RN
Consultant
2022-03-16T18:39:35Z
Mar 16, 2022

Snowflake's most valuable features are data enrichment and flattening.

NK
Real User
Top 20
2021-05-03T14:11:26Z
May 3, 2021

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

SR
Real User
2021-02-23T05:18:17Z
Feb 23, 2021

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.

Biraja Mishra - PeerSpot reviewer
MSP
2022-02-22T09:32:00Z
Feb 22, 2022

The speed of data loading and being able to quickly create the environment are most valuable.

HarishAjjarapu - PeerSpot reviewer
Real User
2022-01-26T11:31:00Z
Jan 26, 2022

The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful.

CD
Real User
2022-01-05T08:21:44Z
Jan 5, 2022

It was relatively easy to use, and it was easy for people to convert to it.

CR
Real User
2021-12-09T21:07:45Z
Dec 9, 2021

Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert.

TB
Real User
2021-11-07T09:18:00Z
Nov 7, 2021

It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well.

JH
Real User
2021-09-28T09:30:44Z
Sep 28, 2021

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.

RV
MSP
2021-08-11T15:04:39Z
Aug 11, 2021

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

AK
Real User
2021-06-29T06:07:18Z
Jun 29, 2021

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

EK
Real User
2021-06-24T13:47:09Z
Jun 24, 2021

The solution is very easy to use.

JC
Real User
2021-06-03T12:06:30Z
Jun 3, 2021

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.

SM
Real User
2021-04-15T07:17:20Z
Apr 15, 2021

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.

Anirban Bhattacharya - PeerSpot reviewer
Real User
Top 5
2021-04-09T16:28:22Z
Apr 9, 2021

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.

NK
Real User
Top 20
2021-04-06T15:04:00Z
Apr 6, 2021

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

AS
Real User
2021-04-01T16:05:50Z
Apr 1, 2021

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

PC
Real User
2021-03-02T18:05:02Z
Mar 2, 2021

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

SS
Real User
2021-02-25T21:50:48Z
Feb 25, 2021

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

CP
Real User
2021-02-23T05:38:53Z
Feb 23, 2021

The technical support on offer is excellent.

YM
Real User
2021-02-15T18:58:49Z
Feb 15, 2021

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.

KG
Real User
2021-02-01T10:35:32Z
Feb 1, 2021

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.

FG
Real User
2021-01-28T11:53:32Z
Jan 28, 2021

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

ES
Real User
2021-01-24T15:56:01Z
Jan 24, 2021

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.

MR
Real User
2021-01-24T08:53:00Z
Jan 24, 2021

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.

SM
Real User
2020-12-24T16:27:45Z
Dec 24, 2020

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.

AB
Real User
2020-12-07T18:54:40Z
Dec 7, 2020

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

MA
Real User
2020-11-10T06:36:00Z
Nov 10, 2020

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

TB
Real User
2020-11-09T14:15:42Z
Nov 9, 2020

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.

YM
Real User
2020-10-29T13:02:21Z
Oct 29, 2020

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

DE
Real User
2020-10-07T07:04:36Z
Oct 7, 2020

The initial setup is very simple.

NP
Real User
Top 20
2020-10-06T06:57:48Z
Oct 6, 2020

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

VK
MSP
2020-10-04T06:40:21Z
Oct 4, 2020

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

ST
Real User
2020-08-06T06:44:48Z
Aug 6, 2020

The querying speed is fast.

SS
Real User
2020-07-26T08:19:11Z
Jul 26, 2020

The solution is very stable.

WM
Consultant
2020-06-15T07:33:54Z
Jun 15, 2020

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

YK
Real User
2020-04-19T07:03:00Z
Apr 19, 2020

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

YR
Real User
2020-01-15T08:03:00Z
Jan 15, 2020

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

DR
Real User
2020-01-09T06:15:00Z
Jan 9, 2020

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

it_user1251369 - PeerSpot reviewer
Real User
2019-12-30T06:00:00Z
Dec 30, 2019

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

JH
Real User
2019-12-12T07:48:00Z
Dec 12, 2019

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.

it_user865563 - PeerSpot reviewer
Real User
2019-12-05T11:14:00Z
Dec 5, 2019

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

DK
Real User
2019-10-21T17:16:00Z
Oct 21, 2019

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.

it_user1174809 - PeerSpot reviewer
Consultant
2019-10-06T16:38:00Z
Oct 6, 2019

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.

VG
Real User
2019-07-29T10:11:00Z
Jul 29, 2019

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.

Padmanesh NC - PeerSpot reviewer
Reseller
Top 5Leaderboard
2018-07-27T14:45:00Z
Jul 27, 2018

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.

Snowflake is a cloud-based data warehousing solution for storing and processing data, generating reports and dashboards, and as a BI reporting source. It is used for optimizing costs and using financial data, as well as for migrating data from on-premises to the cloud. The solution is often used as a centralized data warehouse, combining data from multiple sources. Snowflake has helped organizations improve query performance, store and process JSON and XML, consolidate multiple databases...
Download Snowflake ReportRead more

Related articles