Run SQL
run_sql(database, query)
| database | The name of the database. |
|---|---|
| query | The query to run. |
If you need to use a user-password setup to access the databases, then you
will need to set the R options in your .Rprofile file: pbs.uid, pbs.pwd,
pbs.ip, pbs.sqldriver. E.g. options(pbs.uid="MyUserName") The default
SQL driver will be "SQL Server" if not specified in the options. This will
probably work for most people. You might try using
usethis::edit_r_profile() if you need help finding your R profile file.