Amazon Redshift Reviews & Product Details - Page 27

The most valuable thing is Scheduling around maintenance windows. Review collected by and hosted on G2.com.

There are no specific cases that I don't like in Redshift. Review collected by and hosted on G2.com.

Customer service is really good and helpful Review collected by and hosted on G2.com.

Amazon redshift is having very minimum dislikes Review collected by and hosted on G2.com.

Redshift is really useful to manager different data souces. Review collected by and hosted on G2.com.

It needs more data sources, connetc with external sources using endpoints. Review collected by and hosted on G2.com.

The features of Redshift which stand out amongst other cloud data warehouses are Automatic Workload Management (which allows to segregate your workloads, like ETL and Reporting and allocate a part of cluster resources to each workload - such that both of these can work in their 'own' space), Elastic Resizing (which allows you to scale your cluster up and down within minutes), Concurrency Scaling (which allows you to have a virtually unlimited number of connections on your Redshift cluster as additional capacity is added on-demand according to the workload).

Some other features worth the mentions are UDF and Stored Procedures (now you can also call AWS Lambda functions from within a UDF, isn't that cool.!!), Fully automated maintenance (including the tedious and time-taking Vacuum and Delete operations) which is really a big deal for data warehouses, Federated queries (to query other databases like RDS PostgreSQL from Redshift.

It is also amazing to see how AWS listens to customer feedback and implement new features at a great pace. Review collected by and hosted on G2.com.

Few limitations of Redshift are listed below -

1. Single Commit Queue - Redshift is primarily used for OLAP (On-line Analytical Processing) workloads. It is not recommended for OLTP (Transactional) workloads where heavy write operations are performed. Due to the single commit queue, writes are slower than other traditional databases (like PostgreSQL)

2. Constraints: Redshift does not enforce constraints like UNIQUE, Primary, and Foreign keys. Although, they can be used while creating tables and they are used by the compiler to determine the most effective query plan.

3. Although not a show stopper, Redshift could definitely benefit from having the ability to query another Redshift cluster from one (feature like dblink). Review collected by and hosted on G2.com.

On the fly query performance, the way it stores the data, and parallel computing of aggregations. pre-computing aggregated results with materialized views. Importing and exporting the data from S3 with COPY UNLOAD command makes life easier to utilize whole AWS resources. The newly updated Query editor improves usability. AWS KMS integration with redshift provides a more secure way of making application-level connectivity. Sort keys and Distribution keys play the main role in optimizing the query. Understanding in-depth about these concepts constantly improves the overall performance of the query.

Best competitor for snow flow and big query. Review collected by and hosted on G2.com.

pricing and it should be serverless, better it should be for pay for use. Tuning documentation with all the positive scenarios need to be covered. Better to focus on automated Tuning for the different types of data.

During the high traffic times, data needs to be moved across the cluster for better computing, but currently, this is not happening. Can improve the caching layer for frequent queries aggregations for live updating websites. Concurrent queries on redshift decrease the overall performance. There needs to be an easier way to retrieve the schema of the table programmatically or SQL way. when utilization is less, better to look for a cost optimization view if serverless is not possible. Review collected by and hosted on G2.com.

I have worked as Data Analyst with Webster Bank and I was using AWS Redshift as a Data Warehouse. It takes data from different sources and put them together in Redshift for our Analytics team to diagnose.

It is fairly quick and easy to set up and we can add nodes fairly quick to expand the data needs. Review collected by and hosted on G2.com.

Finding errors during a data load can be a little daunting at times and it needs a better query analyzer. Review collected by and hosted on G2.com.

This services is very scaleble for user and his give us best product for us. I have use this service since last 1 years. I have great experince in it. Review collected by and hosted on G2.com.

I think should be better price give for user for more usable services. Review collected by and hosted on G2.com.

Parallel processing which doesn't consider the way the tables are built ;)

Ability to query directly from S3

Extending the functions to use Python code. Review collected by and hosted on G2.com.

Coming from a traditional data warehouses few people miss procedures a lot Review collected by and hosted on G2.com.

Cloud Native Interface with very impressive features

Its too easy to work on an SQL supportive tool Review collected by and hosted on G2.com.

Does not support No Structured Query Language

Unstructured format support is always an issue

But it is good for Transactional DBMS Review collected by and hosted on G2.com.