SourceAmazon Redshift introduces long-term system table retention with Amazon S3 Tables integration
Users no longer need to build and maintain custom ETL pipelines to store historical logs, which reduces operational overhead and eliminates resource contention with production workloads.
- AWS automatically writes Redshift system table data to S3 Tables in Apache Iceberg format and manages partitioning, compaction, and retention.
- Eliminates the need for custom ETL pipelines and avoids resource contention with production workloads.
- Allows consolidation of system table data across multiple data warehouses into a single location for cross-warehouse observability and analysis.
- Enables querying of system table data through Amazon Redshift, Amazon Athena, or any Iceberg-compatible engine.
- AWS Agent Toolkit provides skills for querying system table data to surface performance insights and optimization recommendations.
- Available for Amazon Redshift Provisioned RG and RA3 instances and Amazon Redshift Serverless across global AWS Regions.