Ravi Sir's Cards › AWS
What is Amazon Redshift?
This revision card explains What is Amazon Redshift? It starts from the need that OLTP databases choke on heavy analytic joins across years of facts. It describes redshift is a managed columnar data warehouse for BI and complex SQL at scale. The how-to section notes launch cluster or Serverless , then COPY from S3 , then model tables with DIST/SORT keys , then connect BI. An example on the card is nightly sales facts land via COPY; Looker dashboards query Redshift all day.
Read card text
What this card says
Why do we need it?
OLTP databases choke on heavy analytic joins across years of facts.
What is it?
Redshift is a managed columnar data warehouse for BI and complex SQL at scale.
Redshift
How to do it
Launch cluster or Serverless → COPY from S3 → model tables with DIST/SORT keys → connect BI.
Example
Nightly sales facts land via COPY; Looker dashboards query Redshift all day.