User guide

Limits in Amazon Redshift
Topics
• Quotas and Limits (p. 237)
• Naming Constraints (p. 238)
Quotas and Limits
Amazon Redshift has quotas that limit the number of clusters you can create, the total number of nodes
that you can provision, and the number of snapshots that you can create; these quotas are per AWS
account per region. Amazon Redshift has a default quota for each of these, which are listed at AWS
Service Limits. If you attempt to exceed any of these quotas, the attempt will fail.To increase these
Amazon Redshift quota limits for your account in a region, request a change by submitting an Amazon
Redshift Limit Increase Form.
In addition to quotas, Amazon Redshift has limits for the following per-cluster values. These limits cannot
be increased:
• The number of nodes that you can allocate per cluster, which is based on the cluster's node type.This
limit is separate from the limit for your AWS account per region. For more information about the current
node limits for each node type, see About Clusters and Nodes (p. 6).
• The number of permanent tables that you can create per cluster is 9,990. For more information about
creating a table, go to Create Table Usage Notes in the Amazon Redshift Database Developer Guide.
• The number of user-defined databases you can create per cluster is 60. For more information about
creating a database, go to Create Database in the Amazon Redshift Database Developer Guide.
• The number of schemas you can create per database is 256. For more information about creating a
schema, go to Create Schema in the Amazon Redshift Database Developer Guide.
• The number of concurrent user connections that can be made to a cluster is 500. For more information,
see Connecting to a Cluster (p. 138) in the Amazon Redshift Cluster Management Guide.
• The number of AWS accounts you can authorize to restore a snapshot is 20. For more information,
see Sharing Snapshots (p. 84) in the Amazon Redshift Cluster Management Guide.
• The maximum size of a single row loaded by using the COPY command is 4 MB. For more information,
go to COPY in the Amazon Redshift Database Developer Guide.
API Version 2012-12-01
237
Amazon Redshift Management Guide
Quotas and Limits