I have a notebook that outputs an Excel file. Through trial and error, and after consulting with various forums I discovered  the .xlsx file needed to be written to a temp file and then copied to the volume in Unity Catalog.

When I run the notebook by itself it works perfectly.

BUT, when I schedule the job in a workflow it fails with the following error:

PermissionError: [Errno 13] Permission denied: '/local_disk0/tmp/202407-arf743-Section1.xlsx'

The workflow is using the same cluster as when I run the notebook alone.

The workflow has the "Run as" value set to my user ID.

Any help would be appreciated