Liquibase issue with GCP Bigquery

Hi Team,

Our Liquibase Version :
Liquibase Version: 4.30.0
Liquibase Open Source 4.30.0 by Liquibase

I am trying to create a table in big-query from one of the VM, Both the VM and Big-Query tables are in same Project, My account is also having Admin access on Big-query.

My Current issue is while I am running the bq to create a table in my existing Dataset, I don’t see any issues.

Hostname: mimic-01-sandbox

BQ Command:
bq --location=us mk --time_partitioning_field timestamp --schema ride_id:string,point_idx:integer,latitude:float,longitude:float,timestamp:timestamp,meter_reading:float,meter_increment:float,ride_status:string,passenger_count1:integer -t dummy_sand2.realtime2
Table ‘clx-sandbox-data-poc-iiuv:dummy_sand2.realtime2’ successfully created.

When I am running Table creation using Liquibase Getting some errors. I have share my Liquibase Command and Error Message details below.

liquibase --driver=com.simba.googlebigquery.jdbc42.Driver --classpath=liquibase-bigquery-4.31.0-javadoc.jar --url=“jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=283215079924;DefaultDataset=dummy_sand2;OAuthType=3” --changeLogFile=1.sql update-sql

cat 1.sql
– liquibase formatted sql

– changeset my_name:1
CREATE TABLE test_table
(
test_id INT,
test_column INT,
PRIMARY KEY (test_id)
)

Error:

liquibase --driver=com.simba.googlebigquery.jdbc42.Driver --classpath=liquibase-bigquery-4.31.0-javadoc.jar --url=“jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=283215079924;DefaultDataset=dummy_sand2;OAuthType=3” --changeLogFile=1.sql update-sql
####################################################

_ _ _ _

| | () () |

| | _ __ _ _ _ | |_ __ _ ___ ___

| | | |/ _ | | | | | '_ \ / _ / __|/ _ \

| || | (| | || | | |) | (| _ \ __/

_/|_, |_,||./ _,|/__|

| |

|_|

Get documentation at docs.liquibase.com

Get certified courses at learn.liquibase.com

####################################################
Starting Liquibase at 22:35:21 using Java 21.0.5 (version 4.30.0 #4943 built at 2024-10-31 17:00+0000)
Liquibase Version: 4.30.0
Liquibase Open Source 4.30.0 by Liquibase
ERROR: Exception Details
ERROR: Exception Primary Class: DatabaseException
ERROR: Exception Primary Reason: Connection could not be created to jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=283215079924;DefaultDataset=dummy_sand2;OAuthType=3 with driver com.simba.googlebigquery.jdbc42.Driver. [Simba]BigQueryJDBCDriver HttpTransport IO error : 403 Forbidden
POST https://bigquery.googleapis.com/bigquery/v2/projects/283215079924/jobs
{
“code”: 403,
“errors”: [
{
“domain”: “global”,
“message”: “Access Denied: Project 283215079924: User does not have bigquery.jobs.create permission in project 283215079924.”,
“reason”: “accessDenied”
}
],
“message”: “Access Denied: Project 283215079924: User does not have bigquery.jobs.create permission in project 283215079924.”,
“status”: “PERMISSION_DENIED”
}.
ERROR: Exception Primary Source: 4.30.0

Unexpected error running Liquibase: Connection could not be created to jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=283215079924;DefaultDataset=dummy_sand2;OAuthType=3 with driver com.simba.googlebigquery.jdbc42.Driver. [Simba]BigQueryJDBCDriver HttpTransport IO error : 403 Forbidden
POST https://bigquery.googleapis.com/bigquery/v2/projects/283215079924/jobs
{
“code”: 403,
“errors”: [
{
“domain”: “global”,
“message”: “Access Denied: Project 283215079924: User does not have bigquery.jobs.create permission in project 283215079924.”,
“reason”: “accessDenied”
}
],
“message”: “Access Denied: Project 283215079924: User does not have bigquery.jobs.create permission in project 283215079924.”,
“status”: “PERMISSION_DENIED”
}.

For more information, please use the --log-level flag

Can you please help me why I am getting the permission errors. I have updated the below Jar file also as per my command.

Please let me know if anyone have any issues.

Regards,
Srinivas V