README.md
In nfultz/AWR.Athena: 'AWS' Athena 'DBI' Wrapper
AWR.Athena
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
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.
nfultz/AWR.Athena documentation built on Sept. 20, 2019, 9:53 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
AWR.Athena
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
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.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.