I want to be able to document ETL process for OMOP database using R Notebooks. DatabaseConnector is built on top of RJDBC. I would like to add a function to DatabaseConnector to return a reference to the JDBCConnection object. Then I could use that reference in SQL code chunks in R Notebooks. Currently I am making a separate connection using RJDBC, it would be more convenient if Database connector which has already established a JDBC connection, that I use in R code chunks could provide this reference so I don’t have to make two separate connections in order to accommodate R Notebooks.
Happy to do it myself if I can get a little guidance, but again, I would need help in getting code change approved and tests approved in order to have this added to the main branch. Do not want to be forking off my own branch for this function.