aws AWS Big Data Blog ·

Amazon Redshift adds long-term system table retention with S3 Tables

blogobservabilityawsgaarchitectaws-s3aws-redshift
feature

Amazon Redshift now integrates with Amazon S3 Tables to automatically store system table logs in Apache Iceberg format. This capability extends log retention beyond the previous 7-day limit, crucial for long-term compliance, auditing, and performance analysis without custom ETL pipelines. It supports RA3/RG provisioned clusters and Redshift Serverless, enabling analysis via Redshift, Athena, Glue, EMR, and other Iceberg-compatible engines. Log delivery is free, with costs only for S3 Tables storage and querying.

Features (1)
  • Long-term system table retention for Amazon Redshift

    Amazon Redshift now integrates with Amazon S3 Tables to automatically deliver system table logs to S3 in Apache Iceberg format. This extends data retention beyond the previous 7-day limit, supporting enhanced compliance, auditing, and cross-warehouse observability without custom ETL pipelines.

Read the original announcement →

https://aws.amazon.com/blogs/big-data/long-term-system-tables-retention-in-amazon-redshift-with-amazon-s3-tables/

Related releases