Loading

Error When Adding Data Fields To The View Connecting To Redshift

Data pubblicazione: Apr 13, 2024
Descrizione
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;
Risoluzione
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;
Risorse aggiuntive
Amazon Document: Modifying the server configuration
Numero articolo Knowledge

001474839

 
Caricamento
Salesforce Help | Article