'AWS' Athena 'DBI' Wrapper

'RJDBC' based 'DBI' driver to Amazon Athena, which is an interactive query service to analyze data in Amazon 'S3' using standard 'SQL'.


This is an R client to interact with the AWS Athena service, including wrapper functions around the Athena JDBC package to query data stored in S3.

Installation

CRAN version

install.packages("AWR.Athena")

Or you can easily install the most recent development version of the R package as well:

devtools::install_github('nfultz/AWR.Athena')

What is it good for?

This provides a simplified DBI driver for Athena:

require(DBI)
con <- dbConnect(AWR.Athena::Athena(), region='us-west-2', S3OutputLocation='s3://nfultz-athena-staging', Schema='default')
dbListTables(con)
dbGetQuery(con, "Select count(*) from sampledb.elb_logs")

Installing and loading the JDBC driver package is handled automatically.

What if I want to do other cool things with Athena and R?

Most database functionality is actually provided by RJDBC, but if you have Athena-specific features in mind, please open a ticket on the feature request, or even better, submit a pull request :)

It doesn't work here!

To be able to use this package, you need to have an AWS account. If you do not have one already, you can register for free at Amazon although usage is currently $5 / terabyte scanned.

Once you have an AWS account, make sure your default AWS Credentials are available via the DefaultAWSCredentialsProviderChain . In short, you either provide a default credential profiles file at ~/.aws/credentials, use the AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY environment variables; or if using AWR.Athena on AWS, you can also rely on the EC2 instance profile credentials or ECS Task Role as well.

News

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("AWR.Athena")

2.0.7-0 by Neal Fultz, 3 months ago


Browse source code at https://github.com/cran/AWR.Athena


Authors: Neal Fultz <[email protected]> , Gergely Daróczi <[email protected]>


Documentation:   PDF Manual  


AGPL-3 license


Imports methods, RJDBC, rJava


See at CRAN