{"repo":"DyfanJones/noctua","free":true,"listed":false,"github":"https://github.com/DyfanJones/noctua","clone":"git clone https://github.com/DyfanJones/noctua.git","description":"Connect R to Athena using paws SDK (DBI Interface)","language":"R","stars":45,"topics":["r","athena","aws","database"],"license":null,"category":"databases-storage","readme_excerpt":"noctua The goal of the noctua package is to provide a DBI-compliant interface to Amazon’s Athena ( ) using paws SDK. This allows for an efficient, easy setup connection to Athena using the paws SDK as a driver. NOTE: Before using noctua you must have an aws account or have access to aws account with permissions allowing you to use Athena. Why is the package called noctua Athena/Minerva is the Greek/Roman god of wisdom, handicraft, and warfare. One of the main symbols for Athena is the Owl. Noctua is the latin word for Owl. Installation: To install noctua 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 noctua 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 . Using default profile name: Connecting to Athena using profile name other ","default_branch":null,"files":null,"tree":[],"storefront":"/r/DyfanJones","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/DyfanJones/noctua/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."}