Error with flyway.conf for Redshift

1.2k Views Asked by user5046506 At 10 April 2025 at 19:58

Can you please provide an example of flyway.conf settings for Redshift? I tried using:

flyway.url=jdbc:Redshift://name.redshift.amazonaws.com:5439/DBName

flyway.user=user
flyway.password=pass

but that produced this error:

ERROR: Unable to autodetect JDBC driver for url: jdbc:Redshift:

There are 1 best solutions below

Axel Fontaine On 04 July 2015 at 08:57

There are many issues here:

redshift should be lower case in the jdbc url
You also need to put the Redshift JDBC driver on the classpath (/drivers directory for Flyway command-line)
additionally you need to set flyway.driver to the AWS redshift driver class name (Flyway defaults to the standard PG driver: http://flywaydb.org/documentation/database/redshift.html)