Limits in Amazon Redshift
Topics
• Quotas and Limits (p. 114)
• Naming Constraints (p. 114)
Quotas and Limits
Each Amazon Redshift account has quotas that limit, for example, the number of clusters you can create,
the number of total nodes you can provision, and the number of snapshots you can create. If you attempt
to exceed a quota, the attempt will fail.
Amazon Redshift has a default quota for the number of nodes you can provision in a cluster and an
account.These limits are listed at AWS Service Limits. If you need to increase these Amazon Redshift
quota limits for your account, you can request the 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:
• There are fixed limits on the number of nodes that you can allocate provision for a cluster, even if you
request a quota increase.These limits are different for different node types. For a list of the current
limits, see the Amazon Redshift Node Types section of the Amazon Redshift Pricing page.
• The number of permanent tables that you can create per cluster is 9990. For more information about
creating a table, go to Create Table Usage Notes in the Amazon Redshift Database Developer Guide.
• The number of databases you can create per cluster is 64. For more information about creating a
database, go to Create Database in the Amazon Redshift Database Developer Guide.
• The number of AWS accounts you can authorize to restore a snapshot is 20. For more information,
see Sharing Snapshots (p. 53) in the Amazon Redshift Management Guide.
Naming Constraints
The following is a table that describes naming constraints within Amazon Redshift.
API Version 2012-12-01
114
Amazon Redshift Management Guide
Quotas and Limits
To Next Page
Loading...
Need help?
General
