How to use SQL Parameters in Jobflow?

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

Add SQL Parameter in Job flow SQL Parameters tab

Provide the sql param expression as ‘Select <key, value> from <table name > ‘and select Datapoint and database in which the user wants to run the sql parameter

Ex: select first_name,dep_id from testdata_medium

Select Datapoint, database and Job order/Dependent job for SQL Param as below

Dependent Job/Job order:

It will show all jobs available in Job flow under Dependent jobs dropdown list

Job order can be Initialization /Before/After

SQL Param will run initially when job flow starts if the Dependent Job and Job order are Initialization

SQL Param will run BEFORE the dependent job when job flow starts if the Dependent Job is selected as any job order is BEFORE

SQL Param will run AFTER the dependent job when job flow starts if the Dependent Job is selected as any job order is AFTER

SQL Param execution:

If user wants to use that SQL parameter in Dataflow instance params ( to override the existed dataflow params) or any other jobs(Task command or DB Command and Looper), then follow the below process

Select Dataflow parameters in Dataflow instance job then drag the required sql param and provide key value as below

$FS_SQL_PARAM_NAME_1. James

Select any other job like Taks command/Looper/DB command and select command tab then drag the required sql param and provide key value as below