I have prepared a R Markdown document that retrieves data from Snowflake using odbc
. When I attempt to publish it on RStudio Connect with source code (so that I will be able to schedule a daily report), I get (in the Markers
tab) "Paths should be to files within the project directory." (I can publish it there as a finished document.)
Using typical debugging tactics, I can see
/usr/lib/snowflake/odbc/lib/libSnowflake.so
resides where my code looks for it. But do I need to do something differently to use that driver?
DBI::dbConnect(
drv = odbc::odbc(),
driver = "/usr/lib/snowflake/odbc/lib/libSnowflake.so",
...