
- Query data stored in Redshift-managed storage.
- Query open file formats in Amazon S3 (for example, Parquet or ORC).
- Automatically scale compute capacity to match workloads, within limits you set.
- Base capacity — the minimum compute capacity (in RPUs) the workgroup uses to serve queries.
- Max capacity and usage limits — cap compute usage (RPU-hours) to control costs. You can specify actions such as notifying administrators or enforcing limits when thresholds are reached.
- One RPU is approximately 16 GB of memory plus associated compute resources.
- The default base capacity for Redshift Serverless is 128 RPUs.
- Base capacity can be adjusted from 8 RPUs up to 512 RPUs in increments of 8 (8, 16, 24, … 512).
- Increasing base capacity improves query performance for memory- or compute-intensive workloads.
To change the base capacity you can use the AWS Management Console, the UpdateWorkgroup API, or the AWS CLI. Example CLI command:
- Use smaller base capacities (for example,
8–24 RPUs) for small data footprints and development or light workloads. - For larger datasets, high concurrency, or complex queries, increase base capacity. In practice, many production workloads with large tables or high concurrency require
32 RPUsor more. - If your data footprint exceeds thresholds for lower RPU sizes, raise base capacity to avoid performance and storage constraints.
- Cost savings: pay only for compute used rather than for a continuously running cluster.
- Automatic scaling: Serverless scales compute up and down to meet demand, within the limits you configure.
- Simplified operations: no node type selection, cluster resizing, or manual provisioning for typical workloads.
Pricing and exact thresholds vary by AWS region and over time. Use the AWS Console or the latest AWS documentation for Redshift Serverless for up-to-date pricing and limits.
- Amazon Redshift Serverless is an on-demand data warehousing service that manages compute scaling and provisioning automatically.
- RPUs measure compute capacity and performance for Redshift Serverless; they determine both query performance and billing.
- RPUs can scale automatically within the base and max capacity you configure, helping ensure queries are executed efficiently.
- One RPU provides approximately 16 GB of memory. Base capacity can be adjusted from 8 to 512 RPUs in increments of 8. Consider
32+ RPUsfor larger datasets and higher concurrency.


- Amazon Redshift Serverless documentation: https://docs.aws.amazon.com/redshift/latest/mgmt/serverless.html
- AWS CLI reference: https://awscli.amazonaws.com/v2/documentation/api/latest/reference/redshift-serverless/index.html
- Amazon S3: https://aws.amazon.com/s3/
- Parquet: https://parquet.apache.org/
- ORC: https://orc.apache.org/