I connected RStudio to Amazon Athena, and the database connection was successful.
con <- dbConnect(noctua::athena(),
aws_access_key_id = "***",
aws_secret_access_key = "***",
s3_staging_dir = "s3://bucket-folder/",
region_name = '***')
However, when I attempt to use dbGetQuery(), I receive the following error message despite having DBI installed.
This is the code that I am running.
querytest <- dbGetQuery(con, "SELECT * FROM database.table")
# Error in (function (classes, fdef, mtable) : unable to find an inherited method
# for function ‘dbSendQuery’ for signature ‘"AthenaConnection", "character"’.
What am I doing wrong in this situation?