Today we will learn on how to perform upsert in Azure data factory (ADF) using data flows
Scenario:
- We will be ingesting a csv stored in Azure Storage (ADLS V2) into Azure SQL by using Upsert method
Steps:
1. Create two connections (linked Services) in the ADF:
1. One for the csv stored in ADLS
2. One for the target Azure SQL