Amazon Redshift · Rate Limits

Amazon Redshift Rate Limits

Amazon Redshift exposes three API surfaces - the Redshift control-plane (CreateCluster, DescribeClusters), the Redshift Data API (ExecuteStatement, GetStatementResult), and the Serverless control-plane. All follow standard AWS API throttling per account/region. Cluster-level concurrent connection limits and query-queue concurrency are enforced at the database level. Use exponential backoff with jitter on ThrottlingException.

Amazon Redshift Rate Limits is the machine-readable rate-limit profile for Amazon Redshift on the APIs.io network, in the API Commons Rate Limits shape.

It captures 5 rate-limit definitions, measuring varies, concurrent_connections, and concurrent_queries.

Limit state is signalled in the requestId and retryAfter response headers, and an exhausted limit returns HTTP 400.

This profile was written by API Evangelist and has not been verified against a page the provider published; treat every limit as unconfirmed until a dated transcription replaces it.

The profile also includes 4 backoff/retry policies defined and response codes documented for throttled, quotaExceeded, and serviceUnavailable.

Tagged areas include Rate Limiting, Data Warehouse, and Redshift.

5 Limits Exhausted: HTTP 400 Quota: 400 requestIdretryAfter
Method: generated, dated 2026-05-05.
Written by API Evangelist on 2026-05-05 and not verified against a page the provider published. Treat every limit as unconfirmed until a dated transcription replaces it.
View Source
Rate LimitingData WarehouseRedshift

Limits

Redshift control-plane API account/region
varies
see Service Quotas console for Redshift
Standard AWS API throttling envelope on management calls.
Redshift Data API account/region
varies
see Redshift Data API quotas
ExecuteStatement, BatchExecuteStatement, ListStatements, etc. are throttled per account/region.
Concurrent database connections cluster
concurrent_connections
500
Default per provisioned cluster; configurable, raisable via support.
Concurrent queries (default WLM) cluster
concurrent_queries
50
Cluster-wide concurrency cap across WLM queues; tune via WLM configuration.
Query queue slots per WLM queue queue
concurrent_queries
50
Maximum total slots across queues is 50.

Policies

Backoff with jitter
AWS SDKs default to standard retry mode (truncated exponential backoff with jitter, max 20s, 3 attempts).
Workload management
Configure WLM (manual or auto) and short-query acceleration to spread query concurrency; use Concurrency Scaling to absorb bursts on Provisioned.
Serverless auto-scaling
Redshift Serverless absorbs concurrency by adjusting RPU capacity; bills are still subject to RPU-hour rate.
Quota increases
Cluster, snapshot, and IAM-role limits are soft and raisable via Service Quotas.

Sources

Work with this as data

Every rate limit here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for rate limits

4 MCP tools reach this
  • find_rate_limitsBrowse and filter every rate limit in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This rate limit 
curl "https://apis.io/api/v1/rate-limits/amazon-redshift-rate-limits"
All rate limits 
curl "https://apis.io/api/v1/rate-limits?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.