Pre SQL Script in ADF not working as expected

Question

I need to write a delete Pre SQL Script in Sink DataFlow. I need to use parameter value in Where condition something like "Delete From ABC where col_name ="+ $parameter1. Concatenation is only showing the value of paramtere1 and not forming the required query

I have tried all possible options and getting errors like column operands are not allowed in literal expressions and column functions are not allowing in constraints.
How to form Pre SQL script with dynamic where clause coming from parameter value.

Answer 1

Hey, you can use the below query:
Delete from abc where col_name =@{pipeline().parameters.parameter1}