AWS redshift documentation change
Summary
Updated case sensitivity handling for SUPER type attributes by replacing 'enable_case_sensitive_identifier' with 'enable_case_sensitive_super_attribute' configuration and modified query syntax
Security assessment
The changes improve query functionality for case-sensitive JSON attributes but don't address security vulnerabilities or introduce security features. The configuration change affects data access methods but doesn't modify authentication, authorization, or data protection mechanisms.
Diff
diff --git a/redshift/latest/dg/super-configurations.md b/redshift/latest/dg/super-configurations.md index c271d881a..9e55c30da 100644 --- a//redshift/latest/dg/super-configurations.md +++ b//redshift/latest/dg/super-configurations.md @@ -41 +41 @@ The following example uses session parameters to enable lax mode. -When your JSON attribute names are in uppercase or mixed-case, you must be able to navigate SUPER type structures in a case sensitive way. To do that, you can configure `enable_case_sensitive_identifier` to TRUE and wrap the uppercase and mixed-case attribute names with double quotation marks. +When your JSON attribute names are in uppercase or mixed-case, you must be able to navigate SUPER type structures in a case sensitive way. To do that, you can configure `enable_case_sensitive_super_attribute` to TRUE and use uppercase and mixed-case attribute names directly in your queries without wrapping them in double quotation marks. @@ -43 +43 @@ When your JSON attribute names are in uppercase or mixed-case, you must be able -The following example illustrates how to set `enable_case_sensitive_identifier` to query data. +The following example illustrates how to set `enable_case_sensitive_super_attribute` to query data. @@ -46 +46 @@ The following example illustrates how to set `enable_case_sensitive_identifier` - SET enable_case_sensitive_identifier to TRUE; + SET enable_case_sensitive_super_attribute to TRUE; @@ -49,2 +49,2 @@ The following example illustrates how to set `enable_case_sensitive_identifier` - SELECT json_table.data."ITEMS"."Name", - json_table.data."price" + SELECT json_table.data.ITEMS.Name, + json_table.data.price @@ -59 +59 @@ The following example illustrates how to set `enable_case_sensitive_identifier` - RESET enable_case_sensitive_identifier; + RESET enable_case_sensitive_super_attribute; @@ -62,2 +62,2 @@ The following example illustrates how to set `enable_case_sensitive_identifier` - SELECT json_table.data."ITEMS"."Name", - json_table.data."price" + SELECT json_table.data.ITEMS.Name, + json_table.data.price @@ -71,0 +72,2 @@ The following example illustrates how to set `enable_case_sensitive_identifier` +Alternatively, you can configure `enable_case_sensitive_identifier` to TRUE and wrap the uppercase and mixed-case attribute names with double quotation marks. For more information, see [enable_case_sensitive_identifier](./r_enable_case_sensitive_identifier.html). +