Gradle/Maven dependency for Redshift JDBC driver

Question

I've downloaded the RedshiftJDBC41-1.1.17.1007.jar to use the com.amazon.redshift.jdbc41.Driver for some Redshift POC work that I'm doing, and have been adding it manually to my classpath.

I'd like to now incorporate it into our build, but I can't seem to find an example of a dependency name for it to put in my build.gradle file or find it in a Maven repo. Any tips? (Note, I'm looking for redshift jdbc only, not the older postgres-redshift driver).

Answer 1

Redshift JDBC drivers are now available on maven repo. Look at http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection-with-maven.html

If the link doesn't work, navigate to Querying a Database -> Connecting to a Cluster Using SQL Client Tools -> Configuring Connections in Amazon Redshift -> Configuring a JDBC Connection

Add the redshift repository

<repositories>
    <repository>
      <id>redshift</id>
      <url>http://redshift-maven-repository.s3-website-us-east-1.amazonaws.com/release</url>
    </repository>
</repositories>

And then add the dependency, like

<dependency>
    <groupId>com.amazon.redshift</groupId>
    <artifactId>redshift-jdbc42</artifactId>
    <version>1.2.41.1065</version>
</dependency>

But there are many variants on the driver, so you should visit the page to read more and pick the one you need.