UPDATE table data for complex types (RECORD, Geography, JSON) (Native SQL)
Native SQL — the SQL runs on the BigQuery side (server-side). Prefix with #DirectSQL to use this mode. Runs an UPDATE (or other DML) with complex types such as RECORD (array), Geography, and JSON.
#DirectSQL
UPDATE TestDataset.DataTypeTest
SET ColTime='23:59:59.123456',
ColGeography=ST_GEOGPOINT(34.150480, -84.233870),
ColRecord=(1,"AA","Column3 data"),
ColBigNumeric=1222222222222222222.123456789123456789123456789123456789,
ColJson= JSON_ARRAY('{"doc":1, "values":[{"id":1},{"id":2}]}')
WHERE ColInteger=1