Ravi Sir's Cards › AWS
Serverless SQL or warehouse?
This comparison card contrasts Serverless SQL or warehouse. Amazon Athena is described as pay per data scanned on S3. It also notes no cluster to resize. Amazon Redshift: Managed warehouse for heavy joins & concurrency. The card pairs Amazon Athena with occasional / lake-native SQL, and Amazon Redshift with sustained warehouse workloads.
Read card text
What this card says
Serverless SQL or warehouse?
Amazon Athena
Pay per data scanned on S3; no cluster to resize.
Amazon Redshift
Managed warehouse for heavy joins & concurrency.
Key points
Ad-hoc lake queries.
BI dashboards all day on modeled tables.
Example
SELECT on s3://lake/... / COPY + Redshift views
Use when
Occasional / lake-native SQL.
Sustained warehouse workloads.