Source specific code chunks from RMarkdown

[Enuma]

Hi,

I am keeping my database connections in a separate file which I usually source at the beggining of the script (eg. source("~/R/dbConnections.R"). Would it be possible to source separate code chunks if I converted the document to RMarkdown - in order to not get my environment populated with a bunch of connections. I prefer to keep all the connections in a single file, so separate file for each connection is nogo.

Thanks!

[andresrcs]

I think using the config package is a good option to replace your current method.

https://cran.r-project.org/web/packages/config/vignettes/introduction.html

[duringju211]

You could also work with knitr::read_chunk:
16.3 Read multiple code chunks from an external script (*) | R Markdown Cookbook (bookdown.org)

Instead of source("~/R/dbConnections.R") you would call knitr::read_chunk("~/R/dbConnections.R") and then call your connections like this (if you called your chunks con-a, con-b...):

```{r, con-a}

```{r, con-b}

[Enuma]

Thanks. I am using config just for storing connection details inside my dbConnections script. I will look into it a bit more.