Amazon Redshift announced native integration with Amazon S3 Tables to support long-term retention of system table data in Apache Iceberg format beyond the 7-day limit.

Key Details

• 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.

In This Story