Can not pass the parameter from pipeline in synapse

Question

Can not pass the parameter from pipeline in synapse

Shubham Mehta 61 Microsoft Employee

Hello,

I am trying to execute an Azure Synapse Notebook using Notebook Activity in Synapse Pipelines and I am passing the parameters through pipeline and when I try to get those parameters in notebook with syntax {parameter} It is not able to pass the parameter in the notebook. And I am getting the error from run of the pipeline.
Error: The syntax converted string into hashset which means the parameters is not passed.

py4j.Py4JException: Method getSecret([class java.lang.String, class java.util.HashSet, class java.lang.String]) does not exist

Can someone tell me what I am missing here?

below is my code:

PRADEEPCHEEKATLA 91,656 Reputation points Moderator

2021-12-09T09:56:53.017+00:00

Hello @Shubham Mehta ,

Thanks for the question and using MS Q&A platform.

As per the above screenshot, we are not sure that you are using any Method getSecret class in the notebook. Are you sharing the correct code?

And I'm not sure, why you are declaring the variable again in the below cell?

Note: You can directly use the above defined parameters in the below cell.
PRADEEPCHEEKATLA 91,656 Reputation points Moderator

2021-12-13T10:09:32.03+00:00

Hello @Shubham Mehta ,

Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.
PRADEEPCHEEKATLA 91,656 Reputation points Moderator

2021-12-15T12:21:30.72+00:00

Hello @Shubham Mehta ,

Did you get a chance to accept it as answer?

1 answer

Your answer

PRADEEPCHEEKATLA 91,656 Reputation points Moderator

2021-12-09T09:56:53.017+00:00

Hello @Shubham Mehta ,

Thanks for the question and using MS Q&A platform.

As per the above screenshot, we are not sure that you are using any Method getSecret class in the notebook. Are you sharing the correct code?

And I'm not sure, why you are declaring the variable again in the below cell?

Note: You can directly use the above defined parameters in the below cell.
PRADEEPCHEEKATLA 91,656 Reputation points Moderator

2021-12-13T10:09:32.03+00:00

Hello @Shubham Mehta ,

Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.
PRADEEPCHEEKATLA 91,656 Reputation points Moderator

2021-12-15T12:21:30.72+00:00

Hello @Shubham Mehta ,

Did you get a chance to accept it as answer?

Answer 1

Shubham Mehta 61 Microsoft Employee

The problem was resolved by making 2 changes which are follows:

Assign the pipeline variable to a different variable.
The syntax I used is:

PRADEEPCHEEKATLA 91,656 Reputation points Moderator

2021-12-14T05:58:59.27+00:00

Hello @Shubham Mehta ,

Glad to know that your issue has resolved. You can accept it as answer by clicking on(). This can be beneficial to other community members. Thank you.

Share via

Can not pass the parameter from pipeline in synapse

1 answer

Your answer