Liquibase and Bigquery integration

General Discussion
1

I’m using Liquibase 4.27.0 version for Bigquery, trying to deploy Liquibase in docker environment using
Gitaction .
First time able to deploy it successfully, DATABASECHANGELOG DATABASECHANGELOGLOCK
table create successfully.
2nd time rerun the workflow(no code change), expectation is that it should find an existing table
and get the same message. But it trying to create DATABASECHANGELOG table which is allready there.
and getting below error,

[2024-05-28 11:01:48] WARNING [liquibase.configuration] Potentially ignored key(s) in file exists at path liquibase.properties

  • ‘EOF’
    [2024-05-28 11:01:48] WARNING [liquibase.command] Ignoring the global liquibase.driver value in favor of the command value.
    ERROR: Exception Details
    ERROR: Exception Primary Class: GeneralException
    ERROR: Exception Primary Reason: BIGQUERY_API_ERR
    ERROR: Exception Primary Source: Google BigQuery 1.2
    [2024-05-28 11:01:53] SEVERE [liquibase.integration] [Simba]BigQueryJDBCDriver Error executing query job. Message: BIGQUERY_API_ERR [Failed SQL: (100032) CREATE TABLE CDWH_LIQUIBASE.DATABASECHANGELOG (ID STRING(255), AUTHOR STRING(255), FILENAME STRING(255), DATEEXECUTED datetime, ORDEREXECUTED INT, EXECTYPE STRING(10), MD5SUM STRING(35), DESCRIPTION STRING(255), COMMENTS STRING(255), TAG STRING(255), LIQUIBASE STRING(20), CONTEXTS STRING(255), LABELS STRING(255), DEPLOYMENT_ID STRING(10))]
    liquibase.exception.CommandExecutionException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: [Simba]BigQueryJDBCDriver Error executing query job. Message: BIGQUERY_API_ERR [Failed SQL: (100032) CREATE TABLE CDWH_LIQUIBASE.DATABASECHANGELOG (ID STRING(255), AUTHOR STRING(255), FILENAME STRING(255), DATEEXECUTED datetime, ORDEREXECUTED INT, EXECTYPE STRING(10), MD5SUM STRING(35), DESCRIPTION STRING(255), COMMENTS STRING(255), TAG STRING(255), LIQUIBASE STRING(20), CONTEXTS STRING(255), LABELS STRING(255), DEPLOYMENT_ID STRING(10))]