Cloud Data Warehouse Features

Read what people say are the most valuable features of the solutions they use.
BenjaminArnulf says in an Oracle Autonomous Data Warehouse review
Senior Director BI & Analytics at Hertz Global Holdings, Inc.
The three top features for us are: * Self-tuning * Self-securing * Self-patching On top of it, you can create an instance in three minutes and use it with Oracle Analytics. View full review »
Padmanesh NC says in a Snowflake review
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 »
Shyam Shankar says in an Amazon Redshift review
Senior System Engineer at a software R&D company with 10,001+ employees
In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes are valuable. View full review »
DivyaRaj says in a Snowflake review
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 »
reviewer1043649 says in a Teradata Cloud Data Warehouse review
Senior Analyst at a consultancy with 501-1,000 employees
The most valuable feature is the ease of running queries. Automation is very important to us. View full review »
RajeshBalasubramaniyan says in a Snowflake review
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 »
Project Manager at a tech services company with 5,001-10,000 employees
The most valuable feature of the solution is the analytics and that it can connect with Power BI. I found it quite interesting and very compelling in terms of detail within a single stack. View full review »
Analytics Engineer at a tech services company with 51-200 employees
The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis. We have a nightly load where all of the data is updated, and it is a very good feature. The transaction log shipping gives us the ability to replicate the database onto different servers for backup and synchronization. View full review »
BeverlyTshifularo says in a Microsoft Azure SQL Data Warehouse review
Senior Business Analyst: BI Team Lead at a logistics company with 1,001-5,000 employees
The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs. View full review »
Vice President Technologies at Excelencia
The best part is the easy and user-friendly administration and handling of the data. View full review »
reviewer739716 says in a Snowflake review
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 »
Practice Head BI at a tech services company with 1,001-5,000 employees
The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range. When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage. View full review »
JatinArora says in a Snowflake review
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 »
reviewer1240269 says in a SAP Business Warehouse review
Head of BI and Analytics at a comms service provider with 1,001-5,000 employees
The warehouse is the solution's most valuable feature. View full review »
reviewer1209333 says in an Amazon Redshift review
Head of Data Warehouse & Business Intelligence at a comms service provider with 501-1,000 employees
The product is relatively easy to use because there is no indexing and no partitions. There is no referential integrity only declarative, which is okay. View full review »
Technology Evangelist, CTO, Entrepreneur with 1-10 employees
I really like the auto-tuning, auto-scaling, automatic load balancing, and query tuning in the system. View full review »
Managing Partner at a tech services company with 11-50 employees
The most valuable feature is the scalability. It scales out, so you can build a large database and not have to think about whether it performs, or about connecting to the servers to become larger. View full review »
Data Architect at a tech services company with 10,001+ employees
What I like the most would be MPP (Massively Parallel Processing) architecture. Because we had to migrate a lot of data and it helps us a lot to make things faster. View full review »
reviewer1221354 says in an Amazon Redshift review
Senior Software Engineer at a tech services company with 51-200 employees
The best part about this solution is the cost. The performance of this solution is good if you have only a few use cases and a few queries, but for larger applications, it is not so good. View full review »
reviewer1213002 says in a SAP Business Warehouse review
IT Controlling Specialist at a pharma/biotech company with 10,001+ employees
The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs. View full review »
reviewer1175826 says in a Snowflake review
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 »
Executive Board Member / General Manager at a comms service provider with 1,001-5,000 employees
The most valuable feature of this solution is the ease of administration. View full review »
reviewer1207005 says in an Amazon Redshift review
Head of Analytics at a tech services company with 10,001+ employees
The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing. View full review »
Cesar AugustoSiado Leyva says in a Snowflake review
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 »
Consultant at a tech services company with 51-200 employees
The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS. View full review »