🏬Amazon Redshift

NEW

Also known as: Redshift

A fully managed, scalable cloud data warehouse service on AWS for analytical workloads using SQL and columnar storage.

DESCRIPTION

Amazon Redshift is AWS’s petabyte-scale data warehouse optimized for OLAP workloads. It offers columnar storage, compression, and parallel query execution via clusters or serverless. Redshift integrates with S3 for external tables through Spectrum and supports materialized views and data sharing. Use cases include BI dashboards, reporting, and batch analytics. It competes with Snowflake and BigQuery in cloud warehousing. Performance tuning involves distribution styles, sort keys, workload management, and spectrum optimization. Governance and security use IAM, KMS encryption, and VPC controls.

ALTERNATIVE DEFINITIONS

Amazon Web Services

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud.

Emphasizes fully managed nature and petabyte scale.

Source

Amazon Redshift Documentation

Amazon Redshift is a fast, scalable data warehouse that makes it simple and cost-effective to analyze all your data.

Highlights speed, scalability, and cost-effectiveness.

Source

RELATED TERMS

Data Warehouse OLAP Columnar Storage AWS S3 Amazon Redshift Spectrum Extract-Transform-Load SQL Business Intelligence

COMPETING TERMS

Snowflake BigQuery Azure Synapse Analytics

RELATIONS

• Broader: Data Warehouse

KNOWLEDGE AREAS

Data Warehousing & BI Cloud Data Services Data Architecture

TARGET AUDIENCE

Data Engineer BI Specialist Analytics Engineer Data Architect Cloud Architect Chief Data Officer

EXTERNAL SOURCES

• Wikipedia - Amazon Redshift
• Amazon Redshift Documentation - Architecture and components
• Amazon Web Services - Redshift Spectrum overview

TOP QUESTIONS

Why choose Amazon Redshift for BI workloads?

It offers managed scalability, columnar performance, and tight integration with AWS services and S3 for external tables.

Category: Benefits

How does Redshift compare to Snowflake?

Snowflake decouples storage and compute more flexibly; Redshift integrates natively with AWS and offers Spectrum for lake queries.

Category: Comparison

What are best practices for Redshift performance?

Use appropriate distribution styles, sort keys, compression encodings, and workload management queues.

Category: Best practices

What are common Redshift mistakes?

Skipping sort keys, poor distribution choices, and unoptimized Spectrum partitions can slow queries and raise costs.

Category: Mistakes

What security features exist in Redshift?

IAM-based access, KMS encryption, VPC isolation, auditing, and fine-grained column-level security.

Category: Requirements

What risks exist with Redshift?

Misconfigured WLM and large uncompressed tables can cause performance bottlenecks and cost overruns.

Category: Risks

How does Redshift Spectrum work?

Spectrum enables querying data in S3 directly using external tables, reducing data movement and improving lake analytics.

Category: Capabilities

Is Redshift suitable for near-real-time analytics?

With streaming ingestion and materialized views, it can support near-real-time use cases, though true low-latency may require specialized systems.

Category: Use cases

Where should newcomers start with Redshift?

Begin with the architecture docs, a small cluster or serverless setup, and load sample data to test query patterns.

Category: Getting started