How to run Azure synapse analytics pipeline from logic app?

Nikhil 1 Reputation point
2021-10-01T20:45:45.707+00:00

I am unable to figure a way to run Azure synapse analytics pipeline using logic app. Can someone tell me how to do that?

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.
4,657 questions
{count} votes

2 answers

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 84,941 Reputation points Microsoft Employee
    2021-10-04T10:24:17.543+00:00

    Hello @Nikhil ,

    Welcome to the Microsoft Q&A platform.

    Unfortunately, there is no Azure Synapse connector available to call from logic apps.

    For more details, refer to List of all Logic Apps connectors.

    Alternative option: You can run Azure Synapse Analytics Pipelines using REST API.

    For more details, refer to How to start Synapse Pipeline from Rest API.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

  2. Hiram Fleitas 76 Reputation points Microsoft Employee
    2021-10-07T00:46:02.703+00:00

    Hi @Nikhil ,

    You can make a POST to a Webhook of an Automation Account runbook that has the Az.Synapse module. It works for me, hope it helps!

    1. Create an Azure Automation Account
    2. Add powershell module Az.Synapse from gallery (and it's required modules first, ie. Az.Accounts...etc - it will prompt you)
    3. Create a powershell runbook with the following here.
    4. Edit the runbook with the automation RunAs account values.
    5. Add the RunAs account's display name to your Synapse workspace Access Controls members.
    6. Test your runbook
    7. Create the webhook.
    8. Add the HTTP web request in the Logic App with method post, paste the URI of the webhook.
    9. Set the headers to Content-Type, application/json
    10. Set the Body to {"WORKSPACE": "abcworkspace", "PIPELINE": "abcpipeline", "RG": "abcrg"}
    11. Test your logic app.