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

Question

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

Answer 1

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.