The key configuration of the Azure SQL - Update Snap lies in how you specify the Update Condition (the SQL WHERE clause). You can pass conditions with or without expressions, and optionally reference upstream document values or pipeline parameters.
Download this Pipeline
-
Without expressions: Provide a static update condition directly in the Update Condition field.
-
Using expressions with upstream values: Enable the expression toggle and reference upstream document fields using the
$ prefix.
Examples:
"EMPNO=$EMPNO and ENAME=$EMPNAME"email = $email"EMPNO=" + $EMPNO + " and ENAME='" + $EMPNAME + "'"
CAUTION: When concatenating strings to build dynamic conditions, be aware of SQL injection risks. Validate or sanitize values passed from upstream sources.
-
Using pipeline parameters: Reference pipeline parameters in the update condition to make the Snap reusable across different environments or runs.
Example: "emp='" + $emp + "'"
To reuse the example pipelines:
- Download and import the SLP file into your Environment.
- Configure Snap accounts.
- Provide Pipeline parameters, if any.
