Search code examples
azure-data-factory

How move parameter location in Azure Data Factory


I want to move the parameter 'TableName' from the bottom to the top i.e above 'CountName'. I thought it simply a matter of dragging it from its existing location to where you would like. In the image you can see I have the cross-hairs that enable me to drag the Parameter TableName but when I drag and release the Parameter remains at the bottom.

enter image description here

Can someone let me know what I'm doing wrong?

I have updated the image with move arrows, see below enter image description here

I have added another image showing the actual move arrows, see below

enter image description here


Solution

  • I tried the above scenario, and it is same for me.

    enter image description here

    AFAIK, It might not be possible to move the parameters. Either you need to delete all parameters and create by your order or rename the parameter names, types and values might be the workaround as suggested in comments.

    (OR)

    You can edit the parameters in the pipeline JSON as per your requirement.

    enter image description here

    The parameters which are needed for the stored procedure can be created by clicking on import button in it and these will be created in the order of the stored procedure. The stored procedure will identify the parameters by the name of the parameter.

    If you want to change the order, you need to edit your stored procedure or edit the parameters like above.