Data Warehouse · Redshift
Amazon Redshift: cloud warehouse
RA3 storage/compute separation, Spectrum federation, PostgreSQL-compatible
Redshift is AWS's warehouse with RA3 storage/compute separation, Spectrum for querying S3 data, and PostgreSQL compatibility—ideal for AWS-integrated warehousing and BI with Glue/S3/QuickSight.
RA3 & separation
Flexible scaling and caching for performance/cost balance.
Spectrum federation
Query external S3 data without heavy movement.
AWS integrations
Tight with Glue, S3/Lake Formation, QuickSight, Lambda.
PostgreSQL-friendly
Familiar SQL and toolchain compatibility.
适用场景 / Use cases
- AWS-native warehousing
- S3 lake federation
- BI dashboards/reports
- Near-real-time analytics