{"repo":"DyfanJones/RAthena","free":true,"listed":false,"github":"https://github.com/DyfanJones/RAthena","clone":"git clone https://github.com/DyfanJones/RAthena.git","description":"Connect R to Athena using Boto3 SDK (DBI Interface)","language":"R","stars":36,"topics":["r","athena","aws","boto3","database"],"license":null,"category":"databases-storage","readme_excerpt":"RAthena The goal of the RAthena package is to provide a DBI-compliant interface to Amazon’s Athena ( ) using Boto3 SDK. This allows for an efficient, easy setup connection to Athena using the Boto3 SDK as a driver. NOTE: Before using RAthena you must have an aws account or have access to aws account with permissions allowing you to use Athena. Installation: Before installing RAthena ensure that Python 3+ is installed onto your machine: . To install Boto3 either it can be installed via pip command or using RAthena installation function: RAthena Method (after RAthena has been installed this method can be used) To install RAthena you can get it from CRAN with: Or to get the development version from Github with: Connection Methods Hard Coding The most basic way to connect to AWS Athena is to hard-code your access key and secret access key. However this method is not recommended as your credentials are hard-coded. AWS Profile Name The next method is to use profile names set up by AWS CLI or created manually in the /.aws directory. To create the profile names manually please refer to: https://boto3.amazonaws.com/v1/documentation/api/latest/guide/configuration.html. Setting up AWS CLI RAthena is compatible with AWS CLI. This allows your aws credentials to be stored and not be hard coded in your connection. To install AWS CLI please refer to: , to configure AWS CLI please refer to: Once AWS CLI has been set up you will be able to connect to Athena by only putting the s3 staging dir .","default_branch":null,"files":null,"tree":[],"storefront":"/r/DyfanJones","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/DyfanJones/RAthena/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}