CODEWITHSUNDEEP
insertgoogle-bigquery
user2539790
user2539790

Reputation: 1

Update/insert data programmatically in bigquery

I would like to insert/update records within Bigquery tables programmatically (either through API/SQL). Does Bigquery support this?

Upvotes: 0

Views: 3621

Answers (2)

WOPR
WOPR

Reputation: 5393

Update, BigQuery now supports INSERT

Upvotes: 0

Michael Manoochehri
Michael Manoochehri

Reputation: 7877

It is not possible to update individual BigQuery records, but it is possible to append data to an existing table. You can insert a data load job via the API, or you can use the "bq" command line client or the BigQuery Web UI

For more info about loading data into BigQuery, see: https://developers.google.com/bigquery/loading-data-into-bigquery

Upvotes: 1

Related Questions