Redshift Link to heading

OLAP data housing service. Data is organized in columns.columns.

Basics Link to heading

• advanced compresion
• doesn’t require indexes nor materialized views.
• massive parallel processing (MPP)
• columnar data storage (less I/Os)

Cluster Link to heading

• a single node has 160Gb
• a multi-node solution can be up to 128 nodes. Consists on a leader node and compute nodes.
• not multi-az. only available on 1 AZ. (Not available)

Pricing Link to heading

• billed per unit of process on a node on a hour
• not charged for the leader
• backups
• data transfer

Encryption Link to heading

• in-transit SSL. EASE-256 enc.
• redshift takes care of key management
  • integration with KMS
  • integration with HSM

Backups Link to heading

• can be moved to different AZs