hi, I understand it depends if you use events out of the box, subscribe to your own queue or just look for file changes (this just counts number of files in the path including sub-folders to trigger)

If you listen to the events created by Databricks, you need all ones I mentioned, so it can create queues. I think the role that can do all of it is just "Contibutor", not "Storage Blob Data Contributor", if you go granular you need all mentioned roles.

- If "Enable file events" is disabled, "File Arrival" trigger will just poll file number periodically and won't use queue -> hopefully will work with "Storage Blob Data Contributor"

- if file events enabled, you can test in the external locations / location / test connection. Without these roles or higher admin type role for your connector it won't work.

Which is your case?