Amazon Redshift long-term system table retention with Amazon S3 Tables is now available in Amazon Web Services China Regions
Amazon Redshift long-term retention for system table data through native integration with Amazon S3 Tables is now available in the Amazon Web Services China (Beijing) Region, operated by Sinnet and the Amazon Web Services China (Ningxia) Region, operated by NWCD. With this feature, you can configure your Redshift system table data retention beyond the current 7-day limit to meet your compliance, auditing, and observability requirements. Once enabled, Amazon automatically writes system table data to S3 Tables in Apache Iceberg format and manages partitioning, compaction, and retention.
Customers use Redshift system tables to monitor query performance, audit data warehouse activity, and meet compliance requirements. With this feature, system table data is replicated automatically, eliminating the need for custom extract transform load (ETL) pipelines and any resource contention with your production workloads. If you operate multiple data warehouses, you can consolidate their system table data into a single location for cross-warehouse observability and analysis. Because the data is stored in the open Apache Iceberg format, you can query it through Redshift, Amazon Athena, or any Iceberg-compatible engine, and build observability dashboards using Amazon services or third-party tools without additional operations overhead.
To learn more, visit our documentation.