KNOWLEDGE BASE

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


Published: 08 Feb 2016
Last Modified Date: 08 Aug 2017

Issue

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"

Environment

  • Tableau Desktop 9.2
  • Amazon Redshift 

Resolution

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. 
 
 

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