# Liquibase failed while creating DATABASECHANGELOG table on Redshift

**URL:** <https://forum.liquibase.org/t/liquibase-failed-while-creating-databasechangelog-table-on-redshift/10224>\
**Category:** General Discussion\
**Created:** [February 18, 2025, 11:37am UTC](https://forum.liquibase.org/t/liquibase-failed-while-creating-databasechangelog-table-on-redshift/10224 "2025-02-18T11:37:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![saipurushoth](https://avatars.discourse-cdn.com/v4/letter/s/e8c25b/32.png) [@saipurushoth](https://forum.liquibase.org/u/saipurushoth)\
**Post date:** [February 18, 2025, 11:37am UTC](https://forum.liquibase.org/t/liquibase-failed-while-creating-databasechangelog-table-on-redshift/10224/1 "2025-02-18T11:37:54Z")

</div>

I have been trying to do a liquibase setup for redshift cluster and I am getting following error:

ERROR: Exception Details

ERROR: Exception Primary Class: RedshiftException

ERROR: Exception Primary Reason: ERROR: syntax error at or near “TAG” in context “255), TAG”, at line 1

Position: 288

ERROR: Exception Primary Source: Redshift 8.0.2

Unexpected error running Liquibase: ERROR: syntax error at or near “TAG” in context “255), TAG”, at line 1

Position: 288 [Failed SQL: (0) CREATE TABLE public.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT\_ID VARCHAR(10))]

I have tried changing the driver version but no effect

current config

liquibase version - 4.28

JDBC\_LIB\_PATH = “/liquibase/lib”

Download Latest Redshift JDBC Driver (2.1.0.12)

wget -q -O ${JDBC\_LIB\_PATH}/redshift-jdbc-driver.jar \

[https://s3.amazonaws.com/redshift-downloads/drivers/jdbc/2.1.0.12/redshift-jdbc42-2.1.0.12.jar](https://s3.amazonaws.com/redshift-downloads/drivers/jdbc/2.1.0.12/redshift-jdbc42-2.1.0.12.jar)

Download Latest Liquibase Redshift Extension (4.28)

wget -q -O ${JDBC\_LIB\_PATH}/liquibase-redshift.jar \

[https://repo1.maven.org/maven2/org/liquibase/ext/liquibase-redshift/4.28.0/liquibase-redshift-4.28.0.jar](https://repo1.maven.org/maven2/org/liquibase/ext/liquibase-redshift/4.28.0/liquibase-redshift-4.28.0.jar)

our properties file:

url=$REDSHIFT\_URL

driver=com.amazon.redshift.jdbc.Driver

classpath=${JDBC\_LIB\_PATH}/redshift-jdbc-driver.jar:${JDBC\_LIB\_PATH}/liquibase-redshift.jar

username=$DB\_USERNAME

password=$DB\_PASSWORD

changeLogFile=$CHANGELOG\_FILE\_PATH

defaultSchemaName=public

liquibase.quoteIdentifiers=true

so can anyone help me on this

---

<div class="post-metadata">

**Author:** ![saipurushoth](https://avatars.discourse-cdn.com/v4/letter/s/e8c25b/32.png) [@saipurushoth](https://forum.liquibase.org/u/saipurushoth)\
**Post date:** [February 21, 2025, 6:54am UTC](https://forum.liquibase.org/t/liquibase-failed-while-creating-databasechangelog-table-on-redshift/10224/2 "2025-02-21T06:54:08Z")

</div>

> [@saipurushoth](#):
>
> our properties file:
> 
> url=$REDSHIFT\_URL
> 
> driver=com.amazon.redshift.jdbc.Driver
> 
> classpath=${JDBC\_LIB\_PATH}/redshift-jdbc-driver.jar:${JDBC\_LIB\_PATH}/liquibase-redshift.jar
> 
> username=$DB\_USERNAME
> 
> password=$DB\_PASSWORD
> 
> changeLogFile=$CHANGELOG\_FILE\_PATH
> 
> defaultSchemaName=public
> 
> liquibase.quoteIdentifiers=true

Hi Team,  
solved the issue by providing the --classpath=/liquibase/lib/liquibase-redshift.jar in liquibase update command

---

<div class="post-metadata">

**Author:** ![Pete](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/pete/32/184_2.png) [@Pete](https://forum.liquibase.org/u/Pete)\
**Post date:** [February 25, 2025, 4:57pm UTC](https://forum.liquibase.org/t/liquibase-failed-while-creating-databasechangelog-table-on-redshift/10224/3 "2025-02-25T16:57:41Z")

</div>

Thanks for coming back to post your solution @saipurushoth!