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