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 »
Mediha Šiljić says in an Amazon Redshift review
Chief Information Officer at Sensilab
The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it. View full review »
Valai Gunapalan says in a Snowflake review
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 »
EMEA IT Program Manager for Sales, Marketing & eCommerce at a transportation company with 10,001+ employees
The most valuable features of this solution are its easy setup and ease of use. The SQL functions are ok. I've been working with Microsoft SQL Server, MySQL, and PostgreSQL for a long time, and everything is good. Technical support is very good. View full review »
Ben Santos says in a Vertica review
Sr. Business Intelligence Analyst / Developer with 10,001+ employees
This most valuable feature is the database designer, which helps significantly improve our storage footprint. View full review »
President with 11-50 employees
I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW. View full review »
Luis Henriquez says in a Vertica review
Hewlett Packard Enterprise Solution Architect at a tech services company with 11-50 employees
It maximize cloud economics for mission-critical big data analytical initiatives. View full review »
Titus Marcel says in a Snowflake review
User at a healthcare company with 1,001-5,000 employees
* 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 »
Nir Wasserman says in an Amazon Redshift review
BI Manager at a tech vendor with 201-500 employees
* Windows functions, such as LEAD and LAG. * Allows you write complex queries and perform row by row processes. View full review »
Dan Wities says in a Vertica review
Bi Group Manager at a tech company with 201-500 employees
* Its projections and encoding are excellent tools for tuning large volumes. * The product is simple and elegant. * It has excellent written documentation. I am able to answer any question by querying on Google. View full review »
Andrew Smale says in an Amazon Redshift review
Principal Consultant
* Fast load times * Flexibility in column definitions * The ability to reload data multiple times at different times. View full review »
CSD174561 says in a SAP Business Warehouse review
Chief of Systems Development at a non-tech company with 10,001+ employees
We are currently in a basic stage of analytics and the first goal we have is to make sure the numbers are correct. BW has some features that help you to build factors and ETL in such a way that it's easy to get to correct responses. That's the number one condition that you have to have in an analytic solution. View full review »
Alberto Guisande says in a Vertica review
Director at Decision Science
Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data. View full review »
Srikanth Potluri says in a Vertica review
Architect at a tech services company with 51-200 employees
* The tool for performance tuning and recommendations * Any novice user can tune vertical queries with minimal training (or no training at all). View full review »
Jan-Soubusta says in a Vertica review
Sr. SW Engineer - Databases with 201-500 employees
* Clustered database * Horizontal scaling * Disaster recovery * Columnar Storage * Compression (you read only columns you need) * Immutable storage * Fast ingesting View full review »
solution306072 says in an IBM dashDB review
Business Unit technical Lead at a tech services company with 1,001-5,000 employees
Ease of migration from Netezza DB. IBM ported over all Netezza's functionality and made the warehouse DB/dashDB the best of breed of the two. View full review »
it_user114084 says in a Vertica review
Co-Founder at a tech services company
The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors. I think what also draws me to it is that I don't need any special hardware. So I can use commodity hardware, which is nice to have in a commercial solution. View full review »
Alfonso Licir says in a Vertica review
Technical Leader / Business Intelligence Consultant with 11-50 employees
Vertica is a columnar database, this support our developments in analytics, advanced analytics, and our ETL process with large sets of data. View full review »
Han Nguyen says in a Vertica review
Infrastructre Manager - Senior Maintenance Manager with 10,001+ employees
Partition and join back to node are easy and simple for DBAs. DBAs don’t need to add a partition every month/quarter like with other DBs. View full review »
Fahd Mirza Chughtai says in a Vertica review
Cloud Architect, Oracle ACE, Oracle DBA at Pythian
HPE Vertica is a unique solution as it handles a huge magnitude of data with matchless speed and simplicity. One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility. View full review »
it_user431877 says in a Vertica review
Consultant at a tech services company with 10,001+ employees
* I found the columnar storage, which increases performance of sequential record access, to be the most valuable feature. * I also like the projection feature, which increases query performance. View full review »
Sign Up with Email