dbt-labs / docs.getdbt.com

The code behind docs.getdbt.com
https://docs.getdbt.com/
Apache License 2.0
113 stars 861 forks source link

Case-sensitivity in dbt-redshift via `enable_case_sensitive_identifier` #5706

Open dbeatty10 opened 5 days ago

dbeatty10 commented 5 days ago

Contributions

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

Not certain the best page. Here are some candidates:

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

https://github.com/dbt-labs/dbt-core/issues/1557#issuecomment-963222118 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 https://github.com/dbt-labs/dbt-utils/pull/792 were affected by the default value of enable_case_sensitive_identifier being false.