All functions

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

Convenience functions for reading/writing DBMS tables

dbSendQuery(<AthenaConnection>,<character>) dbSendStatement(<AthenaConnection>,<character>) dbExecute(<AthenaConnection>,<character>)

Execute a query on Athena

assume_role()

Assume AWS ARN Role

athena()

Athena Driver

db_explain.AthenaConnection() db_query_fields.AthenaConnection()

Athena S3 implementation of dbplyr backend functions (api version 1).

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

Athena S3 implementation of dbplyr backend functions (api version 2).

dbClearResult(<AthenaResult>)

Clear Results

dbColumnInfo(<AthenaResult>)

Information about result types

dbConnect(<AthenaDriver>)

Connect to Athena using R's sdk paws

dbConvertTable()

Simple wrapper to convert Athena backend file types

dbDataType(<AthenaDriver>,<ANY>) dbDataType(<AthenaDriver>,<list>) dbDataType(<AthenaConnection>,<ANY>) dbDataType(<AthenaConnection>,<data.frame>)

Determine SQL data type of object

dbDisconnect(<AthenaConnection>)

Disconnect (close) an Athena connection

dbExistsTable(<AthenaConnection>,<character>) dbExistsTable(<AthenaConnection>,<Id>)

Does Athena table exist?

dbFetch(<AthenaResult>)

Fetch records from previously executed query

dbGetInfo(<AthenaConnection>) dbGetInfo(<AthenaResult>)

Get DBMS metadata

dbGetPartition()

Athena table partitions

dbGetQuery(<AthenaConnection>,<character>)

Send query, retrieve results and then clear result set

dbGetStatement(<AthenaResult>)

Get the statement associated with a result set

dbGetTables()

List Athena Schema, Tables and Table Types

dbHasCompleted(<AthenaResult>)

Completion status

dbIsValid(<AthenaConnection>) dbIsValid(<AthenaResult>)

Is this DBMS object still valid?

dbListFields(<AthenaConnection>,<character>)

List Field names of Athena table

dbListTables(<AthenaConnection>)

List Athena Tables

dbQuoteString(<AthenaConnection>,<character>) dbQuoteString(<AthenaConnection>,<POSIXct>) dbQuoteString(<AthenaConnection>,<Date>) dbQuoteIdentifier(<AthenaConnection>,<SQL>)

Quote Identifiers

dbRemoveTable(<AthenaConnection>,<character>) dbRemoveTable(<AthenaConnection>,<Id>)

Remove table from Athena

dbShow()

Show Athena table's DDL

dbStatistics()

Show AWS Athena Statistics

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() sql_escape_string.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