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")
)