# Liquibase Redshift Connectivity **URL:** \ **Category:** General Discussion\ **Created:** [May 31, 2022, 6:07am UTC](https://forum.liquibase.org/t/liquibase-redshift-connectivity/6898 "2022-05-31T06:07:59Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![amandeep](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@amandeep](https://forum.liquibase.org/u/amandeep)\ **Post date:** [May 31, 2022, 6:07am UTC](https://forum.liquibase.org/t/liquibase-redshift-connectivity/6898/1 "2022-05-31T06:07:59Z")
Hi All, I am not able to run liquibase on Amazon Redshift. Getting the below error : [2022-05-27 10:52:56] WARNING [liquibase.database] Unknown database: Redshift [2022-05-27 10:53:02] SEVERE [liquibase.integration] ERROR: current transaction is aborted, commands ignored until end of transaction block liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: Unexpected error running Liquibase: ERROR: current transaction is aborted, commands ignored until end of transaction block [Failed SQL: (0) CREATE TABLE liquibase.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK\_DATABASECHANGELOGLOCK PRIMARY KEY (ID))] Followed the below for jdbc and extension download : [https://repo1.maven.org/maven2/org/liquibase/ext/liquibase-redshift/3.10.1/liquibase-redshift-3.10.1.jar](https://repo1.maven.org/maven2/org/liquibase/ext/liquibase-redshift/3.10.1/liquibase-redshift-3.10.1.jar) [https://s3.amazonaws.com/redshift-downloads/drivers/jdbc/2.1.0.7/redshift-jdbc42-2.1.0.7.zip](https://s3.amazonaws.com/redshift-downloads/drivers/jdbc/2.1.0.7/redshift-jdbc42-2.1.0.7.zip) ---
**Author:** ![tabbyfoo](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/tabbyfoo/32/748_2.png) [@tabbyfoo](https://forum.liquibase.org/u/tabbyfoo)\ **Post date:** [June 14, 2022, 3:58pm UTC](https://forum.liquibase.org/t/liquibase-redshift-connectivity/6898/2 "2022-06-14T15:58:25Z")
> [@amandeep](#): > > I am not able to run liquibase on Amazon Redshift. Getting the below error : We do support Redshift, so it looks like this might be a bug. If it’s persistent, please consider opening a bug report [https://www.liquibase.org/community/contribute/report-bugs](https://www.liquibase.org/community/contribute/report-bugs) ---
**Author:** ![MikeOlivas](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/mikeolivas/32/183_2.png) [@MikeOlivas](https://forum.liquibase.org/u/MikeOlivas)\ **Post date:** [July 5, 2022, 3:34pm UTC](https://forum.liquibase.org/t/liquibase-redshift-connectivity/6898/3 "2022-07-05T15:34:18Z")
Hi @amandeep Can you try using the latest version of the extension and Liquibase? Looks like you are using the Liquibase 3.10.1 extension. Which I assume means you are using Liquibase 3.10.1 as well ---
**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/blake/32/937_2.png) [@Blake](https://forum.liquibase.org/u/Blake)\ **Post date:** [March 10, 2023, 1:13pm UTC](https://forum.liquibase.org/t/liquibase-redshift-connectivity/6898/4 "2023-03-10T13:13:18Z")
This is an old thread, but were there ever resolution steps? I’m getting the same error when trying to use a GitHub action with Redshift. Versions: Action - liquibase-github-actions/update@v4.20.0 Liquibase Redshift - liquibase-redshift-4.20.0.jar Redshift Jar - redshift-jdbc42-2.1.0.12.jar ---
**Author:** ![PJatLiquibase](https://avatars.discourse-cdn.com/v4/letter/p/d26b3c/32.png) [@PJatLiquibase](https://forum.liquibase.org/u/PJatLiquibase)\ **Post date:** [March 10, 2023, 7:49pm UTC](https://forum.liquibase.org/t/liquibase-redshift-connectivity/6898/5 "2023-03-10T19:49:01Z")
If you are getting the “Unknown database: Redshift” error, that would indicate the extension doesn’t recognize what you are connecting to as Redshift. The code looks for “redshift” or port 5439 in the connection URL. Optionally, you could set the system property “liquibase.ext.redshift.force” to true. You can see the code on line 173 here [liquibase-redshift/RedshiftDatabase.java at main · liquibase/liquibase-redshift · GitHub](https://github.com/liquibase/liquibase-redshift/blob/main/src/main/java/liquibase/ext/redshift/database/RedshiftDatabase.java). Does that help? ---
**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/blake/32/937_2.png) [@Blake](https://forum.liquibase.org/u/Blake)\ **Post date:** [March 10, 2023, 8:56pm UTC](https://forum.liquibase.org/t/liquibase-redshift-connectivity/6898/6 "2023-03-10T20:56:35Z")
Thank you for the reply. Do I need to have a custom build of the container to make this all work? I’m currently pointing my GitHub action to liquibase-github-actions/update@v4.20.0. I have a successful connection but see the warning about Redshift not being found and then it appears it can’t create the change log or the lock file. My guess is even though in my classpath I’m pointing to liquibase-redshift-4.20.0.jar it isn’t doing anything with that file. I looked at adding liquibase.ext.redshift.force to one of the parameters in my GitHub action but don’t see that as an available option. I’m probably missing one simple instruction somewhere. ---
**Author:** ![keenjason](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/keenjason/32/980_2.png) [@keenjason](https://forum.liquibase.org/u/keenjason)\ **Post date:** [May 3, 2023, 1:14pm UTC](https://forum.liquibase.org/t/liquibase-redshift-connectivity/6898/7 "2023-05-03T13:14:25Z")
I’m also looking for an answer to this question… **Does the liquibase github action support redshift?** I get this error: > Liquibase Version: 4.21.1 > Liquibase Open Source 4.21.1 by Liquibase > Unexpected error running Liquibase: Cannot find database driver: com.amazon.redshift.jdbc42.Driver This seems to indicate that the github action does not support redshift: > > > Received customer feedback: I expected mysql driver to be packaged inside docker… image just like postgres driver. Customer ended up running > > \`docker run -it liquibase/liquibase sh -c "lpm add mysql && liquibase update "\` > > Suggest including drivers and extensions for all Liquibase supported databases. This means include drivers for these platforms: > > \* Oracle > \* SQL Server > \* Postgres > \* MySQL > \* MariaDB > \* Snowflake > \* Cassandra > \* MongoDB > \* Redshift > \* CockroachDB > \* Cloud Spanner > \* CosmosDB > \* DB2 > \* Firebird > \* SQLite > \* Apache Derby > \* H2 > \* Sybae > \* Informix > \* HyperSQL > \* Teradata > \* VoltDB > \* Vertica > \* Impala > \* SAP Hana > \* SAP MaxDB > \* Hive > \* Yugabyte > \* Neo4j