Amazon Redshift Driver Version 1.4.59 Causes Unknown Server Error When Opening a View on Tableau Server

KNOWLEDGE BASE

Amazon Redshift Driver Version 1.4.59 Causes Unknown Server Error When Opening a View on Tableau Server

Published: 30 May 2023
Last Modified Date: 01 Jun 2023

Issue

User gets the following error randomly when trying to open a view in Tableau Server. The data source used is Amazon Redshift and driver version is Redshift ODBC Driver 64 bit Version 1.4.59.

Unknown Server Error

An unexpected error occurred. If you continue to receive this error please contact your Tableau Server Administrator.
Session ID: xxxxxxxxxxxxxx

Would you like to reset the view?

Environment

Tableau Server 2022.3.4
Amazon Redshift
Redshift ODBC Driver 64 bit Version : 1.4.59

Resolution

Use the Redshift ODBC Driver 64 bit Version : 1.4.65

The driver and instructions for both Windows and Linux is available in this third-party website.