Merge data into a table

This example pipeline demonstrates how to merge data into a specific table using the SQL Server Merge Snap.


SQL Server Merge Example Pipeline

  1. Configure the JSON Generator Snap to pass customer-related data (input data). In this example, two documents with customer information from upstream Snap are passed to the downstream Snap.

    JSON Generator Configuration

  2. Configure the SQL Server Merge Snap to merge customer data into a table called customer1. One of the documents has the data of existing customers with an updated phoneno field and another document is of a new customer.

    SQL Server Merge Snap Configuration

  3. Once the Merge Snap execution completes, the record with customername John is updated with phoneno, and a new record is created for customer Shaun.

    SQL Server Merge Output