Amazon Redshift now offers long-term system table retention via S3 Tables
Amazon Redshift has introduced native integration with Amazon S3 Tables for long-term system table data retention, extending beyond the previous 7-day limit. This new capability streamlines compliance, auditing, and observability by automatically writing system table data to S3 in Apache Iceberg format, eliminating the need for custom ETL pipelines. It enables consolidated cross-warehouse analysis and allows querying data through Redshift, Amazon Athena, or other Iceberg-compatible engines. The feature is available for Redshift Provisioned RG/RA3 instances and Redshift Serverless in numerous AWS regions.
Features (1) ›
- Long-Term System Table Data Retention with S3 Tables Integration
Amazon Redshift now supports long-term retention for system table data, extending beyond 7 days, through direct integration with Amazon S3 Tables. This feature automatically writes system table data to S3 in Apache Iceberg format, simplifying compliance, auditing, and observability without requiring custom ETL pipelines. It also facilitates consolidated, cross-warehouse analysis and enables querying data with Redshift, Athena, or other Iceberg-compatible engines.
https://aws.amazon.com/about-aws/whats-new/2026/08/redshift-long-term-system-table-retention/
Related releases
- CloudFront OAC now natively supports S3 Multi-Region Access Points as origins AWS What's New ·
- Amazon Redshift adds long-term system table retention with S3 Tables AWS Big Data Blog ·
- SageMaker AI Studio Adds Generative AI Inference Recommendations for Optimized Deployments AWS What's New ·
- Amazon Bedrock now supports SpaceXAI Grok 4.6 with Cross-Region Inference AWS What's New ·
- Amazon Bedrock now supports OpenAI GPT-5.6 models in India AWS What's New ·
- Amazon S3 Metadata and Annotations Now Available in AWS GovCloud (US) Regions AWS What's New ·