Raw SQL step with Parameter fails

Unknown

Raw SQL step with Parameter fails

Unknown

I am running a query that executes successfully in the query editor, but when we use the same is run in the Raw SQL step, it throws an error. (See below). What should we do have the query execute successfully in the Raw SQL step?

[img]att2[/img]

[img]att1[/img]
[i]edited by Jibbin Mathew on 11/13/2020[/i]

Unknown

In the Raw SQL step, we will need to pass the parameter in a single quote rather than in double-quotes. In this way, your query should execute successfully in the Raw SQL step also.

[img]att1[/img]