Where did the 'Script Parameters' section go in the new Snowflake ADF connector?

Robert Baber 0

Where did the 'Script Parameters' section go in the new Snowflake ADF connector?

Old:

User's image

New:

User's image

AnnuKumari-MSFT 32,821 Reputation points Microsoft Employee

2024-08-30T11:35:22.4633333+00:00

Hi Robert Baber ,

Thankyou for using Microsoft Q&A platform and thanks for posting your query here.

I checked with the internal team and got the response that it is not a bug, script parameters are not yet supported in the snowflake new connector in ADF. There is no defined timeline but it might get added on in future. Thankyou
Robert Baber 0 Reputation points

2024-09-05T17:06:25.36+00:00

Hi @AnnuKumari-MSFT thank you. This is very unfortunate - how are customers supposed to migrate off the legacy connector if the new one does not support basic functionality as passing parameters to a stored procedure?

1 answer

Pinaki Ghatak 3,980 Reputation points Microsoft Employee

2024-08-30T20:25:50.86+00:00

Hello @Robert Baber

Please know the 'Script Parameters' section is not available in the new Snowflake ADF connector.

Instead, you can use the Additional Snowflake Copy Options and Additional Snowflake Format Options sections to specify additional options for the copy command and file format, respectively.

These options can be used to achieve the same functionality as the Script Parameters section in the old connector
Please sign in to rate this answer.
Robert Baber 0 Reputation points

2024-09-05T17:08:29.3566667+00:00

Hi @Pinaki Ghatak , I'm not sure what you mean. Where are these sections located in the Script activity?

Robert Baber 0 Reputation points

2024-09-05T17:09:43.6266667+00:00

Hi @Pinaki Ghatak , I'm not sure what you mean. Where are these sections located in the Script activity?

AnnuKumari-MSFT 32,821 Reputation points Microsoft Employee

2024-09-19T08:39:34.58+00:00

Robert Baber ,
Kindly refer to the below images , it might be helpful. Thankyou
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer