Loading

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

Julkaisupäivä: Feb 24, 2026
Kuvaus

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.

Ratkaisu
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. 
Lisäresurssit

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

 

 

Knowledge-artikkelin numero

001473115

 
Ladataan
Salesforce Help | Article