How can I perform bigquery.tabledata().insertAll using the Cloud Bigquery API

[shrgupta28]

Hi Team,

@danoscarmike @stephaniewang526 @pmakani

I need help on an urgent basis.

As per your recommendation, we are migrating to the new Bigquery API https://github.com/googleapis/java-bigquery

Can you please help me how I can perform bigquery.tabledata().insertAll using the Cloud Bigquery API

Earlier we were using BigQuery V2 API to achieve this functionality.

Env:
Java 1.8
Google Cloud Bigquery

Thanks,
Shruti

[pmakani]

@shrgupta28 you can use this example for insert data. InsertDataAndQueryTable

[shrgupta28]

Okay.. thanks for your response.
Is there an API that returns the number of inserts done successfully? can you help me with this.

[pmakani]

@shrgupta28 there is alternative way to use getInsertErrors() , which returns number of rows were not inserted.

[shrgupta28]

Okay, thanks for this information.
I am requesting similar information for #413

[pmakani]

@shrgupta28 second approach is insert data through LoadJobConfiguration and Load Job example available in samples, once you execute load job , it will return LoadStatistics, please check below code.

LoadStatistics statistics = job.getStatistics();
long outputRows = statistics.getOutputRows();