How to run triggers in Azure Synapse workspace in Git enabled development

Raj D 491 Reputation points
2023-01-17T17:46:30.9166667+00:00

Greetings!!!

I have my Azure Synapse workspace configured for Git enabled development as described in the post (https://www.sqlservercentral.com/articles/how-to-integrate-azure-devops-with-azure-synapse-studio), (https://prodata.ie/2021/01/31/ci-cd-for-azure-synapse-analytics-part-1/). But, the scheduled triggers don't run on their usual schedule for instance in the development Azure Synapse workspace I've DEVELOPER branch and in the test Azure Synapse workspace I've TESTER branch. But, the triggers don't get fired in test Azure Synapse workspace but run in development Azure Synapse workspace against the Snapse Live Mode.

Could you please point to me on how to make the triggers run as expected as I deploy the code into Azure Synapse workspace up the stack.

Thank you

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.
2,618 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 28,101 Reputation points Microsoft Employee
    2023-01-18T09:35:43.0166667+00:00

    Hi Raj D,

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

    Triggers will only run on LIVE mode. That means, only published pipelines (to Live mode) can be executed from triggers. For this trigger also should be published.

    for some reason you want to execute pipelines with unpublished changed then we should go with debug execution only.

    Hope this helps. If not, kindly share little more details on ask with simple example if possible, so that I can help better.


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