This blog is a how-to guide for leveraging R Markdown output files to create a basic ETL process that feeds other data products also hosted on RStudio Connect.
Its odd; I can navigate to var/lib/rstudio-connect/reports...appropriate version/bundle/etc. and see the .feather files. I can also put the https address in my browser and it prompts me to download the file.
Yeah that's really curious - and you double checked that the URLs you're using there are correct? You pulled it straight from the "Open Solo" location?
Content deployed to http://connect.mycompany.com/content/42/ will have its output files available under that URL path. An output file named daily-summary.csv will be available at the URL http://connect.mycompany.com/content/42/daily-summary.csv .
The URL for your content is the same as its “Open Solo” location and is available in the RStudio Connect dashboard.
I did. And the fact that putting that exact address into my browser prompts me to download the file, leads me to believe it is correct. I feel like it is perhaps a configuration issue. Should my RConnect config file have a [Data Dir] entry? Mine does not, but perhaps it goes to default if it is not specified?
Also, I should mention: I was able to create a folder on the RConnect server that my team can all write to with a markdown document, and then read from in a Shiny app. So the concept itself is working. I just don't like that method, as we will surely run into issues when people save files with the same names. I also don't want to manage creating a folder for every Shiny app to prevent overwriting. It seems the HTTP call is the issue, but only from RConnect.
Yep - absolutely. This paradigm feels cleaner to me than the persistent storage solution for all the reasons you've noted. But only if we can get it working!
My colleague @cole mentioned that we have seen networking issues and situations where Connect has been configured in such a way that the server cannot address itself by its DNS name. If you want to open a support ticket on this issue, we would be happy to work through it with you. I think it might be worth getting some logs and learning about your config and proxy setup. If you do open a ticket, please reference this community post so that our support team can pull me in on it.
Via the support ticket created, we found that this was actually due to an issue with the feather package. There's an open bug report for this here: https://github.com/wesm/feather/issues/231
We hope this will be resolved soon; in the meantime, should anyone else run into this issue, we recommend trying writing and reading .csv files instead to see if this resolves the issue.