Showing posts with label Data flow. Show all posts
Showing posts with label Data flow. Show all posts

Azure Data Factory: Upsert using Data Flows

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