Copy data from the Data Lake to the SQL Database, deleting any existing data each time before loading the new data:
Step 1: Check the existing data in the employee table:
Step 2: Change the data manually in the csv file in data lake:
we need to check whether this change will be visible in the table or not (definitely at the end).
Step 3: Settings in “Sink” option in ADF:
Sink - Pre Copy script needs to be added in the in the sink so that older data can be deleted.
Step 4: Check again in SQL Database whether the table contains the changed values or not:
Subscribe to my newsletter
Read articles from Arpit Tyagi directly inside your inbox. Subscribe to the newsletter, and don't miss out.
Written by
Arpit Tyagi
Arpit Tyagi
Experienced Data Engineer passionate about building and optimizing data infrastructure to fuel powerful insights and decision-making. With a deep understanding of data pipelines, ETL processes, and cloud platforms, I specialize in transforming raw data into clean, structured datasets that empower analytics and machine learning applications. My expertise includes designing scalable architectures, managing large datasets, and ensuring data quality across the entire lifecycle. I thrive on solving complex data challenges using modern tools and technologies like Azure, Tableau, Alteryx, Spark. Through this blog, I aim to share best practices, tutorials, and industry insights to help fellow data engineers and enthusiasts master the art of building data-driven solutions.