Insert records by creating a new table in Azure Synapse SQL

This example Pipeline demonstrates how to insert data into a table. The table 'employee1' does not exist on the database initially. So, the Snap first creates the table 'Employee1' and then inserts the records read and parsed using the upstream Snaps.


Insert Snap Example Pipeline

Download this Pipeline
  1. Read the data that you want to insert with a File Reader Snap.

    File Reader Configuration

    The CSV file contains the following data:
    CSV Data

  2. Configure the CSV Parser Snap to parse the data from the CSV file in a proper format, ready to be inserted into the database.

    CSV Parser Configuration

  3. Configure the Azure Synapse SQL Insert Snap to insert the data to a table name 'Employee1' under schema 'dbo'.

    Insert Snap Configuration

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