Google BigQuery DML - Error while trying to run basic UPDATE

Question

I am trying to run the following basic UPDATE statement

UPDATE [gcp-or:babynames.names_2014] SET name = "Emma B" WHERE name = "Emma"

However, I am getting the following error: "Query Failed Error: 1.1 - 1.76: Unrecognized token UPDATE"

Error

Any suggestions?

Thanks -Oscar

Answer 1

You must use standard SQL for DML functionality. To enable standard SQL, see Enabling Standard SQL

the easiest way is as below

#standardSQL  
UPDATE `gcp-or.babynames.names_2014` SET name = "Emma B" WHERE name = "Emma"