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

John Neubecker 86 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.
11,639 questions
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
    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 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.