Bigquery schema maangement using Liquibase v4.30. Failing while creating the Databasechangelog table : [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: BIGQUERY_API_ERR

General Discussion
1

I am using liquibase docker image to manage my Bigquery schemas. Liquibase version I am using is v4.30.

while executing the following command :slight_smile:

liquibase --driver=com.simba.googlebigquery.jdbc.Driver --database-changelog-table-name=$database.DATABASECHANGELOG --database-changelog-lock-table-name=$database.DATABASECHANGELOGLOCK update --changelog-file=/changelog/changeSetFile.sql --url=jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=$project;OAuthType=3; --log-level=INFO

I am getting the following error:
Error executing query job. Message: BIGQUERY_API_ERR [Failed SQL: (100032) CREATE TABLEprojectId.datasetname.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))

It is an internal liquibase command, so not sure why it is failing.

2

I think this is a permmisions issue. AFAIK BigQuery uses the “current user” credential but you will need to have the “service account” in order to create tables.