I'm trying to connect to AWS Athena, which works fine ~ 2/10 times, as the other 8 RStudio crashes. I'm doing through ODBC package.
The code:
con <- DBI::dbConnect(
odbc::odbc(),
Driver = "/Library/simba/athenaodbc/lib/libathenaodbc_sbu.dylib",
S3OutputLocation = "s3://...",
AwsRegion = "eu-west-1",
AuthenticationType = "IAM Profile",
AwsProfile = "profile",
Schema = "prod"
)
Any idea why Rstudio crashes randomly?