How to Install the Native Amazon Redshift ODBC Driver

Aginity Workbench now supports the native Amazon Redshift ODBC driver. It is recommended to install and use it. This driver provides better support for SSL and various other Amazon Redshift functions like AWS IAM authentication.

To use it, follow the below steps:

  1. Download and install the driver. Follow the instructions from Amazon here.
  2. After you install the driver, depending on your version of Windows, select Amazon Redshift (x64) ODBC or Amazon Redshift (x32) ODBC in the driver list, in the lower-left corner of the database connection dialog box. Workbench_Redshift_Drivers.png
  3. (Optional) To specify an authentication type for your connection, click Advanced, select the authentication type, and provide values for the required authentication properties.



Affected Version(s)

Workbench for Redshift

Have more questions? Submit a request


Article is closed for comments.

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.

Powered by Zendesk