Loading

Multiple "[Amazon][Redshift ODBC] (30)" errors received When Trying to Refresh an Amazon Redshift Extract

Publiseringsdato: Feb 24, 2026
Beskrivelse

When attempting to refresh an Amazon Redshift extract in Tableau Desktop, the following errors might occur: 
 

Error: "[Amazon][Redshift ODBC] (30) Error occurred while trying to execute a Query ERROR: Missing data for not-null field DETAIL" 
and"[Amazon][Redshift ODBC] (30) Error occurred while trying to execute a query ERROR: Error converting text to date"

Cause

If there are many null fields in the data source, Redshift converts them into blank strings (“”). Tableau does not know how to handle the blank strings, such as CHAR and VARCHAR data types, and throws an error.

Løsning
The fields in the underlying Amazon Redshift data source should be cast in a way that keeps the Nulls. The Amazon Redshift data conversion BLANKASNULL function can be used to do this. 
Flere ressurser

More about the BLANKSNULL parameter can be found in the AWS Developer Guide:

 

 

Knowledge-artikkelnummer

001473115

 
Laster
Salesforce Help | Article