Why it matters

Redshift is AWS warehouse. Understanding shapes AWS analytics.

Advertisement

The architecture

Provisioned cluster: nodes + storage.

Serverless option: auto-scale.

Redshift optionsProvisionedcluster + nodesServerlessauto-scaleSpectrumS3 externalRedshift Managed Storage decouples compute + storage for scaling
Redshift model.
Advertisement

How it works end to end

Distribution styles: KEY, ALL, EVEN. Affects join perf.

Sort keys: for range queries.

Spectrum: query S3 without loading.

Data sharing: cross-cluster.