Connecting to a ScyllaDB database with R

Hi amazing people!

I was wondering if R is capable of establishing a connection with a ScyllaDB database. I'm on a Windows 64-bit operating system and haven't been able to do so. So far, I've tried the following with no success. I've looked into the documentation from RStudio and I think I'm missing the Driver argument. However... I have no clue on what driver should I get for ScyllaDB.

Any ideas?

Please find the code below.

Thank you in advance!

con <- DBI::dbConnect(drv = odbc::odbc(),
                      Host     = "45.65.9.229", 
                      Port     = 9042,  
                      AuthMech = 1,
                      UID      = rstudioapi::askForPassword("Database user"),
                      PWD      = rstudioapi::askForPassword("Database password")
)

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.