AWS Amazon Redshift Service Limits
29 quotas for Amazon Redshift. 11 can be increased.
| Quota | Default | Status |
|---|---|---|
Nodes in a cluster Nodes in a cluster capacity | 128 count | Fixed |
Parameter groups Parameter groups general | 20 count | Fixed |
Tables for large cluster node type Tables for large cluster node type capacity | 9,900 count | Fixed |
Security groups Security groups general | 20 count | Adjustable |
RA3 nodes in a cluster RA3 nodes in a cluster capacity | 128 count | Adjustable |
Schemas in each database per cluster Schemas in each database per cluster capacity | 9,900 count | Fixed |
Tables for xlplus cluster node type with a single-node cluster Tables for xlplus cluster node type with a single-node cluster capacity | 9,900 count | Fixed |
Event subscriptions Event subscriptions general | 20 count | Adjustable |
Tables for 8xlarge cluster node type Tables for 8xlarge cluster node type capacity | 200,000 count | Fixed |
Stored procedures in a database Stored procedures in a database general | 10,000 count | Fixed |
Tables for 16xlarge cluster node type Tables for 16xlarge cluster node type capacity | 200,000 count | Fixed |
Subnet groups Subnet groups networking | 50 count | Adjustable |
DC2 nodes in a cluster DC2 nodes in a cluster capacity | 128 count | Adjustable |
Single row size when loading by COPY Single row size when loading by COPY storage | 4 Megabytes | Fixed |
Tables for 4xlarge cluster node type Tables for 4xlarge cluster node type capacity | 200,000 count | Fixed |
Tables for xlarge cluster node type Tables for xlarge cluster node type capacity | 9,900 count | Fixed |
Cluster IAM roles for Amazon Redshift to access other AWS services Cluster IAM roles for Amazon Redshift to access other AWS services identity | 50 count | Fixed |
Snapshots Snapshots general | 700 count | Adjustable |
Concurrency level (query slots) for all user-defined manual WLM queues Concurrency level (query slots) for all user-defined manual WLM queues identity | 50 count | Fixed |
Tables for xlplus cluster node type with a multiple-node cluster Tables for xlplus cluster node type with a multiple-node cluster capacity | 20,000 count | Fixed |
Nodes Nodes capacity | 200 count | Adjustable |
User-defined databases in a cluster User-defined databases in a cluster identity | 60 count | Fixed |
Subnets in a subnet group Subnets in a subnet group networking | 20 count | Adjustable |
Column limit for external tables with pseudocolumns when using AWS Glue Data Catalog Column limit for external tables with pseudocolumns when using AWS Glue Data Catalog general | 1,597 count | Adjustable |
AWS accounts that you can authorize to restore a snapshot per snapshot AWS accounts that you can authorize to restore a snapshot per snapshot general | 20 count | Fixed |
Maximum number of connections for RA3 nodes Maximum number of connections for RA3 nodes networking | 2,000 count | Fixed |
AWS accounts that you can authorize to restore a snapshot per AWS KMS key AWS accounts that you can authorize to restore a snapshot per AWS KMS key general | 100 count | Fixed |
Reserved nodes Reserved nodes capacity | 200 count | Adjustable |
Allowed string value size per ION or JSON file when using AWS Glue Data Catalog Allowed string value size per ION or JSON file when using AWS Glue Data Catalog storage | 16 Kilobytes | Adjustable |
How to Request a Quota Increase
- 1Open the AWS Service Quotas console.
- 2Select Amazon Redshift from the service list.
- 3Find the quota and click "Request increase".
- 4Enter the desired value and submit. Most increases are approved within a few hours.
Learn AWS the Practical Way
Our bi-weekly newsletter teaches hands-on AWS fundamentals. No certification fluff - just practical knowledge.
Subscribe to NewsletterLearn AWS the Practical Way
Our bi-weekly newsletter teaches hands-on AWS fundamentals. No certification fluff - just practical knowledge.
Subscribe to Newsletter