Amazon Redshift
By Amazon Web Services
Amazon Redshift is a fully managed, cloud-based data warehouse from AWS that uses columnar storage and massively parallel processing to run fast analytical queries over large-scale datasets.
Definition
Amazon Redshift is a fully managed, cloud-based data warehouse from AWS that uses columnar storage and massively parallel processing to run fast analytical queries over large-scale datasets.
Overview
Redshift was built specifically for analytical (OLAP) workloads rather than the transactional (OLTP) workloads a database like Amazon RDS handles. Instead of storing data row by row, Redshift stores it column by column, which lets analytical queries that scan and aggregate specific columns across huge tables run far faster than they would in a row-oriented database, and it distributes query execution across multiple compute nodes in parallel to handle large data volumes. As a managed service, AWS handles provisioning, patching, and backups, while Redshift's Spectrum feature also lets queries reach directly into data sitting in Amazon S3 without loading it into the warehouse first, blurring the line between a data warehouse and a data lake. Redshift competes directly with other cloud data warehouses like Snowflake and BigQuery, and is typically fed by ETL/ELT pipelines and queried by BI tools such as Amazon QuickSight as the analytical backbone of a company's reporting stack.
Key Features
- Columnar storage optimized for fast analytical queries
- Massively parallel processing across distributed compute nodes
- Redshift Spectrum for querying data directly in Amazon S3
- Fully managed provisioning, patching, and backups
- Concurrency scaling to handle spikes in query load
- Integration with AWS data and BI tools like QuickSight
- Support for semi-structured data alongside traditional structured tables