What is Amazon Redshift?
Amazon Redshift is a fully managed data warehouse from AWS for analytics and business intelligence. The service uses a columnar, massively parallel processing (MPP) architecture to analyze large data volumes efficiently using standard SQL, and integrates seamlessly with BI tools such as Tableau, Power BI, and Amazon Quick Suite (formerly QuickSight).
Redshift is available today both as Provisioned clusters (with RA3 nodes that separate compute and storage) and as Redshift Serverless, which scales capacity automatically based on demand without cluster management. Automatic compression reduces storage requirements and accelerates analytical queries.
Core Features
- Columnar Storage: Column based storage optimized for analytics queries
- Massively Parallel Processing: Distributed query execution across multiple nodes
- Redshift Spectrum: Query data directly in S3 without loading it
- Concurrency Scaling: Automatic scaling during query peaks
- Redshift Serverless: Usage based capacity without cluster management
- Machine Learning Integration: Predictions directly in SQL with Redshift ML
Typical Use Cases
Data Warehousing and Business Intelligence
Consolidate data from various sources into a central data warehouse. Redshift integrates with ETL tools like AWS Glue and enables complex analytical queries across large data volumes. BI teams can create dashboards and reports with familiar SQL tools.
Data Lake Analytics
With Redshift Spectrum, query data directly in Amazon S3 without loading it. Combine frequently used data in Redshift with less frequently used data in the data lake for cost optimized analytics. Zero ETL integrations with Aurora and RDS enable timely analytics without manual data copying.
Machine Learning with SQL
Redshift ML enables using machine learning predictions directly in SQL queries. You create models with CREATE MODEL, AWS handles training via Amazon SageMaker, and you call predictions via SQL functions.
Advantages
- Scalable analytics with standard SQL
- Cost advantages through Reserved Instances for predictable workloads
- Seamless integration with S3 data lakes
- No infrastructure management with Redshift Serverless
Integration with innFactory
As an AWS Reseller, innFactory supports you with Amazon Redshift: data warehouse architecture, migration from on premises systems, ETL pipeline design with AWS Glue, performance tuning, and cost optimization.
Available Tiers & Options
Provisioned Clusters
- Predictable performance
- Reserved Instances offer significant savings over on-demand
- RA3 nodes with managed storage decoupled from compute
- Manual capacity planning
Redshift Serverless
- Automatic scaling of capacity (RPU)
- No cluster management
- No charges during idle periods
- Potentially higher costs under constant high utilization compared to Reserved Instances
Typical Use Cases
Frequently Asked Questions
What is Amazon Redshift?
Amazon Redshift is a fully managed data warehouse from AWS with a columnar, massively parallel processing (MPP) architecture. It enables analysis of large data volumes using standard SQL and connects directly with common BI tools.
When should I use Redshift instead of RDS?
Use Redshift for analytical workloads such as complex aggregations, historical data analysis, and business intelligence reporting. Use RDS for transactional workloads with frequent INSERT, UPDATE, and DELETE operations.
What is the difference between Provisioned and Serverless?
Redshift Provisioned requires manual cluster configuration and scaling, offering predictable performance and costs, especially with Reserved Instances. Redshift Serverless scales capacity automatically based on demand and suits unpredictable or fluctuating workloads.
How does Redshift Spectrum work?
Redshift Spectrum lets you query data directly in Amazon S3 without loading it into Redshift first. You define external tables in the AWS Glue Data Catalog that point to S3 data, ideal for combining frequently used data in Redshift with less frequently used data in the data lake.
What does Amazon Redshift cost?
Provisioned clusters are billed per node hour plus storage, with discounts through Reserved Instances for long term usage. Redshift Serverless bills actual capacity consumed in Redshift Processing Units (RPU) per second, with no charges when idle. Exact prices are available on the official pricing page.
Note: All product information on this page has been compiled with care, but is provided without guarantee and may be outdated or incomplete. Cloud services evolve rapidly — features, pricing, SLAs, and availability change frequently. Authoritative and up-to-date information can only be found on the official product page of AWS (official documentation). This page does not represent an offer by AWS.