How to pass multiple parameters for a synapse notebook activity in ADF pipeline?

Question

How to pass multiple parameters for a synapse notebook activity in ADF pipeline?

Charan N D 0

I am creating N no. of tables in Azure Synapse analytics. The table creations need to be parameterized. I want to pass these parameters in ADF pipeline in the runtime to create tables on the fly. I tested with single table. But I'm stuck for multiple tables. Can you please help me with best approach here?

AnnuKumari-MSFT 34,566 Reputation points Microsoft Employee Moderator

2023-03-27T06:36:42.25+00:00

@Charan N D ,

Just following up to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'

1 answer

Your answer

AnnuKumari-MSFT 34,566 Reputation points Microsoft Employee Moderator

2023-03-27T06:36:42.25+00:00

@Charan N D ,

Just following up to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'

Answer 1

HimanshuSinha 19,527 Microsoft Employee Moderator

Hello @Charan N D ,
Thanks for the question and using MS Q&A platform.
Create parameters on the notebook and I assuming that you have already done that .

User's image

On the ADF side add parameters to the pipeline

User's image

In the pipeline setting and mapping the parameters

User's image

@pipeline().parameters.Adfparameter1

Let me know how it goes.

Himanshu

Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.

HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator

2023-03-30T19:32:50.25+00:00

Hello @Charan N D , We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet . In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help . Thanks Himanshu

Share via

How to pass multiple parameters for a synapse notebook activity in ADF pipeline?

1 answer

Your answer