Azure Data Explorer Command dynamic parameter error

Question

I have added "Azure Data Explorer Command" in ADF pipeline, but it is not accepting dynamic parameters inside command expression.

ex: Step 1: added Azure Data Explorer Command

Step 2: Added two parameters

Step 3: Added dynamic expression in command window

Step 4: Added Kusto function with parameters

.append rfi_ret_qhour_agg <| RFIRetFactAggFunction(@pipeline().parameters.windowStart),@pipeline().parameters.windowEnd)

Not sure why but above expression with dynamic parameters not working.

score 1 · Answer 1 · answered Mar 07 '21 at 08:38

1

Please try to wrap the parameters with curly brackets:

.append rfi_ret_qhour_agg <| RFIRetFactAggFunction(@{pipeline().parameters.windowStart}),@{pipeline().parameters.windowEnd})

answered Mar 07 '21 at 08:38

Ariel Yehezkely

score 1 · Accepted Answer · answered Mar 16 '21 at 06:09

I understand you need to call a ADX function and pass the parameters into it. I would achieve this by the following using @concat.

@concat('rfi_ret_qhour_agg <| RFIRetFactAggFunction(',pipeline().parameters.windowEnd,pipeline().parameters.windowStart,')')

2 Answers2