Posted On: Sep 10, 2020
HAQM 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 HAQM Redshift without having to split the tables across clusters or storing them in HAQM S3.
Until now HAQM 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 HAQM S3. Now customers can migrate their workloads that use up to 100K tables to HAQM 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 HAQM Redshift during query processing or system maintenance. Views are not included in this limit.
HAQM Redshift supports 100K tables in all AWS Regions it is available in. Please refer to the AWS Region Table for HAQM Redshift’s availability.
For more information about migrating to HAQM Redshift, see the HAQM migration page.