[SQL] DML statements are only supported over tables that have data stored in BigQuery

I am trying to use Update Set syntax to copy one column into another but its not working out. Any idea what to do here? Thankyou for replies.

SELECT PARSE_DATE('%B %d, %Y',SaleDate) From sql-practice-350112.Nashville_housing.housing_sales LIMIT 1000;


UPDATE sql-practice-350112.Nashville_housing.housing_sales SET Date_of_sale = SaleDate
​

I added the new column Date_of_sale from schema edit so dont have code for it.

Continue reading...