Hello, I have shiny apps running on RStudio Connect that are published with data in feather files.
I have an RMarkdown that I run separately to connect to a database to create the feather files that are published with the App. I would now like to move to daily automated updates so I'd like to schedule the RMarkdown file to run in the early AM hours to create the feather files, then have the app read those feather files. So....
- I'm struggling to find an example of exactly how to go about this, not sure if there's a good reference for a setup like this somewhere?
- From the reading I've done, I'm still not sure where I should write the files to on the server so I would appreciate thoughts on that.
- Also it sounds like i would need to restart the shiny app post data update to pick up those changes, I'm not sure if there's a way to schedule your shiny app to restart via Connect somehow?
Appreciate any insights on this. Thanks!