How to use SQL Parameters in Dataflow?

SQL Parameters are used to get a column value for the given Key from any table

Add one sql param in Dataflow SQL params tab

Provide the sql param expression as ‘Select <key, value> from <table name > ‘and select ‘Source/Target’ instance as context (Source/Target datapoint is used to run the sql param)

Ex: select emp_id,salary from testdata_medium

The key value is to be used to get the value for the column

Select Context for SQL Param as below

If user wants to use that SQL parameter in derived attributes of any transformation or the next SQL params, then follow the below process

Add derived attribute and select ‘SQL parameters’ from parameters drop down list and then drag the required sql param and provide key value as below

$SP_SQL_PARAM_NAME_1.10001