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"

Any suggestions?

Thanks -Oscar

score 4 · Accepted Answer · answered Jan 16 '17 at 19:43

4

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"

answered Jan 16 '17 at 19:43

Mikhail Berlyant

Thanks for your prompt respons – Oscar Rodriguez Jan 16 '17 at 19:49
2

For Apache AirFlow users, BigQueryOperator runs with `use_legacy_sql=True` by default. Be sure to set it to False. https://github.com/apache/airflow/blob/db4be19b80a65913edb5ab634226cf60ea8bffea/airflow/gcp/operators/bigquery.py#L487 – gecko655 Nov 25 '19 at 05:31

1 Answers1