All functions

show(<AthenaConnection>) dbDisconnect(<AthenaConnection>) dbIsValid(<AthenaConnection>) dbSendQuery(<AthenaConnection>,<character>) dbSendStatement(<AthenaConnection>,<character>) dbExecute(<AthenaConnection>,<character>) dbDataType(<AthenaConnection>,<ANY>) dbDataType(<AthenaConnection>,<data.frame>) dbQuoteString(<AthenaConnection>,<character>) dbQuoteString(<AthenaConnection>,<POSIXct>) dbQuoteString(<AthenaConnection>,<Date>) dbQuoteIdentifier(<AthenaConnection>,<SQL>) dbGetTables() dbListFields(<AthenaConnection>,<character>) dbExistsTable(<AthenaConnection>,<character>) dbExistsTable(<AthenaConnection>,<Id>) dbRemoveTable(<AthenaConnection>,<character>) dbRemoveTable(<AthenaConnection>,<Id>) dbGetQuery(<AthenaConnection>,<character>) dbGetInfo(<AthenaConnection>) dbGetPartition() dbShow() dbBegin(<AthenaConnection>) dbCommit(<AthenaConnection>) dbRollback(<AthenaConnection>)

Athena Connection Methods

dbClearResult(<AthenaResult>) dbFetch(<AthenaResult>) dbHasCompleted(<AthenaResult>) dbIsValid(<AthenaResult>) dbGetInfo(<AthenaResult>) dbColumnInfo(<AthenaResult>) dbStatistics() dbGetStatement(<AthenaResult>)

Athena Result Methods

dbWriteTable(<AthenaConnection>,<character>,<data.frame>) dbWriteTable(<AthenaConnection>,<Id>,<data.frame>) dbWriteTable(<AthenaConnection>,<SQL>,<data.frame>)

Convenience functions for reading/writing DBMS tables

assume_role()

Assume AWS ARN Role

athena()

Athena Driver

sql_query_explain.AthenaConnection() sql_query_fields.AthenaConnection() sql_escape_date.AthenaConnection() sql_escape_datetime.AthenaConnection()

Athena S3 implementation of dbplyr backend functions

dbConnect(<AthenaDriver>)

Connect to Athena using R's sdk paws

dbConvertTable()

dbConvertTable aws s3 backend file types.

dbListTables(<AthenaConnection>)

List Athena Tables

db_compute.AthenaConnection() sql_query_save.AthenaConnection()

S3 implementation of db_compute for Athena

db_connection_describe.AthenaConnection()

S3 implementation of db_connection_describe for Athena (api version 2).

db_copy_to.AthenaConnection()

S3 implementation of db_copy_to for Athena

db_desc.AthenaConnection()

S3 implementation of db_desc for Athena (api version 1).

dbplyr_edition.AthenaConnection()

Declare which version of dbplyr API is being called.

noctua noctua-package

noctua: a DBI interface into Athena using paws SDK

noctua_options()

A method to configure noctua backend options.

get_session_token()

Get Session Tokens for PAWS Connection

sqlCreateTable(<AthenaConnection>)

Creates query to create a simple Athena table

sqlData(<AthenaConnection>)

Converts data frame into suitable format to be uploaded to Athena

sql_translation.AthenaConnection() sql_translate_env.AthenaConnection()

AWS Athena backend dbplyr version 1 and 2

create_work_group() tag_options() delete_work_group() list_work_groups() get_work_group() update_work_group()

Athena Work Groups