Ravi Sir's Cards › AWS
Warehouse or lake SQL?
This comparison card contrasts Warehouse or lake SQL. Amazon Redshift is described as managed warehouse. It also notes heavy joins/concurrency/BI. Amazon Athena is described as serverless SQL over S3. It also notes pay per scan. The card pairs Amazon Redshift with sustained BI warehouse, and Amazon Athena with lake-native occasional SQL.
Read card text
What this card says
Warehouse or lake SQL?
Amazon Redshift
Managed warehouse; heavy joins/concurrency/BI.
Amazon Athena
Serverless SQL over S3; pay per scan.
Key points
All-day dashboards on modeled tables.
Occasional ad-hoc lake queries.
Example
COPY + views / StartQueryExecution on S3
Use when
Sustained BI warehouse.
Lake-native occasional SQL.