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