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
Download Latest Liquibase Redshift Extension (4.28)
wget -q -O ${JDBC_LIB_PATH}/liquibase-redshift.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