how to add enable_case_sensitive_super_attribute = true to Redshift?

Question

As per the latest Redshift documentation, this is a valid parameter https://docs.aws.amazon.com/redshift/latest/dg/r_enable_case_sensitive_super_attribute.html#r_enable_case_sensitive_super_attribute-usage-notes

I tried adding it via CDK but get error Could not find parameter with name: enable_case_sensitive_super_attribute

I tried adding it via Console but it is not listed, and no option to add it.  I've checked both default parameters and custom parameter group.

Can this parameter only be set for the current session as in https://docs.aws.amazon.com/redshift/latest/dg/cm_chap_ConfigurationRef.html#t_Modifying_the_default_settings ?

Answer

This issue may arise if the parameter isn't listed, possibly due to regional availability or unsupported Redshift cluster version.
Through AWS CDK, define CfnClusterParameterGroup with the parameter. Errors might occur if the CDK version is outdated or the parameter is region/cluster-specific.

how to add enable_case_sensitive_super_attribute = true to Redshift?

Relevant content