I've got a trial of RStudio Connect running on an EC2 in a VPC which also has a Redshift DB in it. I have developed a trivial markdown which uses the odbc and DBI packages to connect to the database similar to this documentation.
My issue is that I can't seem to make the connection work on the RStudio connect side. To my knowledge RStudio connect takes care of isolating all your code. Does this invalidate the approach of installing odbc drivers, and should you use JDBC drivers local to the project? Is there a permission that I need to enable on the RStudio side?
I don't have an MWE due to issues of security and portablity, but was wondering if there is some documentation specific to Connect that I've missed in this instance, or if there is a different approach I should be using?