RaghavendraY
New Contributor III

From the documentation, update statement is only supported for Delta Lake tables.

https://docs.databricks.com/sql/language-manual/delta-update.html. Can you check if your tables are delta