Snowflake Valuable Features

reviewer739716
Business Intelligence and Data Engineering at a tech services company with 201-500 employees
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 has something like a time machine, as it is from Apple it incorporates that feature in a way similar to their operating system. So whenever you need a version of the data to test with, you can just go back and take a copy of what was backed up yesterday. It makes some things very easy. It backs up your data warehouses, so for example in our case, a colleague deleted a complete database and we just need to do an undrop on the database and the data was there again. This helps you to have a development environment with current data. You can just clone your production environment and you have a development environment. Everything you do you can test it on real production data without destroying the production data itself. These are significant advantages. View full review »
Valai Gunapalan
Architect at Sony Corporation of America
The data warehouse is one of the great concepts of Snowflake. The coding plans are also a great feature. You can switch out the values or sizes. View full review »
DivyaRaj
Sr. Software Developer at Tech Mahindra Limited
Snowflake is the latest technology. It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL. This solution automatically performs micro-partitioning when the data is loaded. This creates a dynamic partition and based on the cluster, the performance is fast and really impressive. Snowflake is using MPP, massively parallel processing techniques, which is a great feature. It saves developers time and allows us to focus more on client requirements. View full review »
Find out what your peers are saying about Snowflake Computing, Apache, Teradata and others in Data Warehouse. Updated: March 2020.
406,070 professionals have used our research since 2012.
Cesar AugustoSiado Leyva
Business Intelligence Consultant at a tech services company with 201-500 employees
The most valuable features are: The multi-clustering: being able to access stored data without contention. Virtual Warehouse (VW) sizing: Change the size of your VW on demand. Zero copy clone: Easy to create development and test environments. View full review »
reviewer1175826
Data & Analytics Practitioner at a tech services company with 1,001-5,000 employees
The entire managed service operations for the solution is great. Snowflake does everything for us. Whatever version they have, they implement the latest for us; we don't have to worry about any versions, any upgrades, anything else because they handle it. View full review »
Padmanesh NC
Big Data Solution Architect - Spatial Data Specialist at Sciera, Inc.
* Scalability. This solution has the ability to load a huge number of datasets (I have experience with petabytes of data) and process them. Storage is not limited, and we can increase what we want. * Performance. 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. * Flexibility. This feature is helpful for the user to increase the node size and config depending on their need. There is no need to wait for hardware to be in place whenever we increase the dataset. Snowflake provides the option to increase the node or cluster size whenever required. * Multi-formatted accessibility. The Snowflake engine has the capability to read the following file formats: CSV, DELIMITER, FIXEDWIDTH, AVRO, JSON, BZIP2, GZIP, LZOP. The user can choose which format is best for their requirements. * Configuration. Even though its running in the AWS platform, it beats their platform product. I feel more flexible with this solution than I do with Redshift. * Snowpipe. Snowpipe is a better system to feed stream data to the Snowflake database. View full review »
RajeshBalasubramaniyan
Principal Technologist at a healthcare company with 10,001+ employees
In terms of features, we have not yet explored the product completely. So we are still in the proof of concept phase. As of now, the product meets our preliminary requirements. The snapshot feature is good and the rollback feature is good. That is why we have the product and these are the key things we need. View full review »
JatinArora
Data Engineer at Celebal Technologies
The relational piece and how one dimension relates to another just by using a key is the solution's most valuable aspect. We are managing everything by using simple relations. It's all about the relationships between dimensions. View full review »
reviewer1077408
R&D Operations Manager at a manufacturing company with 1,001-5,000 employees
* I like the idea that you can assign roles and responsibilities, limiting access to data. That has been very interesting to us. * The robustness of the system is very useful to us. * The availability of the system. View full review »
Titus Marcel
User at UCLA Medical Center
* Computing unit is accessible via SQL: being able to turn them on or off as needed. * Snowpipe (ingesting data) * Looking back in time (being able to look at data in the past within a query) * No data warehouse management * Support for JSON. The list is pretty long. View full review »
Find out what your peers are saying about Snowflake Computing, Apache, Teradata and others in Data Warehouse. Updated: March 2020.
406,070 professionals have used our research since 2012.