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 |