Amazon Redshift adds support for 200K tables
Share
Services
Amazon Redshift now supports up to 200K tables for Redshift Serverless and for data warehouse clusters with ra3.4xlarge, ra3.16xlarge, and dc2.8xlarge 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 multiple warehouses.
Until now Amazon Redshift supported 100K tables for above-mentioned node types in a single data warehouse. Customers with more tables had to split their tables across Redshift warehouses or move some tables to Amazon S3\. Now customers can migrate their workloads that use up to 200K tables to Amazon Redshift without splitting or moving their tables. This capability is automatically enabled for Redshift Serverless and on all supported node types for existing and new warehouses. 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’s support for 200K tables is available in all AWS Regions where Redshift clusters and Redshift Serverless are available. Please refer to the [AWS Region Table](/about-aws/global-infrastructure/regional-product-services/) for Amazon Redshift’s availability.
3/10/23 - _**This post has been updated to more clearly specify that 200K tables are supported for both Redshift Serverless and for clusters with ra3.4xlarge, ra3.16xlarge, and dc2.8xlarge node types.**_
What else is happening at Amazon Web Services?
Amazon AppStream 2.0 users can now save their user preferences between streaming sessions
December 13th, 2024
Services
Share
AWS Elemental MediaConnect Gateway now supports source-specific multicast
December 13th, 2024
Services
Share
Amazon EC2 instances support bandwidth configurations for VPC and EBS
December 13th, 2024
Services
Share
AWS announces new AWS Direct Connect location in Osaka, Japan
December 13th, 2024
Services
Share
Amazon DynamoDB announces support for FIPS 140-3 interface VPC and Streams endpoints
December 13th, 2024
Services
Share