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.
Please find the code below.
Thank you in advance!
con <- DBI::dbConnect(drv = odbc::odbc(), Host = "18.104.22.168", Port = 9042, AuthMech = 1, UID = rstudioapi::askForPassword("Database user"), PWD = rstudioapi::askForPassword("Database password") )