I currently have a set up where I have an RMarkdown running and writing files to a persistant storage location that both Connect and RStudio Pro can see (location is a separate server that is mounted to the two connect and pro servers).
The issue I am running into is RStudio Pro cannot see the file that was written and I think it has to do with the permissions the run-as user 'rstudio-connect' uses when creating the files.
Below is the error:
file not found: /RStudioPro/Aftermarket_AUS/morrisk/MRODash/DataPrep//DataPrep_ShipmentsYear.csv
Reasons I think it is a permission issue:
The same path is used in shiny applications where either the RStudio Pro or I (on windows side) create the files and both RStudio Pro and RStudio Connect can read them so I know it's not a path issue.
Had an earlier issue when running the rmarkdown report in Server Pro, it read the files and published the files but when I published it to Connect, it was throwing a permissions error. I solved this by deleting the original files that were written when in Server Pro and that fixed it. Seemed Connect run-as could not overwrite files written by Pro run-as.