Article

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

August 20, 2026aws.amazon.com

Amazon Redshift now integrates with Amazon S3 Tables to support system table data retention beyond the existing 7-day limit. This allows automatic replication of system data into Apache Iceberg format for auditing and compliance.

Why it matters

Users no longer need to build and maintain custom ETL pipelines to store historical logs, which reduces operational overhead and eliminates resource contention with production workloads.

The details

Data can be queried through Redshift, Amazon Athena, or Iceberg-compatible engines.
The feature supports Amazon Redshift Serverless and Provisioned RG and RA3 instances.
AWS Agent Toolkit provides skills for surfacing performance insights and optimization recommendations.

Show entities and relationships

Key connections

AWS owns Amazon Redshift
AWS develops and operates the Amazon Redshift cloud data warehouse service.
AWS owns Amazon S3 Tables
AWS provides Amazon S3 Tables for tabular data storage.
AWS owns Amazon Athena
AWS provides Amazon Athena as an interactive query service.
AWS owns AWS Agent Toolkit
AWS provides the AWS Agent Toolkit with skills for querying system table data.
Amazon Redshift uses Amazon S3 Tables
Amazon Redshift integrates natively with Amazon S3 Tables for long-term system table data retention.
Amazon S3 Tables is built with Apache Iceberg
Amazon S3 Tables stores replicated system table data in Apache Iceberg format.

Show 3 more connections

Amazon Athena uses Apache Iceberg
Amazon Athena queries long-term system table data stored in Apache Iceberg format.
AWS Agent Toolkit uses Amazon Redshift
AWS Agent Toolkit provides skills for querying Amazon Redshift system table data to surface performance insights.
Amazon Redshift is related to Amazon Athena
Both Amazon Redshift and Amazon Athena can query system table data stored in S3 Tables.

Related events

Aug 20, 2026•11d ago

•Product Launch