Skip to main content

Redshift

  • Based on PostgreSQL.
  • Columnar storage of data.
  • Provisioned cluster or Serverless cluster.
  • SQL interface for performing queries.
  • Integration with BI tools like Amazon Quicksight or Tableau.

Redshift Cluster​

  • Leader Node: Plans the query.
  • Compute Node: Performs the query.
  • Provisioned Mode: Choose instance types in advance; Reserve instance for cost savings.

Snapshots and Disaster Recovery​

  • Snapshots are backups of a cluster, stored internally in S3.
  • Can restore a snapshot into a new cluster.
  • Automated and Manual.
  • Can configure Amazon Redshift to automatically copy snapshots to another AWS region.

Loading Data​

Redshift Spectrum​

  • Query data from S3 without loading it.
  • Must have a Redshift cluster.