AWS redshift documentation change
Summary
Added documentation about identity column handling and exclusive locks during ALTER TABLE APPEND operations on streaming materialized views
Security assessment
The changes clarify operational constraints (identity column limitations) and concurrency behavior (exclusive locks) but do not address security vulnerabilities or introduce security features. The lock information relates to system performance rather than security protections.
Diff
diff --git a/redshift/latest/dg/r_ALTER_TABLE_APPEND.md b/redshift/latest/dg/r_ALTER_TABLE_APPEND.md index 43eb2e2a5..2ce0b38d7 100644 --- a//redshift/latest/dg/r_ALTER_TABLE_APPEND.md +++ b//redshift/latest/dg/r_ALTER_TABLE_APPEND.md @@ -77 +77 @@ A keyword that specifies that if the target table includes columns that are not -ALTER TABLE APPEND moves only identical columns from the source table to the target table. Column order doesn't matter. + * ALTER TABLE APPEND moves only identical columns from the source table to the target table. Column order doesn't matter. @@ -79 +79 @@ ALTER TABLE APPEND moves only identical columns from the source table to the tar -If either the source table or the target table contains extra columns, use either FILLTARGET or IGNOREEXTRA according to the following rules: + * If either the source table or the target table contains extra columns, use either FILLTARGET or IGNOREEXTRA according to the following rules: @@ -87,4 +87 @@ If either the source table or the target table contains extra columns, use eithe - - - -If a column with the same name but different attributes exists in both tables, the command fails. Like-named columns must have the following attributes in common: + * If a column with the same name but different attributes exists in both tables, the command fails. Like-named columns must have the following attributes in common: @@ -107,0 +105,11 @@ If a column with the same name but different attributes exists in both tables, t + * You can't append an identity column. If both the source table and the target table have identity columns, the command fails. If only the source table has an identity column, include the IGNOREEXTRA parameter so that the identity column is ignored. If only the target table has an identity column, include the FILLTARGET parameter so that the identity column is populated according to the IDENTITY clause defined for the table. For more information, see [DEFAULT](./r_CREATE_TABLE_NEW.html#create-table-default). + + * You can append a default identity column with the ALTER TABLE APPEND statement. For more information, see [CREATE TABLE](./r_CREATE_TABLE_NEW.html). + + * ALTER TABLE APPEND operations hold exclusive locks when run on Amazon Redshift streaming materialized views connected to any of the following: + + * An Amazon Kinesis data stream + + * An Amazon Managed Streaming for Apache Kafka topic + + * A supported external stream, such as a Confluent Cloud Kafka topic @@ -108,0 +117 @@ If a column with the same name but different attributes exists in both tables, t +For more information, see [Streaming ingestion to a materialized view](./materialized-view-streaming-ingestion.html). @@ -111 +119,0 @@ If a column with the same name but different attributes exists in both tables, t -You can't append an identity column. If both the source table and the target table have identity columns, the command fails. If only the source table has an identity column, include the IGNOREEXTRA parameter so that the identity column is ignored. If only the target table has an identity column, include the FILLTARGET parameter so that the identity column is populated according to the IDENTITY clause defined for the table. For more information, see [DEFAULT](./r_CREATE_TABLE_NEW.html#create-table-default). @@ -113 +120,0 @@ You can't append an identity column. If both the source table and the target tab -You can append a default identity column with the ALTER TABLE APPEND statement. For more information, see [CREATE TABLE](./r_CREATE_TABLE_NEW.html).