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 »
reviewer1389294
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 »
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 »
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: December 2020.
454,950 professionals have used our research since 2012.
Yash Mittal
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 »
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 »
reviewer1364460
Principal Consultant at a tech services company with 51-200 employees
The architecture we'll be using due to being on the cloud will assure we have less to do. There will be no indexing, for example. Everything's managed by the servers. That way, we can focus on the data warehouse and on the data. From a data warehouse perspective, it's an excellent all-round solution. It's very complete. View full review »
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 »
Veerendra Karnam
General Manager -DATA at a tech services company with 5,001-10,000 employees
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 »
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 »
Suresh Swaminathan
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 »
reviewer1424916
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 »
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 »
reviewer1467771
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 »
Tom Bruce
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 »
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 »
reviewer1400643
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 »
Subhrajit Mitra
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 »
Murugan Asokan
Senior Solutions Architect at NessPRO Italy
The syntax is advanced which reduces the time to write code. View full review »
Yuval Klein
Pre-sale Leader, Big Data Enterprise Solutions at Ness Technologies
The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes. View full review »
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: December 2020.
454,950 professionals have used our research since 2012.