Delete employee records from Azure Synapse SQL with a condition

This example Pipeline demonstrates how to delete employee records from the employee table by specifying a delete condition.


Delete Snap Example Pipeline

Download this Pipeline
  1. Configure the File Reader Snap to read the EmployeeData.csv file from the SL database.

    File Reader Configuration

    On validation, the Snap generates output in binary format.
    File Reader Output

  2. Configure the CSV Parser Snap to parse binary data and generate output in document format.

    CSV Parser Configuration


    CSV Parser Output

  3. Configure the Mapper Snap to extract only the Employee ID row from the incoming data.

    Mapper Configuration

    On validation, the Snap generates EMP_ID of all the employees in the output.
    Mapper Output

  4. Configure the Azure Synapse SQL Delete Snap to delete employee records from dbo.Employee1 table. Also, specify the Delete Condition to prevent the deletion of rows other than the EMP_ID row from the table.

    Delete Snap Configuration

    On validating the Pipeline, the Snap generates output with the status of the deleted records.
    Delete Snap Output

To successfully reuse pipelines:
  1. Download and import the pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide pipeline parameters as applicable.