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

Published: 08 Feb 2016
Last Modified Date: 29 Jul 2020


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" 
"[Amazon][Redshift ODBC] (30) Error occurred while trying to execute a query ERROR: Error converting text to date"


  • Tableau Desktop
  • Amazon Redshift 


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. 


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.
Did this article resolve the issue?