Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

how to add enable_case_sensitive_super_attribute = true to Redshift?

0

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 ?

Topics
AnalyticsAWS Cloud Development Kit (CDK)
Tags
Amazon RedshiftAWS Cloud Development Kit (CDK)
Language
English
asked 2 years ago729 views
1 Answer
1

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.

EXPERT
answered 2 years ago
EXPERT
reviewed 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content