We can now pass pipeline parameters to Azure Function Linked Service
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
We can now pass pipeline parameters to Azure Function Linked Service
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.
Hello @Brian Jones ,
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.
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.
------------------------------