Pandas update multiple columns at once >>>
The below working fine in Google Colab but failed with Azure Synapse.., could be due to version of runtime/packages
HISTORY.loc[HISTORY.InstProdID.notnull() & HISTORY.ScanDate.notnull(), ["Last_FileName", "Last_Uploaded", "Sync"]] = pd.DataFrame({'Last_FileName':HISTORY["FileName"], 'Last_Uploaded':HISTORY["Uploaded"], 'Sync':1})