RE: How to use SQL Parameters in Dataflow?

How to use SQL Parameters in Dataflow?

Payal Beginner Asked on July 16, 2019 in Diyotta Studio.
Add Comment
1 Answers

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

 

RE: How to use SQL Parameters in Dataflow?

Select Context for SQL Param as below

RE: How to use SQL Parameters in Dataflow?

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

RE: How to use SQL Parameters in Dataflow?

Expert Answered on July 16, 2019.
Add Comment

Your Answer

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