🔺

Amazon Redshift

Redshift is Amazon Web Services' data warehouse, built on a modified version of PostgreSQL under the hood. It sits around #27 in real-world usage (roughly 2.3%), designed for large-scale analytical queries across an organization's AWS-hosted data.

📌 Quick facts
Type: Cloud data warehouse
Made by: Amazon Web Services
License: Proprietary/managed-cloud (usage-based)
Hosting: Fully managed on AWS
Primary use case: Enterprise analytics inside an existing AWS environment

Core concepts & example

Redshift speaks a Postgres-like SQL dialect, and commonly bulk-loads data directly from S3:

COPY sales FROM 's3://my-bucket/sales-data/'
IAM_ROLE 'arn:aws:iam::123456789:role/RedshiftRole'
FORMAT AS PARQUET;

SELECT region, SUM(amount) AS total
FROM sales
GROUP BY region;

Getting started

Redshift clusters are created through the AWS Console or CLI — there's no local install, only an AWS account:

# AWS CLI: create a Redshift Serverless workgroup
aws redshift-serverless create-workgroup --workgroup-name my-workgroup

🎯 Best for: enterprise analytics inside an existing AWS environment, especially where data already lives in S3.