Cloud · AWS

Amazon Redshift (and vs Snowflake)

awsMediumawsredshiftsnowflakewarehousempp

Interview question

What is Amazon Redshift, and how does it compare to Snowflake?

How to answer

The short answer

Amazon Redshift is AWS's cloud data warehouse. It is a columnar, (massively parallel processing) SQL engine for analytics. You load curated data (often from S3) and run BI / SQL workloads.

Output
S3 / Glue / DMS  -->  Redshift  -->  BI tools / dbt / notebooks
                      (leader + compute nodes)

How Redshift feels

  • Leader node plans queries; compute nodes store slices of data
  • Classic clusters are provisioned (node types / count); Redshift Serverless removes capacity planning
  • Spectrum / external tables can query S3 lake data
  • Distribution styles (KEY, EVEN, ALL) and sort keys matter for join performance

Redshift vs Snowflake (fresher comparison)

TopicRedshiftSnowflake
Home cloudAWS-nativeMulti-cloud (AWS/GCP/Azure)
ArchitectureCluster (or Serverless)Separated storage + warehouses (compute)
ScalingResize cluster / concurrency scalingInstant warehouse size / multi-cluster
StorageManaged in cluster or RA3 managed storageCloud under the hood
Pricing feelNode hours or RPU (serverless)Credits for compute + storage
EcosystemDeep AWS (, S3, Glue)Strong cross-cloud + Time Travel / Zero-Copy Clone

When teams pick Redshift

Already all-in on AWS, want Spectrum + Glue Catalog proximity, or existing Redshift skill/cost commitments.

When teams pick Snowflake

Multi-cloud, strong separation of storage/compute, easy clone/time-travel workflows, or vendor neutrality.

Interview tip: Define Redshift as AWS MPP warehouse, mention leader/compute and S3 load path, then contrast Snowflake's storage/compute split and multi-cloud story without dumping feature lists.