Learning Google BigQuery

Resetting a value

A value can be reset directly in the query:

1. Using testdataset.testtable in the preceding example, enter the query in the following code into the query dialog and click on Run Query:

#standardSQLUPDATE `testdataset.testtable` SET impressions = 20000 WHERE campaign = 'summerdeals'

This should update the impression value to 20000 instead of the original 25000.

2. A value can also be reset by applying arithmetic to a value or applying a function. Using testdataset.testtable in the preceding example, enter the query in the following code into the query dialog and click on Run Query:

#standardSQLUPDATE `testdataset.testtable` ...