Can you help me the JAVA API to update the table rows using google cloud bigquery

[shrgupta28]

Hi Team,

We are doing the POC with the new Bigquery API https://github.com/googleapis/java-bigquery

Can you please help me how I can update the table rows using this.

Env:
Java 1.8
Google Cloud Bigquery

Thanks,
Shruti

[pmakani]

@shrgupta28 samples on README please check on that repo.

[shrgupta28]

@pmakani There is no sample for updating the table content.
There are samples to update the dataset structure and table structure.
I am looking for the code using which I can perform update operation on the table data, like updating the record.
I basically need to execute the below operation using the API:
update dataset.Student set Stud_Name = "NewName11", Stud_Class="II" where Stud_Id = 2002

can you help me with this, please.

Thanks.

[stephaniewang526]

we will add samples. meanwhile, PTAL https://cloud.google.com/bigquery/docs/reference/standard-sql/data-manipulation-language

[shrgupta28]

Hi @stephaniewang526 , Any update on how we can perform the Update Operation using the cloud bigquery API.
We are in the final development phase, and this is blocking us. I request your help. Thanks.

[stephaniewang526]

PTAL sample linked above.

[shrgupta28]

Hi @stephaniewang526
The sample UpdateTableDML.java that you provided updates the data in the table..
But is there an API that tells me the number of rows updated in the DB..

While using the BigQuery V2 API, I was able to trace the number of rows updated using the queryResponse.getNumDmlAffectedRows()

Can you tell me the similar API here.. We need to know the number of Affected Rows.

Also, in case of any errors, the BigQuery V2 API used to return the queryResponse.getErrors()
Can you help with this as well.

Thanks.