Synapse Event Based Trigger error : Trigger Activation error

Question

Getting an Error while creating trigger to invoke a stored procedure in Synapse Analytics as below.

Trigger Activation Error :
Failed to subscribe to storage events for event trigger: Event Based.

Answer 1

Hello @Hari Kumar N ,

Thanks for the ask and also using the Microsoft Q&A.

I think you have an issue with the Event Grid . Not sure if you gone through this .
https://learn.microsoft.com/en-us/azure/data-factory/how-to-create-event-trigger . Request you to look into the notes section .

Note
The integration described in this article depends on Azure Event Grid. Make sure that your subscription
is registered with the Event Grid resource provider. For more info, see Resource providers and types.
You must be able to do the Microsoft.EventGrid/eventSubscriptions/ action.
This action is part of the EventGrid EventSubscription Contributor built-in role.*

Thanks Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members