IT Central Station is now PeerSpot: Here's why

Snowflake Valuable Features

SreenivasanRamanujam - PeerSpot reviewer
Director -Data Architecture and Engineering at Decision Minds

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.

View full review »
MedhaValvekar - PeerSpot reviewer
Sr Manager at Cognizant

Time travel is one feature that really helps us out. If there is some data discrepancy or something wrong that happens with the table, at any point, we can get that data back and time travel via fail-safe features. They're really good. 

The feasibility to increase horizontal or vertical scaling is great. It really helps a developer at an enterprise level. If you're considering scaling, it won't take much time. 

We can create cloning via Snowflake. There's a lot of time savings.

The initial setup is simple. 

View full review »
TB
director of business operations at a logistics company with 51-200 employees

The query speed, and the way that it actually executes its queries is the most valuable aspect of the solution. We had some queries that would take hours upon hours to run, and the Snowflake returns the results in about 15 minutes.

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.

View full review »
Buyer's Guide
Snowflake
June 2022
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
610,190 professionals have used our research since 2012.
VP
Solution Architect at a wholesaler/distributor with 10,001+ employees

The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. 

Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities.

There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business.

View full review »
Anirban Bhattacharya - PeerSpot reviewer
Practice Head, Data & Analytics at a computer software company with 10,001+ employees

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.

View full review »
Mauricio Ruiz Falcón - PeerSpot reviewer
Senior Information Management Architect at Raken

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.

View full review »
CD
Data Architect at a tech services company with 201-500 employees

It was relatively easy to use, and it was easy for people to convert to it. Moved 168 tables and appropriate indices to Snowflake with minimum modification to Current Oracle DDL. The largest degree of change was setting up the corresponding access Hierarchy to duplicate what was in Oracle ( customer had separate permission structures for application vs Admin/support vs direct reporting access to the data).

View full review »
ES
AVP Enterprise Architecture at a financial services firm with 501-1,000 employees

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.

View full review »
VG
Senior Vice President at a tech services company with 201-500 employees

The solution offers everything you'd find on Azure or AWS. It has a lot of industry-standard features and capabilities.

The product has excellent autoscaling. We can actually compute and scale-out at the same time without having to depend on other tools. You can do it on the fly, or within queries, etc.

The Visual Copy Cloning is definitely one feature that everyone looks forward to due to the fact that it gives you regular backups. 

The solution offers a very good time travel function that allows you to travel back in time to before your systems we corrupted. You can go back into your history and grab the last backup before corruption so that you regain almost everything you need. It gives you 90 days to fetch the data back if you need to. It's better than Azure options.

View full review »
AN
Senior Data Engineer at a financial services firm with 10,001+ employees

The most valuable feature of Snowflake is the query performance. Snowflake is the most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer. There are a couple of areas where they have recently improved. One of the key features they introduced is an internal, table-based merch as well as storing of the unstructured data. You can now build a table out of unstructured data, metadata. This hasn't yet been officially announced.

View full review »
CR
Director Consultoria at tecnoscala consulting

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

View full review »
SM
CEO at a computer software company with 51-200 employees

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. Then we just share it out, and all the compute expenses are charged directly to our clients.

View full review »
AK
Senior Snowflake Data Architect @ COOP Financials NC at a tech services company with 1,001-5,000 employees

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

The solution is very easy to run the queries. We have a built-in query optimizer in Snowflake that works very well.

View full review »
Yash Mittal - PeerSpot reviewer
Lead Data Engineer at a consultancy with 51-200 employees

The most valuable feature of Snowflake is the Mbps they have established because it's quite a bit faster than any other data warehouse. The solution has different warehouse sizes in place, and we're able to switch through and choose what we want. It can be done in one or two seconds. In other data warehouses, it may take around one minute to set up a different configuration. In Snowflake, it can be done in, two or three seconds. And apart from that, the most important thing given that I have to analyze all this, is that it's very good with the time travel, it's a great feature. 

View full review »
SS
Enterprise BDM and Solutions Speacialist at a tech services company with 10,001+ employees

The solution is very easy to understand. It's a simple solution. It's not complicated.

The product does a lot of wonderful stuff that a lot of these companies want to do without too much effort.

The initial setup is straightforward.

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

The solution is quite stable.

Our clients have not had any trouble scaling.

View full review »
CP
Founder & CIO at a computer software company with 11-50 employees

The solution is very fast. It's not clunky or slow.

The product, overall, is quite inexpensive. It's very cheap to use.

The solution is extremely user-friendly and easy to navigate. The user experience is very good.

The initial setup is pretty straightforward. It's simple.

We found that the initial setup was pretty easy.

The solution has been stable and has provided good overall performance.

A company can easily scale the solution. It's not too difficult to pull off.

The technical support on offer is excellent. They're helpful for the most part.

View full review »
Veerendra Karnam - PeerSpot reviewer
General Manager at itcinfotech

Snowflake has its own features in comparison to other similar solutions like Exadata. This gives it huge competitive power. It has a very good interface tool with its own benefits and features which are really useful for our needs from a computation and storage perspective. I think this solution provides the best potential of any data warehousing product where they choose to use Snowflake instead of Oracle or DBII. The product can be leveraged with respect to better performance, auto tuning, competition and performance. From an architectural perspective, the solution has all the ingredients it requires. 

View full review »
Yaniv Meir - PeerSpot reviewer
BI & BIG DATA Director at Malam-Team

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.

View full review »
FG
Lead Data Analyst at a wholesaler/distributor with 1,001-5,000 employees

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

View full review »
SS
Senior Software Engineer at a financial services firm with 1,001-5,000 employees

The solution's most valuable aspect is the ability to process the bulk amount of data and try to clone the database. We try to clone the production database. Instead of syncing the whole database, we can just clone it up and start working on it. Basically, the cloning and the database are very user-friendly.

The solution is very stable.

View full review »
RN
Consultant at a financial services firm with 1,001-5,000 employees

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

View full review »
NP
DBA at a venture capital & private equity firm with 11-50 employees

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

The pricing and licensing model is good.

View full review »
Sanjay Bheemasenarao - PeerSpot reviewer
Director - Data Engineering expert at Sankir Technologies

It is a very easy-to-use solution. It is user-friendly, and its setup time is very less.

View full review »
BH
Manager IT BRM/FRM at a manufacturing company with 10,001+ employees

The adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard.

View full review »
RAHULVERMASIR - PeerSpot reviewer
Technical Architect at a computer software company with 501-1,000 employees

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

View full review »
AH
CEO, Senior Consultant at a tech services company with 1-10 employees

The scalability of this product is great and the fact that it has a so-called zero clone copy and is near zero maintenance is also great. There are a lot of good features, it's a very sophisticated, cutting edge technology and is super easy to use. They are developing the platform very, very quickly so there are plenty of new features implemented all the time. You can concentrate on implementing things in Snowflake without tuning or configuring it.

View full review »
PC
Sr. Solution Architect at a insurance company with 1,001-5,000 employees

The product offers a lot of great features.

Architectural-wise, it's got great architecture. That's what we are looking for. It's kind of decoupled from storage and has virtual warehouses. We like that we can travel and keep things virtual. For us, the virtual warehousing is likely the most valuable aspect. You can spin up as many virtual warehouses that you want. That's quite useful as a feature.

View full review »
NitinKumar - PeerSpot reviewer
Director of Enginnering at Sigmoid

The most valuable features are:

  1. The Virtual Warehouse and separate storage is definitely one of the best features. It automatically scales the warehouse up and down as per the usage.
  2. Processing semi-structured data like JSON and XML has helped reduce a lot of coding that was needed earlier.
  3. The speed of execution is definitely good.
  4. There is zero maintenance activity required from users on the database, which is a big plus.
  5. Working with Parquet files is supported out of the box and it makes large dataset processing much easier.
  6. Automatic scaling up and down.
View full review »
MM
Manager at SSM VIT Global Solutions

I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well.

View full review »
AB
Technology & Innovation at a consultancy with 201-500 employees

The overall package is quite nice, and there is not one specific feature that I have found more valuable than the others.

The vendor is quite willing to implement requests for development, in particular for larger clients. It is a nice company to work with.

View full review »
Biraja Mishra - PeerSpot reviewer
Senior Principal Consultant at Genpact - Headstrong

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

For data, it provides built-in security and compliance with different standards, such as SOC 2, ISO, etc. So, we don't have to do a separate audit for compliance.

View full review »
Ravi Kuppusamy - PeerSpot reviewer
CEO and Founder at BAssure Solutions

Snowflake has a variety of other ETL provisions that they provide. You can use your own ETL pipeline. Additionally, they provide adapters, and they are always evolving, it is a well-developed solution.

View full review »
Tom Bruce - PeerSpot reviewer
Co-founder & Delivery Lead at a tech services company with 1-10 employees

The use of micropartitions and metadata means that there is very little management needed and the user can focus purely on actually getting value out of their data. In addition, the cloning feature makes problem resolution and cutover extremely pain-free.

View full review »
KG
Associate Manager at a consultancy with 501-1,000 employees

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.

View full review »
EK
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees

The solution is very easy to use.

The product is very stable and flexible. The performance is good.

The product is quite scalable.

View full review »
Hussain Modu - PeerSpot reviewer
Technical Lead at Wipro Limited

I like the entire database. 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.

View full review »
MS
ML Lead at a tech services company with 201-500 employees

It is a very well-distributed system. It has different data engines for different applications. Many applications can use different computational engines at the same time. In terms of data processing, the feeling was similar to working with a relational database but in a scalable way.

View full review »
JC
General Manager of Data Science at a non-profit with 501-1,000 employees

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.

View full review »
ST
Solutions Architect-AI & ML at a tech services company with 10,001+ employees

As it is SQL-like, it is easy to write queries.

The querying speed is fast.

View full review »
Anoop Anoop SLK - PeerSpot reviewer
Enterprise architect at a computer software company with 201-500 employees

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

View full review »
Subhrajit Mitra - PeerSpot reviewer
Sr. Technical Architect - Business Intelligence / Data Warehouse at a computer software company with 1,001-5,000 employees

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.

View full review »
JH
Vice President of Business Intelligence and Data Engineering at a comms service provider with 201-500 employees

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. 

It has very nice features, such as snapshots, marketplace, and it is very easy to receive data-warehouse specifications.

View full review »
MH
Data & Analytics Practitioner (BIDW, Big Data) at a computer software company with 10,001+ employees

I like the fact that we don't need a DBA. It automatically scales stuff.

Snowflake has better performance features; it automatically knows the difference between the data volume. It adjusts itself.

The performance is great. It internally optimizes well.

The product is stable.

The solution is scalable.

View full review »
OA
Big Data & Cloud Manager at a tech services company with 1,001-5,000 employees

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.

View full review »
VY
Chief Data Architect - Europe at a computer software company with 10,001+ employees

We find the data sharing and data marketplace aspects of Snowflake absolutely amazing.

View full review »
Vinoth Raj Prabhakaran - PeerSpot reviewer
Senior Data Architect at Tata Consultancy Services

The most valuable features of Snowflake are its performance and power.

View full review »
HarishAjjarapu - PeerSpot reviewer
Associate Director at a tech services company with 10,001+ employees

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

View full review »
MA
Senior Solutions Architect at NessPRO Italy

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

View full review »
Buyer's Guide
Snowflake
June 2022
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
610,190 professionals have used our research since 2012.