Fully managed Petabyte-size Data Warehouse.

Analyze on massive amounts of data, Columnar Store database

• Columnar Store Database
• Business Intelligence

Database vs Data Warehouse

Database

• Built to store current transactions
• Fast access to specific transactions
• Single Source
• Short transactions, small and simple queries
• Writes
• Example:
  • Adding items to your shopping list

Data Warehouse

• Store large quantities of historical data
• Fast complex queries across all the data
• Multiple Sources
• Long transactions, long and complex queries
• Reads
• Example:
  • Generating Reports

Use Case

• Data from:
  • EMR
  • Simple Storage Service — S3
  • DynamoDB
  • Relational Database Services — RDS
  • …

1. First load all the data into Redshift
2. And then query to Redshift
   • By using for example Java libraries JDBC, ODBC

https://youtu.be/Ia-UEYYR44s?si=HYzEbNuy3tB9oK1M&t=25907

Configuration

• Single Node
• Multi Node
  • Leader Node — Manages client connections and receiving queries
  • Compute Node — Stores data and performs queries

Node Types and Sizes:

• Dense Compute — dc
  • High performance
• Dense Storage — ds
  • Lots of data

Compression