Loading

Error When Adding Data Fields To The View Connecting To Redshift

Date de publication: Apr 13, 2024
Description
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

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;
Résolution
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;
Ressources supplémentaires
Amazon Document: Modifying the server configuration
Numéro d’article de la base de connaissances

001474839

 
Chargement
Salesforce Help | Article