Can the azure function activity be used in a self-hosted integration runtime

John Neubecker 76 Reputation points
2023-04-26T18:31:40.52+00:00

Based on the documentation:

  • Dispatching the following transform activities against compute resources in on-premises or Azure Virtual Network: HDInsight Hive activity (BYOC-Bring Your Own Cluster), HDInsight Pig activity (BYOC), HDInsight MapReduce activity (BYOC), HDInsight Spark activity (BYOC), HDInsight Streaming activity (BYOC), ML Studio (classic) Batch Execution activity, ML Studio (classic) Update Resource activities, Stored Procedure activity, Data Lake Analytics U-SQL activity, Custom activity (runs on Azure Batch), Lookup activity, and Get Metadata activity.

It seems like the answer is no, I just want to confirm that and ask if there's any plan to support it in the future. I've noticed while running copy data activities that 90% of the runtime is the activity being queued and was thinking that using a self-hosted integration runtime could decrease the time in queue.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,481 questions
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 35,786 Reputation points Microsoft Employee
    2023-04-28T05:44:21.2933333+00:00

    Hi John Neubecker,

    Thank you for posting query in Microsoft Q&A Platform.

    Yes, you can use Self hosted IR with Azure Functions. While creating linked service for Azure Functions under Azure Function activity, there is a field to select IR, select your selfhosted IR there.

    User's image

    Hope this helps. Please let me know how it goes or if any further queries.


    Please consider hitting Accept Answer button. Accepted answers help community as well.

    0 comments No comments

0 additional answers

Sort by: Most helpful