Loading

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

Data pubblicazione: Apr 13, 2024
Descrizione

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. 

 

Risoluzione
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
Numero articolo Knowledge

001474411

 
Caricamento
Salesforce Help | Article