Athena: Athena DBI wrapper

In nfultz/AWR.Athena: 'AWS' Athena 'DBI' Wrapper

Description

Athena DBI wrapper

Authentication credentials are read from the DefaultAWSCredentialsProviderChain, which includes the .aws folder and environment variables.

Usage

Athena()

## S4 method for signature 'AthenaDriver'
dbConnect(drv, region, S3OutputLocation, Schema,
  ...)

Arguments

drv	An object created by Athena()
region	the AWS region
S3OutputLocation	S3 bucket where results will be saved to
Schema	Athena schema to use
...	Other options

See Also

Athena Manual for more connections options.

Examples

## Not run: 
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")

## End(Not run)

nfultz/AWR.Athena documentation built on Sept. 20, 2019, 9:53 p.m.