From the course: Data Science on Google Cloud Platform: Designing Data Warehouses

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Update data

Update data

- [Narrator] As any other database system, BigQuery also allows users to update and delete data in their tables. Standard SQL update and delete statements work in the same way in BigQuery as they would in any other IBM system. For example, we will update the minimum value of blood sugar normal range to 75 in the normal ranges table. This is the query for the same. Let us execute that query. The query is failing because we have not enabled Standard SQL. This is a problem that you would keep facing all the time, so make sure that you disable Legacy SQL before you run this query. So, the query has completed, and it has said that there is one row affected. We can also execute delete statements in the same fashion. I will now delete the record for heart rate from the normal ranges table. Both statements have now been executed. We can look at the results by going to the normal ranges table, and doing a preview.

Contents