0

I'm using query API from com.google.cloud.bigquery.BigQuery to perform update operations Ref.

Is there a way to perform bulk update to BigQuery Table similar to insertAll or writeJsonStream.

user2135533
  • 181
  • 1
  • 2
  • 11
  • The best alternative that I can think of is to use a `for loop`. – Scott B Jan 31 '23 at 19:53
  • @ScottB, you mean to keep calling BigQuery::query() in a loop. ok. I will do that till I find a better alternative. Thanks. – user2135533 Feb 01 '23 at 21:27
  • Yes correct. I will post my post as answer, you may upvote it if you think it is a helpful workaround. – Scott B Feb 01 '23 at 21:29
  • @ScottB, this is not what I was looking for. As I'm doing it in for loop. I was looking for one API which will connect once and perform all the operations on the server side. Thanks. – user2135533 Feb 03 '23 at 01:36

1 Answers1

0

You may try and consider as a workaround wherein you will use a for loop to loop into your query() until all your needed update have been successfully executed.

Scott B
  • 2,516
  • 1
  • 8
  • 15