Typical Snap Configurations (Azure SQL Bulk Load)

The key configurations for the Snap are:

Download this Pipeline

1. Without Expression: Directly passing the values via the CSV Generator and the Mapper Snaps.
2. In the below pipeline, the values are passed via the upstream for the Azure Bulk Load Snap to update the table, "dbo"."@prasanna1" on the Azure.
   
   
   
   
   
   
3. The Azure Bulk Load Snap Loads the data into the table and the Azure Execute Snap reads the table contents respectively:
   
   
   
   
   
   
4. With ExpressionsPipeline Parameter: Pipeline parameter set to pass the required table name to the Azure SQL Bulk Load Snap.
5. In the below pipeline:
   
   
   
6. The JSON Generator Snap passes the values to be added to a table intcol.The Mapper Snap passes the values to the table intcol and "dbo"."inttable" to the target table, tablename.The Pipeline parameters are set with values for Tablename, Batchsize and Timeout.The Bulk Load Snap loads the records into the _tablename, with _batchsize (as 1) and _timeout (as 60) using the pipeline param values. The Execute Snap reads the data from the table, inttable. The output preview displays the three records as added via the JSON Generator Snap.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   

To reuse the example pipelines:

1. Download and import the SLP file into your Environment.
2. Configure Snap accounts.
3. Provide Pipeline parameters, if any.