Amazon Redshift
#170 · Level 3 · Modern architecture · Data and analyticsConcept
Section titled “Concept”Amazon Redshift is a data warehouse — a huge database organized for analysis that produces big reports very fast. It stores data by column, so for big calculations it reads only the columns it needs. It splits one query into many parts and runs them at the same time. It can run either as a Provisioned cluster or as Redshift Serverless. You ask questions with SQL, and Redshift can also read data from an S3 data lake.
Simple example
Section titled “Simple example”An organized archive of the company’s whole financial history, where a question like “sales by department over the last 5 years” gets answered quickly.
Why it’s needed
Section titled “Why it’s needed”A regular database is good for everyday transactions, but slow for analyzing huge amounts of data.
Where it’s used
Section titled “Where it’s used”Business intelligence reports, dashboards, data for big business decisions.
Azure equivalent
Section titled “Azure equivalent”Azure Synapse Analytics / Fabric Warehouse
Learn more
Section titled “Learn more”For details and the latest information, see the official documentation: