Redshift

Related: Column

Petabyte-scale Data warehouse, uses servers (not serverless)
One-AZ, uses node infrastructure:
Leader node for query input, plan and aggregation
Compute node partitioned into slices, performes queries on data.
VPC Security controls, IAM, KMS, CloudWatch monitoring
RedShift Enhanced VPC Routing traffic enabled is routing based on NACL, custom DNS and GWs.

• OLAP (Column based) not OLTP (row/transaction)
• Pay as you use … similar structure to RDS
• Direct Query S3 using Redshift Spectrum
• Direct Query other DBs using federated query
• Integrates with AWS tooling such as Quicksight
• SQL-ike interface JDBC/ODBC connections

Data can be imported with S3, DynamoDB, Data Firehouse or Database Migration Service (DMS)

Redshift Resilience and Recovery

Default backups Automatic and manual