Case-sensitivity in dbt-redshift via enable_case_sensitive_identifier

[dbeatty10]

Contributions

• I have read the contribution docs, and understand what's expected of me.

Link to the page on docs.getdbt.com requiring updates

Not certain the best page. Here are some candidates:

• https://docs.getdbt.com/reference/project-configs/quoting
• https://docs.getdbt.com/docs/core/connect-data-platform/redshift-setup
• https://docs.getdbt.com/reference/resource-configs/redshift-configs

What part(s) of the page would you like to see updated?

dbt-labs/dbt-core#1557 (comment) has helpful insight to some surprising default behavior of Redshift as it relates to case-(in)sensitivity.

The most robust solution is to set the enable_case_sensitive_identifier parameter to true via the AWS console or CLI for the Redshift cluster.

Additional information

The CI tests for dbt-labs/dbt-utils#792 were affected by the default value of enable_case_sensitive_identifier being false.