In R, Error For No Boto3 To Connect Athena Even Though Boto3 Installed

I am trying to connect to Athena from R. After setup 'RAthena' and connection, I got this error: Error: Boto3 is not detected please install boto3 using either: `pip install boto3`

Solution 1:

really sorry to hear you are having issue with the RAthena package. Can you let me know what version of the package you are running.

Have you tried setting which python you are using through reticulate? For example:

library(DBI)

# specifying python conda environment
reticulate::use_condaenv("RAthena")

# Or specifying python virtual enviroment
reticulate::use_virtualenv("RAthena")

con <- dbConnect(RAthena::athena())

Can you also check if numpy is installed, I remember reticulate can bind to python environments better if numpy is apart of it.

Alternatively you can use noctua. noctua works exactly the same as RAthena but instead of using python's boto3 it uses R's paws package.

If you are still struggling I can raise this as an issue on Github. I thought I had resolved this issue by adding numpy to the installation function install_boto, however I am happy to re-open this issue.