How to use SQL Parameters in Dataflow?
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