Posted On: Sep 10, 2020

Amazon Redshift now supports up to 100K tables in a single cluster for clusters with DC2.8XL, DS2.8XL, RA3.4XL, and RA3.16XL node types. This feature is intended for customers with workloads that require a large number of tables to run with Amazon Redshift without having to split the tables across clusters or storing them in Amazon S3.

Until now Amazon Redshift supported 20K tables for above-mentioned node types. Customers with more tables had to split their tables across Redshift clusters or move some tables to Amazon S3. Now customers can migrate their workloads that use up to 100K tables to Amazon Redshift without splitting or moving their tables. This capability is automatically enabled for all supported node types for existing and new clusters. Customers don’t need to change their workloads, data ingestion, or their applications to take advantage of this feature. The limit includes user-defined temporary tables and temporary tables created by Amazon Redshift during query processing or system maintenance. Views are not included in this limit.

Amazon Redshift supports 100K tables in all AWS Regions it is available in. Please refer to the AWS Region Table for Amazon Redshift’s availability.  

For more information about migrating to Amazon Redshift, see the Amazon migration page.