Amazon Redshift long-term system table retention with Amazon S3 Tables is now available in additional AWS Regions

Published
October 15, 2026
https://aws.amazon.com/about-aws/whats-new/2026/10/redshift-long-term-system-table-retention-expansion/

Amazon Redshift

Long-term retention for system table data is now available in additional AWS Regions. This feature allows you to configure retention beyond the current 7-day limit to meet compliance, auditing, and observability requirements.

  • What’s new: System table data retention configured beyond 7 days.
  • Regions: Asia Pacific (New Zealand), Canada West (Calgary), AWS GovCloud (US-East), and AWS GovCloud (US-West).
  • Format: Data is stored in Apache Iceberg format.
  • Querying: Queryable through Redshift, Amazon Athena, DuckDB, or any Iceberg-compatible engine.
  • Instances: Available for Amazon Redshift Provisioned RG and RA3 instances and Amazon Redshift Serverless.
  • Benefits: Eliminates the need for custom ETL pipelines and provides consolidated observability across multiple data warehouses.

What to do

  • Enable long-term retention for your Redshift system table data.
  • Query data using Redshift, Amazon Athena, DuckDB, or any Iceberg-compatible engine.
  • Build observability dashboards using AWS services or third-party tools.

Source: AWS release notes




If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.

Follow our blog

Get the latest insights and advice on AWS services from our experts.

By clicking Sign Up you're confirming that you agree with our Terms and Conditions.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.