Load data in bulk from Snowflake to Azure Synapse SQL

This example Pipeline demonstrates how to load data in bulk using the Azure Synapse SQL Bulk Load Snap.


Bulk Load Example Pipeline

Download this Pipeline
  1. Configure the Snowflake Select Snap to select the data that you want to load into the Azure Synapse SQL Database.

    Snowflake Select Configuration

    The selected data to be loaded is displayed in the output.
    Snowflake Select Output

  2. Configure the Azure Synapse SQL - Bulk Load Snap to load the data into the BigDataTest7612 table.

    Bulk Load Snap Configuration

    On validation, the success message of the Bulk Load is displayed.
    Bulk Load 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.