Welcome to the Alteryx Knowledge Base

Slow Connections With Amazon's Redshift ODBC Driver
user

Created/Edited - 10/13/2025 by Nora Tobon | Alteryx

Summary
Slow Connections With Amazon's Redshift ODBC Driver
Description

Slowness may occur when connecting to Redshift with Amazon's driver version 2.01.

Issue

As noted in the Redshift Data Source Help Page, Amazon's driver version 2.01 is validated for use with Designer and Server (in addition to Simba's driver version 1.5.2). Amazon's driver is required when using Trusted Identity Propagation and users may encounter slow connections from Designer or on-prem servers.

Environment

Designer (all versions)

Redshift with Amazon's driver version 2.01

Cause

The Amazon Redshift driver is searching for the correct region to use.

Resolution

The region corresponding to your location can be found in Region availability section of Amazon's Regions, Availability Zone, and Local Zones webpage. 

 

Workaround:

1. Create a folder with name .aws in the C:\users\<username> on the desktop and the on-prem servers

2. Create a file called config in that folder and add text to it following the example below.

 

[default]

region = us-east-1

 

Note: replace us-east-1 with the region for your location in the AWS documentation.

 

Example of an added config file. 

 

Was this article helpful?