KNOWLEDGE BASE

Long "Executing Query" Or Fail to Refresh Extract When Connecting to Amazon Redshift


Published: 27 Aug 2021
Last Modified Date: 02 Sep 2021

Issue

When connecting to Amazon Redshift with the ODBC driver 1.4.34, Then query time is long and could not return data.
Or the refresh extract does not finish for a long time and looks stalled. 

 

Environment

  • Tableau Desktop
  • Amazon Redshift
  • Amazon Redshift ODBC driver 1.4.34

Resolution

Please use ODBC Driver 1.4.10 and connect to Amazon Redshift.
The steps are as follows:

For Mac:
1. Download an earlier driver 1.4.10 from the Amazon website. The direct download link for driver 1.4.10 is:
https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.4.10.1000/AmazonRedshiftODBC-1.4.10.1000.dmg

2. Find the path where Amazon Redshift ODBC driver is installed from the file "odbcinst.ini" under this path: /Library/ODBC/
Delete the whole Amazon Redshift ODBC driver folder and its subfolders.

3. Delete the entries related to Amazon Redshift in the ini file "odbcinst.ini" under this path:
/Library/ODBC/
Save the change.

4. Install Amazon Redshift ODBC driver 1.4.10

5. Restart Tableau Desktop

6. Try to connect to your Amazon Redshift database
Did this article resolve the issue?