I'd like to use and recommend the Rstudio IDE for SQL file manipulation and previewing results. One thing that stops me from using it more often is that the preview isn't immediately accessible without changing the conn=
definition.
Default:
-- !preview conn=DBI::dbConnect(RSQLite::SQLite())
Is there a way to change this for my own profile?
Is there a way to change it for all users of my Rstudio Server Pro?