Retrieve data from Azure Synapse SQL with a condition

This example Pipeline demonstrates how to retrieve data from an employee table by specifying a condition to retrieve only those fields where the account type is Savings.


Select Snap Example Pipeline

Download this Pipeline
Configure the Azure Synapse Select Snap to retrieve fields based on the specific condition.

Select Snap Configuration

On validation, the Snap retrieves the list of columns based on the specific condition:
Select Snap 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.