# Liquibase and Bigquery integration

**URL:** <https://forum.liquibase.org/t/liquibase-and-bigquery-integration/9426>\
**Category:** General Discussion\
**Created:** [May 28, 2024, 11:12am UTC](https://forum.liquibase.org/t/liquibase-and-bigquery-integration/9426 "2024-05-28T11:12:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mahesh](https://avatars.discourse-cdn.com/v4/letter/m/9dc877/32.png) [@Mahesh](https://forum.liquibase.org/u/Mahesh)\
**Post date:** [May 28, 2024, 11:12am UTC](https://forum.liquibase.org/t/liquibase-and-bigquery-integration/9426/1 "2024-05-28T11:12:59Z")

</div>

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))]