Any alternative for DB Trigger in synapse

Question

Hi,
Are there any options available in Synapse to trigger some activities based on the inserts happening in a table. Just like table triggers in Oracle. Or are there any alternative way in Synapse.

Thank You,
Vimal PS

Answer 1

Hello @Vimal Sivaraman ,

Thanks for the question and using MS Q&A platform.

Unfortunately, this is not possible using Azure Synapse or Azure Data Factory.

For more details, refer to Triggers in Azure Data Factory or Azure Synapse Analytics.

I would suggest you to vote up an idea submitted by another Azure customer.

Feedback Portal - Azure Data Factory

All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

Alternative method: You can create logic apps that run when triggered by events in your SQL database.

For more details, refer to the below links:

• Automate workflows for a SQL database by using Azure Logic Apps
• Execute Data Factory pipeline based on event in table

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

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

• Please don't forget to click on or upvote 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