question

BrianJones-321 avatar image
0 Votes"
BrianJones-321 asked ElliottJohnson-7539 published

Any plans for parameter support for the Azure Function Linked Service?

In several of the other Linked Services, you can pass in parameters that can be used in the dynamic content for URLs, Secret Names, etc.

Azure Function does not seem to support this currently. Is there a workaround or plans to support this feature?

Thanks in advance.

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT edited

Hello @BrianJones-321,

Welcome to the Microsoft Q&A platform.

Yes, Azure Function does not support parameterization.

Currently, these are the linked service types are supported for parameterization.

135806-image.png

For more details, refer to Parameterize linked services in Azure Data Factory and Azure Synapse Analytics.

Thank you for sharing the feedback [parameter support for the Azure Function Linked Service]. We appreciate it. We will share and elevate your feedback with the Azure Data Factory/Synapse Analytics product team.

Regarding service general availability, I would suggest to keep an eye on Azure updates.

Azure updates provide information about important Azure product updates, roadmap, and announcements.

Hope this will help. Please let us know if any further queries.


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png 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


image.png (17.0 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @BrianJones-321,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

I don't know that I would classify this as an answer. I am aware what services support parameterization. I'm asking if Azure Functions will be included in the mix, and if so, when? I feel this is a significant limitation within the offering and curious if others have encountered this as well and/or found ways to work around this missing functionality.

0 Votes 0 ·

Hello @BrianJones-321,

Unfortunately, parameter support for the Azure Function Linked Service is not yet supported.

Advanced authoring: For other linked service types that are not in above list, you can parameterize the linked service by editing the JSON on UI:

  • In linked service creation/edit blade -> expand "Advanced" at the bottom -> check "Specify dynamic contents in JSON format" checkbox -> specify the linked service JSON payload.

  • Or, after you create a linked service without parameterization, in Management hub -> Linked services -> find the specific linked service -> click "Code" (button "{}") to edit the JSON.

Refer to the JSON sample to add parameters section to define parameters and reference the parameter using @{linkedService().paramName}.

We will share and elevate your feedback with the Azure Data Factory product team.

Regarding service general availability, I would suggest to keep an eye on Azure Data Factory updates.

Azure updates provide information about important Azure product updates, roadmap, and announcements


0 Votes 0 ·
ElliottJohnson-7539 avatar image
0 Votes"
ElliottJohnson-7539 answered ElliottJohnson-7539 published

Just wanted to point out that the provided custom answer is also not a correct answer, at least as far as I can tell. It is possible to parameterize the Azure Functions Linked Service through the above method, but I believe it's impossible to actually pass parameters to the linked service through an Azure Functions action. The GUI definitely doesn't give you the option to, so the only way to do it would be to manually change the JSON spec of your pipeline. For example:

 "name": "Merge Entities",
     "description": "Get data from SQL Server and merge it into the Azure Table.",
     "type": "AzureFunctionActivity",
     "typeProperties": {
         "functionName": "CopyAmenitiesFromAzureSqlToAzureTable",
         "method": "GET"
     },
     "linkedServiceName": {
         "referenceName": "func_dw_prod_centralus_merge",
         "type": "LinkedServiceReference"
     }

According to the spec, the place to do this would be in the linkedServiceName section by adding a "parameters" key. For example:


         "linkedServiceName": {
             "referenceName": "func_dw_prod_centralus_merge",
             "type": "LinkedServiceReference",
             "parameters": {
                 "environment": "@pipeline().globalParameters.environment"
             }
         }

Unfortunately, when saving the pipeline, it automatically strips out the "parameters" tag we've added, leaving us right back where we started. So this is either impossible, or the method to do it isn't documented... like everything else in Azure.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.