
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.
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.
The robustness of the redshift is by far the best across all cloud based data warehouses and it also got a great UI. Review collected by and hosted on G2.com.
Proven to be expensive on a long run and the it restricts the user to stick with the aws infrastructure because redshift has non aws server implementation issues. Review collected by and hosted on G2.com.
It is super efficient and quick at retreiving data and therefore would recommend it to anyone who has a cloud database that is slow and buggy Review collected by and hosted on G2.com.
Nothing particular at the moment. It is too good Review collected by and hosted on G2.com.
Processing speed for Sql queries is fast !
Table data can be sorted based on queries.
User Friendly!
Columnar Database for fast Processing. Review collected by and hosted on G2.com.
Expensive if we want to increase the no. Of cores.
GUI is little bit conplex for the first time users. Review collected by and hosted on G2.com.
fast query processing.
Easy to scale up and down the clusters.
User friendly AWS console. Review collected by and hosted on G2.com.
Nothing so far.
I have been able to get all the benefits I can from a data warehousing tool. Review collected by and hosted on G2.com.
It is fast, we can use it concurrently and we can use SQL over it so we don't have to learn a new language. The Redshift dashboard allow us to cancel request that take too much ressources. We can optimize to allow the request to run faster (with indexing) and the data to take less space on the disk (with column formatting and compression) Review collected by and hosted on G2.com.
It is a little bit expensive if we want both performance and disk space. It's quite easy to use all the disk space available as the data is replicated by default. Sometimes the errors are difficult to find as we have to request specific system table. They could have been available in the AWS console. Review collected by and hosted on G2.com.
AWS Redshift is the cloud-based data warehouse. It's query script is very easy and familiar to other SQL query.
Its support a wide range of data variables.
Due to in cloud, no compliance issue for sensitive data.
Query execution on complex dataset is fast.
Easy to load data from different sources like S3, EC2 or web. Review collected by and hosted on G2.com.
For the new user, schema design is quite complex.
Even GUI for admin is not that much simple Review collected by and hosted on G2.com.
Amazon’s reputation as first movers in this space gives me confidence in their stability. They’ve already seen roadblocks and issues that other providers start to run into Review collected by and hosted on G2.com.
I would prefer support for more languages and interfaces from the user side to connect with Review collected by and hosted on G2.com.
the copy and unload to file support was great
and supports all psql features well
cluster management.
query history etc .. Review collected by and hosted on G2.com.
performance and the space was tightly coupled , some syntax's ware different from psql
computation power and memory should be decoupled Review collected by and hosted on G2.com.
I like that the SQL syntax is very similar to Oracle SQL which makes transitioning to Redshift easy. We currently use it as a data warehouse. Review collected by and hosted on G2.com.
I don't like that we can't update an S3 file directly from Redshift when you create an external table. A lot of the times writing from redshift is as important as reading from the S3 file. Review collected by and hosted on G2.com.
I like the online resources available. SQL Syntax is easier to work with compared to other SQL software. Review collected by and hosted on G2.com.
I dislike that there isn't enough user-generated resources online. Most of the only resources about SQL are about MySQL or SQL Server but not redshift, and given the slightly different syntax, a lot of the online help is not easily transferrable. Review collected by and hosted on G2.com.
Highly scalable with the ability to have a huge amount of computing power. Review collected by and hosted on G2.com.
It's on a much older and heavily modified version of postgres. A lot of cool postgres things don't work in redshift. Review collected by and hosted on G2.com.
Redshift follows columnar database structure which performs very efficient wile dealing with columns. I like most of the thing about AWS Redshift, it is easily integrated with S3, Support ANSI standard SQL, easily load/unload data from s3 or other sources. follows ACID properties.indexing, Sorting .. etc Review collected by and hosted on G2.com.
Sometimes queries will perform bad if you forgot to do vacuum/analyse after copy(load). Review collected by and hosted on G2.com.