Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198.
Existing Python UDFs will continue to function until June 30, 2026. For more information, see the
blog post
Download the Amazon Redshift JDBC driver, version 2.x
Note
The Amazon Redshift JDBC 2.x driver isn't designed to be thread-safe. Two or more threads concurrently attempting to use the same connection can lead to deadlocks, errors, incorrect results, or other unexpected behaviors.
If you do have a multi-threaded application, we recommend that you synchronize access to the driver to avoid concurrent access.
Amazon Redshift offers drivers for tools that are compatible with the JDBC 4.2 API. The class
name for this driver is com.amazon.redshift.Driver.
For detailed information about how to install the JDBC driver, reference the JDBC driver libraries, and register the driver class, see the following topics.
For each computer where you use the Amazon Redshift JDBC driver version 2.x, make sure that the Java Runtime Environment (JRE) 8.0 is installed.
If you use the Amazon Redshift JDBC driver for database authentication, make sure that you have AWS SDK for Java 2.40.5 or later in your Java class path. If you don't have AWS SDK for Java installed, download the ZIP file with JDBC 4.2âcompatible driver and driver dependent libraries for the AWS SDK:
-
JDBC 4.2âcompatible driver version 2.x and AWS SDK driverâdependent libraries
This ZIP file contains the JDBC 4.2âcompatible driver version 2.x and AWS SDK for Java 2.x driverâdependent library files. Unzip the dependent jar files to the same location as the JDBC driver. Only the JDBC driver needs to be in CLASSPATH.
This ZIP file doesn't include the complete AWS SDK for Java 2.x. However, it includes the AWS SDK for Java 2.x driverâdependent libraries that are required for AWS Identity and Access Management (IAM) database authentication.
Use this Amazon Redshift JDBC driver with the AWS SDK that is required for IAM database authentication.
To install the complete AWS SDK for Java 2.x, see AWS SDK for Java 2.x in the AWS SDK for Java Developer Guide.
-
JDBC 4.2âcompatible driver version 2.x (without the AWS SDK)
Review the JDBC driver version 2.x software license and change log file:
JDBC drivers version 1.2.27.1051 and later support Amazon Redshift stored procedures. For more information, see Creating stored procedures in Amazon Redshift in the Amazon Redshift Database Developer Guide.
