Testing Professor
Testing ProfessorMulti-Cloud Guidebook · AWS
All services

Analytics

Amazon Redshift

Petabyte-scale cloud data warehouse.

Official docs

Overview

Redshift offers MPP SQL warehousing with RA3 managed storage, Spectrum (S3 query) and Serverless option.

When to use it

  • BI dashboards
  • Large joins across TB+ datasets
  • Aggregating historical metrics

Setup

  1. Create a Serverless workgroup + namespace.
  2. Load data via COPY from S3.
  3. Connect via JDBC/ODBC or Query Editor v2.

How to use

Load
COPY events FROM 's3://bucket/events/' IAM_ROLE 'arn:aws:iam::...:role/RedshiftLoad' FORMAT AS PARQUET;

QA use cases

  • Store every test-run metric and build trend dashboards over months of QA data.