AWS redshift documentation change
Summary
Added documentation for Amazon Redshift patch 197 including new features like increased SUPER datatype capacity, new H3 spatial functions, Federated Permissions enhancements, and improved metadata commands. Updated patch 196 details with new cluster version and feature adjustments.
Security assessment
The change adds documentation for Federated Permissions features including row-level security (RLS) policies, masking policies, and fine-grained access controls. These are security features but there's no evidence of addressing a specific vulnerability. The patch notes describe new capabilities rather than fixes for security issues.
Diff
diff --git a/redshift/latest/mgmt/cluster-versions.md b/redshift/latest/mgmt/cluster-versions.md index 9b57e4798..71bf1db2a 100644 --- a//redshift/latest/mgmt/cluster-versions.md +++ b//redshift/latest/mgmt/cluster-versions.md @@ -5 +5 @@ -Patch 196Patch 195Patch 194Patch 193Patch 192Patch 191Patch 190Patch 189Patch 188Patch 187Patch 186Patch 185Patch 184Patch 183Patch 182Patch 181Patch 180Patch 179Patch 178Patch 177Patch 176Patch 175Patch 174Patch 173Patch 172Patch 171Patch 170Patch 169Patch 168 +Patch 197Patch 196Patch 195Patch 194Patch 193Patch 192Patch 191Patch 190Patch 189Patch 188Patch 187Patch 186Patch 185Patch 184Patch 183Patch 182Patch 181Patch 180Patch 179Patch 178Patch 177Patch 176Patch 175Patch 174Patch 173Patch 172Patch 171Patch 170Patch 169Patch 168 @@ -23,0 +24,2 @@ Critical updates that affect Amazon Redshift behavior are introduced as Amazon R + * Amazon Redshift patch 197 + @@ -84,0 +87,66 @@ Critical updates that affect Amazon Redshift behavior are introduced as Amazon R +## Amazon Redshift patch 197 + +Cluster versions in this patch: + + * 1.0.166219 – Amazon Redshift provisioned cluster version and Amazon Redshift Serverless workgroup version – Released on November 21, 2025 + + + + +### New features and improvements in this patch + + * Any string literal stored in the SUPER datatype can now be up to 16,000,000 bytes. + + * Added GET_NUMBER_ATTRIBUTES(super_object) function that returns the total number of attributes contained within a SUPER object. + + * Release patch compatibility restrictions are enforced for table restore operations. When attempting to restore a table, the backup can only be used on clusters running the same patch version as when the backup was created, one patch version lower than the backup, or any patch version higher than the backup. + + * Enhanced the LIKE operator to properly handle trailing whitespaces in patterns when using CHAR datatype. + + * Introduced 4 new spatial H3 functions operating on cell hierarchies: H3_Resolution, H3_ToParent, H3_ToChildren and H3_IsValid. + + * Enables Amazon Redshift Federated Permissions that simplifies permissions management across multiple Redshift data warehouses by enabling you to define data permissions once and automatically enforce them across all warehouses in your AWS account. + + * Enables object-level grants, fine-grained column-level access control, scoped permissions grants and database-level grants on Amazon Redshift Federated Permissions Catalog objects. + + * Enables CREATE, ALTER, ATTACH, DETACH and DROP RLS policy operations on Amazon Redshift Federated Permissions Catalog. + + * Enables the ability to turn on or off row-level security for relations in Amazon Redshift Federated Permissions Catalog. + + * Enable CREATE, ALTER, ATTACH, DETACH and DROP masking policy operations on Amazon Redshift Federated Permissions Catalog objects. + + * Enables SHOW POLICIES to show RLS and Masking policies on a connected database and attachments on relations in Amazon Redshift Federated Permissions Catalog objects. + + * Enables database users to assume an IAM role to query on an Amazon Redshift Federated Permissions Catalog objects. + + * Enhanced SHOW GRANTS command to support cross-database grant visibility within the same Redshift cluster. + + * Enhanced SHOW GRANTS command to display permissions on TEMPLATE objects. + + * Added support for SHOW COLUMN GRANTS command to simplify discovery of column-level access controls. + + * Added support for SHOW PROCEDURES command to simplify discovery of stored procedure metadata discovery. + + * Added support for SHOW FUNCTIONS command to simplify discovery of user-defined function metadata. + + * Introduced SHOW PARAMETERS command to display parameter metadata for functions and stored procedures. + + * Introduced SHOW CONSTRAINTS command to display constraint metadata for functions and stored procedures. + + * Zero-ETL tables now support concurrency scaling for scan and write queries, providing horizontal scaling during peak loads. + + * Added support for CREATE/CREATE OR REPLACE/DROP VIEW operations on Amazon Redshift Federated Permissions Catalog and on cross-database within the same Redshift cluster. + + * Improved constant strings collation handling in some INTERSECT or EXCEPT queries. + + * Enhanced SHOW TABLES to display a warning message instead of failing when FAS credentials are missing for AWS Glue Data Catalog access. + + * Enhanced SHOW COLUMNS command with additional metadata columns for sort keys, distribution style, encoding, and collation information. + + * Added grantor_name column to SHOW GRANTS output and standardized database_name inclusion across all SHOW GRANTS result sets. + + * Enhanced SHOW TABLES command with additional columns: table_owner, last_altered_time, last_modified_time, dist_style, and table_sub_type. + + + + @@ -88,0 +157,2 @@ Cluster versions in this patch: + * 1.0.163480 – Amazon Redshift provisioned cluster version and Amazon Redshift Serverless workgroup version – Released on November 19, 2025 + @@ -98 +168 @@ Cluster versions in this patch: - * Extended the SHOW TABLE command to include collation information for every column. + * Optimized the plans for correlated IN and EXISTS subqueries by decorrelating them into semi joins. @@ -100 +170 @@ Cluster versions in this patch: - * Enhanced the LIKE operator to properly handle trailing whitespaces in patterns when using CHAR datatype. + * Extended the SHOW TABLE command to include collation information for every column. @@ -123,0 +194,2 @@ Cluster versions in this patch: + * Adds support for writing to Iceberg tables using CREATE TABLE , CREATE TABLE AS SELECT, INSERT INTO, SQL commands. +