RAthena provides a seamless DBI interface into Athena using the python package Boto3.
The goal of the RAthena package is to provide a DBI-compliant interface to Amazon’s Athena
using Boto3 software development kit (SDK). This allows for an efficient, easy setup connection to Athena using the Boto3 SDK as a driver.
Before starting with RAthena, Python is require to be installed on the machine you are intending to run RAthena.
As RAthena is using Boto3 as it's backend, AWS Command Line Interface (AWS CLI) can be used
to remove user credentials when interacting with Athena.
This allows AWS profile names to be set up so that RAthena can connect to different accounts from the same machine, without needing hard code any credentials.
Useful links: