Calling a Synapse/ADF pipeline from an Azure Function

pmscorca 1,052 Reputation points
2023-08-22T22:07:33.42+00:00

Hi,

I need to implement a Synapse Analytics/ADF pipeline that an end user has to call by a web interface created by an Azure Function.

So, is it possible to call a Synapse pipeline from an Azure Function?

Thanks

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,711 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,316 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,453 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 35,026 Reputation points MVP
    2023-08-23T03:02:23.9766667+00:00

    Hey,

    Yes, you can trigger an ADF/Synapse pipeline via Azure function by leveraging the REST API for the same.

    Synapse: https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/pipeline/create-pipeline-run?tabs=HTTP

    ADF : https://learn.microsoft.com/en-us/rest/api/datafactory/pipelines/create-run?tabs=HTTP

    You can use Managed identity by granting the Azure function necessary access on the ADF/Synapse

    0 comments No comments

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.