Parametrize Snowflake LinkedService

Question

I am trying to parametrise snowflake linkedservice credentials. I am trying to read from keyvault. Based on dbname,i need fetch different secrets from keyvault .I am getting error. I am not sure how to do it.

Answer 1

Hi @Aditya Raj ,

Thanks for using Microsoft Q&A forum and posting your query.

The error you are receiving is because you might not have declared the TableType parameter in your linked service.

In-order to parameterize your Snowflake Linked service, you will have to first create a snowflake linked service and then once after it is created, click on {} to open the JSON payload of the linked service. Then add parameters section to your json payload to declare a parameter for secretName as shown in below code. This should allow you to create a parameterized AKV secretName and you will have to pass the secret name based on the respective database name.

I have attached the JSON payload sample for your reference here : 140823-snowflakelinkedserviceparameterized.txt
You can use this JSON payload and add more parameters as needed in the similar way.

Once you have added parameters, when you use this parameterized linked service in a dataset, then you will see this parameter in the linked service properties section as below:

Hope this info helps. Do let us know if you have further query.

----------

• Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators