What is Amazon Redshift Serverless?
Amazon Redshift Serverless is the serverless deployment option for Amazon Redshift, the cloud data warehouse service from AWS. The service enables analyzing petabytes of data without provisioning, configuring, or managing clusters. Compute capacity is automatically scaled based on query requirements.
For many organizations, capacity planning for a data warehouse is a constant challenge: too little capacity leads to slow queries, too much capacity causes unnecessary costs. Redshift Serverless solves this dilemma by activating compute only when queries are executed and automatically scaling to the required level.
The service is fully compatible with Redshift SQL syntax, BI tools, and existing ETL pipelines. Switching from provisioned clusters to Serverless requires no changes to queries or applications.
Core Features
- Auto Scaling: RPUs are dynamically scaled based on query complexity and concurrency
- Pay-per-Use: Billing only for actually used compute capacity, no base charge during inactivity
- SQL Compatibility: Full compatibility with Redshift SQL, including stored procedures and UDFs
- Data Sharing: Data sharing between Serverless workgroups and provisioned clusters
- ML Integration: Built-in ML functions for forecasts and anomaly detection directly in SQL queries
Typical Use Cases
Ad-Hoc Data Analysis: Analysts run exploratory queries on large datasets without waiting for compute capacity provisioning. Redshift Serverless automatically scales up when complex queries are executed.
Business Intelligence: BI dashboards and reports access Redshift Serverless, with capacity automatically adjusted to the number of concurrent users and query complexity.
Data Warehousing Without Management: Organizations use Redshift Serverless as a data warehouse without a dedicated DBA team. The serverless architecture eliminates tasks like cluster sizing, patching, and maintenance windows.
Benefits
- No cluster management or capacity planning required
- Costs only during actual usage, ideal for variable workloads
- Full compatibility with existing Redshift queries and tools
- Automatic scaling from individual queries to hundreds of concurrent users
Integration with innFactory
As an AWS Reseller, innFactory supports you with Amazon Redshift Serverless: from migrating existing data warehouses and optimizing query performance to integration with BI tools and ETL pipelines.
Typical Use Cases
Frequently Asked Questions
What is Amazon Redshift Serverless?
Amazon Redshift Serverless is the serverless variant of the data warehouse service Amazon Redshift. The service automatically provisions and scales the necessary compute capacity without requiring cluster configuration or management.
How is capacity measured?
Compute capacity is measured in Redshift Processing Units (RPUs). The service automatically scales RPUs based on workload. Billing is per RPU-hour, with only actually used capacity being charged.
Can I switch between Serverless and Provisioned?
Yes, data can be migrated between Redshift Serverless and provisioned clusters. Both options use the same SQL syntax and support the same data formats, so queries can be transferred without changes.