CODEWITHSUNDEEP
google-bigquery
Kurt Maile
Kurt Maile

Reputation: 1267

BigQuery - DML Suport on Partitioned Tables

I need to be able to patch some table data, in a partitioned table, via DML (e.g update a column from a -> b, delete a row...etc, the usual).

However I get an error in the BQ console that this is not supported for partitioned tables.

Is there a timeframe for this pretty fundamental support?

How are others working around this if at all?

Thanks!

Upvotes: 0

Views: 149

Answers (1)

Michael H
Michael H

Reputation: 11

DML with partitioned tables has been supported (in beta) as of March 2018! https://cloud.google.com/bigquery/docs/using-dml-with-partitioned-tables

Upvotes: 1

Related Questions