Amazon Redshift introduces long-term system table retention with Amazon S3 Tables integration

Amazon Redshift

Now supports long-term retention for system table data through native integration with Amazon S3 Tables. You can configure your Redshift system table data retention beyond the current 7-day limit to meet compliance, auditing, and observability requirements.

Once enabled, AWS automatically writes system table data to S3 Tables in Apache Iceberg format and manages partitioning, compaction, and retention.

What to do

• Enable long-term retention for system table data in Amazon Redshift.
• Consolidate system table data from multiple data warehouses into a single location for cross-warehouse observability and analysis.
• Query system table data using Redshift, Amazon Athena, or any Iceberg-compatible engine.

This feature is available for Amazon Redshift Provisioned RG and RA3 instances and Amazon Redshift Serverless in the following AWS Regions: US East (N. Virginia), US East (Ohio), US West (N. California), US West (Oregon), Africa (Cape Town), Asia Pacific (Hong Kong), Asia Pacific (Taipei), Asia Pacific (Tokyo), Asia Pacific (Seoul), Asia Pacific (Osaka), Asia Pacific (Mumbai), Asia Pacific (Hyderabad), Asia Pacific (Singapore), Asia Pacific (Sydney), Asia Pacific (Jakarta), Asia Pacific (Melbourne), Asia Pacific (Malaysia), Asia Pacific (Thailand), Canada (Central), Europe (Frankfurt), Europe (Zurich), Europe (Stockholm), Europe (Milan), Europe (Spain), Europe (Ireland), Europe (London), Europe (Paris), Israel (Tel Aviv), and South America (Sao Paulo).

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.