Typical Snap Configurations (Azure SQL Execute)

The key configuration of the Azure SQL - Execute lies in how you pass the SQL statement to read Azure records. As it applies in SnapLogic, you can pass SQL statements in the following manner:



Download this Pipeline
  1. Without Expression: Directly passing the required SQL statement in the Azure SQL Execute Snap.


  2. With ExpressionsValues from an upstream Snap: The JSON Generator Snap passes the values to be inserted into the table on Azure.




  3. Pipeline Parameter: Pipeline parameter set to pass the required values to the Azure.




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.