Execute SQL statements in Azure Synapse SQL

This example Pipeline demonstrates how to execute SQL statements to create a table and perform insert and delete operations.

Download this Pipeline
  1. Configure the Azure Synapse SQL Execute Snap to execute the SQL statement that creates the employee table, and delete and insert operations with an employee record.
  2. Connect the JSON Formatter Snap to the upstream Execute Snap to format the output data.
  3. Connect the File Writer Snap to the JSON Formatter Snap and write the file to SnapLogic database.

    File Writer 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.