Amazon Redshift introduces long-term system table retention with Amazon S3 Tables integration

Amazon Redshift now supports long-term retention for system table data through native integration with Amazon S3 Tables, extending retention beyond the current 7-day limit.

• System table data automatically written to S3 Tables in Apache Iceberg format with managed partitioning and compaction
• Eliminates need for custom ETL pipelines to extend retention for compliance and auditing requirements
• Consolidate system table data from multiple data warehouses into a single location for cross-warehouse analysis
• Query data through Redshift, Amazon Athena, or any Iceberg-compatible engine without additional overhead
• AWS Agent Toolkit provides skills for querying system tables to surface performance insights and optimization recommendations
• Available for Redshift Provisioned (RG and RA3) and Serverless across 30+ AWS regions globally

This feature simplifies long-term system table retention and cross-warehouse observability while reducing operational complexity for Redshift customers.