In this video Austin walks through how to utilize the upsert copy method for a copy activity inside of a pipeline within Azure Data Factory. If you need to do update and insert new data into your Azure SQL Database, this method will give you the ability to do so using the user interface of Data Factory.