Amazon Redshift
Explore Amazon Redshift to understand its distributed, scalable architecture and columnar storage that supports high-speed SQL queries. Learn how to use Redshift clusters, snapshots, and Redshift Spectrum for data analysis, plus integrate machine learning with Redshift ML.
Amazon Redshift is a fully managed data warehousing service that can scale to petabytes of data. It is based on PostgreSQL and can be queried using SQL queries. Amazon Redshift stores data in a columnar format and offers a multi-query engine that optimizes analytic queries.
How Amazon Redshift works
Redshift uses a distributed architecture with multiple nodes working in parallel to execute queries. This Massively Parallel (MPP) architecture enables Redshift to run complex queries and quickly scale horizontally to process large datasets. Redshift is a data warehouse solution that requires data to be loaded into the system before performing analytics. Once the data is loaded, Redshift can process queries with high speed and efficiently.
Note: For a Redshift vs. Athena question, keep in mind that ...