Azure Data Explorer Command dynamic parameter error

user_10241279 0
Viewed 155

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

enter image description here

Step 2: Added two parameters enter image description here

Step 3: Added dynamic expression in command window

enter image description here

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.

adx azure-data-factory azure-data-explorer
2 Answers

Please try to wrap the parameters with curly brackets:

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

user_140148070

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,')')
user_88047760
Related