Retrieve customer details using a SQL query

This example demonstrates how to execute a SQL query to retrieve customers with a given name from the customer1 table.


SQL Server Execute Example Pipeline

  1. Configure the SQL Server Execute Snap to query the customer1 table. The SQL statement retrieves customer details based on the customername column. Dynamic variable values are provided from the upstream JSON Generator Snap.

    SQL Server Execute Snap Configuration

  2. On validation, the Snap displays the output showing the retrieved customer details.

    SQL Server Execute Snap Output