How to trigger Synapse Analytics Workspace pipeline using C# or any other language?

0
votes

Is there any way through which we can trigger the Azure Synapse Analytics Pipeline (built-in Azure Data Factory) using C# or any language?

Using the following URL and code I am able to trigger general (not part of Synapse) Azure Data Factory successfully. But when I call the same method I am not sure what will go under name of Data Factory (property: dataFactoryName)? I tried giving workspace name but it does not work.

Built-in ADF can be triggered using Blob trigger but thing is that I have many parameters and those cannot be passed through files stored in Blob.

URL: https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers

Code: client.Pipelines.CreateRunWithHttpMessagesAsync(resourceGroup, dataFactoryName, pipelineName, parameters)

2
azureazure-data-factoryazure-synapseazure-data-factory-pipeline

2 Answers

0
votes

According to the ADF team, there is a different SDK for Synapse Analytics. I'm in the same position, but haven't had a chance to generate a code sample yet.

It looks like you'll need the PipelineClient class to create a run, and the PipelineRunClient class to monitor it.

If you get this working, please post the sample code for future searchers.