Athena {AWR.Athena}R Documentation

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)

[Package AWR.Athena version 2.0.7-0 Index]