How to use SQL Parameters in Jobflow?

How to use SQL Parameters in Jobflow?

Beginner Asked on July 16, 2019 in Diyotta Studio.
Add Comment
1 Answer(s)

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

RE: How to use SQL Parameters in Jobflow?

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

RE: How to use SQL Parameters in Jobflow?

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

RE: How to use SQL Parameters in Jobflow?

 

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

RE: How to use SQL Parameters in Jobflow?

Expert Answered on July 16, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.