Error When Adding Data Fields To The View Connecting To Redshift

Issue

When connecting to a table in Amazon Redshift, the following error may occur when adding fields to the view.

TableauException:[Amazon][Amazon Redshift](30)Error occurred while trying to execute a query:[SQLState 42703]ERROR: xxxxx does not exist

Environment

Tableau Desktop
Amazon Redshift

Resolution

Check whether enable_case_sensitive_identifier is set to "on" at a user level or a cluster level.

The below command can only override the setting for the duration of the current session.

SET enable_case_sensitive_identifier TO true;

Cause

If enable_case_sensitive_identifier is set to "off" in Redshift, then Redshift cannot recognize data fields that contain capitals in the names.

The following command can only override a setting for the duration of the current session. So it won't change the behavior in Tableau.
SET enable_case_sensitive_identifier TO true;