Long-term system tables retention in Amazon Redshift with Amazon S3 Tables

This article announces Amazon Redshift system table integration with Amazon S3 Tables for extended log retention beyond the standard 7-day limit.

• Automatically delivers system table logs to Amazon S3 Tables in Apache Iceberg format with configurable retention periods
• Eliminates need for custom ETL pipelines by managing partitioning, compression, and retention automatically
• Supports over 25 system views at launch for query history, connection logs, and user activity tracking
• Enables querying from Amazon Redshift, Amazon Athena, AWS Glue, Amazon EMR, and other Iceberg-compatible engines
• Supports individual tables per warehouse or shared tables across multiple warehouses for flexible deployment
• Incurs no additional cost beyond Amazon S3 Tables storage and query charges
• Provides read-only access to preserve audit trail integrity for compliance requirements

This fully managed solution enables months or years of operational data retention for compliance, capacity planning, and performance analysis without custom infrastructure overhead.