Azure Data Factory - Stored Procedure Activity Parameters

Question

Azure Data Factory - Stored Procedure Activity Parameters

Felipe Chã 1

I have a stored procedure activity being created in Python SDK as a part of my pipeline. When I pass the parameters of the Stored Procedure via StoredProcedureParameter class, only the value and the type of the parameter are accepted, not the name. Besides the parameters are being correctly created, none of them have name. Can anyone help me with this subject?

Ps: already read the documentation and tried to pass as a dict. did not work. thank you!

1 answer

Your answer

Answer 1

ShaikMaheer-MSFT 38,556 Microsoft Employee Moderator

Hi @Felipe Chã ,

Thank you for posting query in Microsoft Q&A Platform.

Sorry but your ask is not clear. Which activity you are using here in ADF Pipeline? Is it stored procedure activity?

Please note, Stored procedure activity invokes stored procedures of following data stores. Click here to know more about stored procedure activity.

Azure SQL Database
Azure Synapse Analytics
SQL Server Database

If you are looking for running Python from Azure data factory, then you should consider using Custom activity. Click here to know more about this.

Below thread has similar discussion. Kindly check.
https://learn.microsoft.com/en-us/answers/questions/670411/how-to-run-python-scripts-on-adf-with-input-from-s.html

Hope this helps. Please let us know if any further queries.

-------------

Please consider hitting Accept Answer button. Accepted answers help community as well.

Felipe Chã 1 Reputation point

2022-07-19T10:00:38.26+00:00

Sorry if I didn't make myself clear.

Yes, I am trying to create a Stored Procedure Activity with Python. I am being able to create, but when I set the parameters for the Stored Procedure, the name of the parameters are not being created, just the type and value. In documentation, we have a example of how to pass it as a dict:

"param1": { "value": "param1Value","type":"param1Type" }

But It's not working since Data Factory does not recognize this type of usage, and is creating the parameter with null components. Below are a example of how I am being able to create and the result that I am getting:

The result

The method

Remembering that the class StoredProcedureParameter does not have a parameter to receive the name, and his usage its a must for what I have seen.
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2022-07-22T08:50:08.57+00:00

Hi @Felipe Chã ,

Really sorry still I am unclear with ask. There is no activity called stored procedure activity with python in Azure data factory. There only an activity called stored procedure activity which can executed stored procedures of SQL.

You also mentioned I followed some documentation. Could you please help with sharing that documentation link? So that I can understand ask better. Also, if possible, share full screenshot of your activity and implementation details. Thank you.
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2022-08-01T09:48:06.603+00:00

Hi @Felipe Chã , Just checking if you get chance to share updates. If you found any other work around then please feel free to share same here that helps community as well.

------
Please consider hitting Accept Answer button. Accepted answers help community as well.

Share via

Azure Data Factory - Stored Procedure Activity Parameters

1 answer

Your answer