Azure Data Factory - 'variables' is not a recognized function

Question

We are using an Azure SQL Database sink in a Copy Activity.

The requirement is for us to execute a stored procedure here via the "Pre-Copy Script" property of the Sink. We are using Dynamic Content, passing in a "ProcessName" parameter. As you can see, we have a ProcessName variable, and it is used in a call to @concat() to build the stored procedure string for this Sink property.

However, any time we use the variables collection in Dynamic Content, we get this warning as shown in the image. The warning states:

'variables' is not a recognized function

Is there a way to avoid having this "Warning" in the UI? It works fine, but it looks terrible. It appears everywhere we use variables, not just in this case.

user_7007791 · Answer

Try using pipeline parameters instead of variables and calling it as explained here: https://docs.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions

You are most likely going to have to change your logic to do this. But if it works fine as it is, I wouldn't mind changing logic or code just to stop seeing the warning in the UI.

Hope this helped!

Azure Data Factory - 'variables' is not a recognized function

1 Answers