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

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.



