We’re working with a community member that is having issues connecting to Redshift using DatabaseConnector. The only difference that we can identify is that they are using IAM roles as part of their authentication. The following connection string works from their SQL Workbench but fails with the following error when using DatabaseConnector.
> connectionDetails <- DatabaseConnector::createConnectionDetails(dbms= “redshift”, connectionString=“jdbc:redshift:iam://servername-replaced-to-protect-the-innocent”)
> connection <- DatabaseConnector::connect(connectionDetails) Connecting using Redshift driver Error in rJava::.jcall(jdbcDriver, “Ljava/sql/Connection;”, “connect”, : java.lang.NoClassDefFoundError: com/amazonaws/auth/profile/ProfilesConfigFile
Any help would be appreciated.