Amazon Redshift

Fast data retrieval from the table with complex joins via columnar storage and advanced query optimization techniques like parallel execution

Great reliable integration with AWS MSK using Amazon Redshift Streaming a low-latency streaming ingestion, AWS Glue and S3

Concurrency scaling and work load management - helps in segregating the load distribution based on roles

Decoupled storage and compute using RA3 instance type

Distribute cluster using Amazon Redshift data sharing i.e centralised write cluster with multiple readonly cluster

Seamlessly integrates with the data in s3

Workbench provides useful way to query the tables within aws console

Postgres flavor of sql gives powerful capabilities such as window functions

[Amazon] Redshift has Distribution Keys. If you correctly define them on your tables, it improves Query performance. For instance, we can define Mapping/Meta-data tables with Distribution-All Key, so that it gets replicated across all the nodes, for fast joins and fast query results.

[Amazon] Redshift has Sort Keys. If you correctly define them on your tables along with above Distribution Keys, it further improves your Query performance. It also has Composite Sort Keys and Interleaved Sort Keys, to support various use cases

[Amazon] Redshift is forked out of PostgreSQL DB, and then AWS added "MPP" (Massively Parallel Processing) and "Column Oriented" concepts to it, to make it a powerful data store.

[Amazon] Redshift has "Analyze" operation that could be performed on tables, which will update the stats of the table in leader node. This is sort of a ledger about which data is stored in which node and which partition with in a node. Up to date stats improves Query performance.

Ease of setting up ETL

Uploading data into Redshift via AWS

Querying is quick

Data retrieval experience really gets improved.

In terms of database management, it is really a no management at all in AWS. There is no even an OS to take care or worry about.

Auto or on-demand scaling is nice.

Integrates quite well with other products within the AWS ecosystem.