Hi Kaniz,

thanks for the reply. I am just getting a message that the from statement is invalid. 

It's not explaining much to me.

Our ETL takes the approach of large complex selects in views being read and put into temporary tables (t1 = temporary 1). Then those rows are applied to the target DWH table. This is standard across all our processing. The inserts are working fine. Just the update that is not working yet.

If it is supported to use from in this format I will keep at it and see if I can make it work.

I was thinking maybe this format of update is not yet supported in DataBricks.

Thanks for getting back to me.

Peter