Blob Storage will not trigger Azure synapse pipeline

Question

Hi,

Please help!
We're trying to set up a basic workflow whereby an App Function creates a storage blob, and this event triggers a pipeline in Azure Synapse.

We're unable to trigger an Azure synapse pipeline based on a blob creation event after having read through every blog and tutorial.

The pipeline works when the file is uploaded manually, but NOT when the file is created via an App Funciton. Maybe an access/IAM issue but we're unable to find it.

Things we've tried:

• Activating Event Grid and Data Factory Resource groups
• Giving Synapse access to blob storage
• Assigning and re-assigning the trigger the trigger to the pipeline in synapse

It might be obvious but we're out of ideas.
This is the pipeline: https://web.azuresynapse.net/en/authoring/orchestrate/pipeline/PROD%20-%20CMSurveysStorageToSQL?workspace=%2Fsubscriptions%2Fb2c3c155-b9b7-4f1d-ba9c-68196f09f2e8%2FresourceGroups%2FGrossoDataAnalytics%2Fproviders%2FMicrosoft.Synapse%2Fworkspaces%2Fgrosso-data-analytics-core1

This is the Cloud Function: https://portal.azure.com/#view/WebsitesExtension/FunctionMenuBlade/~/functionOverview/resourceId/%2Fsubscriptions%2Fb2c3c155-b9b7-4f1d-ba9c-68196f09f2e8%2FresourceGroups%2FGrossoDataAnalytics%2Fproviders%2FMicrosoft.Web%2Fsites%2Fgrosso-etl%2Ffunctions%2FCoverManagerSurveysUpdate

Answer 1

Hi @PRADEEPCHEEKATLA , no we have not. As we mentioned, we changed our workflow and worked around this issue.
Also, we don't have a support plan on our current tier.
Happy to close this ticket when you find suitable.

Thanks for your help

Answer 2

Hey,
Can you check the content type of the file:

usually when that is blank, event trigger is not initiated