Connect to 'AWS Athena' using 'Boto3' ('DBI' Interface)
![[R logo]](../../../doc/html/Rlogo.svg)
![[Up]](../../../doc/html/left.jpg)
![[Top]](../../../doc/html/up.jpg)
Documentation for package ‘RAthena’ version 2.6.1
Help Pages
| RAthena-package | RAthena: a DBI interface into Athena using Boto3 SDK |
| assume_role | Assume AWS ARN Role |
| athena | Athena Driver |
| AthenaWriteTables | Convenience functions for reading/writing DBMS tables |
| backend_dbplyr_v1 | Athena S3 implementation of dbplyr backend functions (api version 1). |
| backend_dbplyr_v2 | Athena S3 implementation of dbplyr backend functions (api version 2). |
| create_work_group | Athena Work Groups |
| dbClearResult | Clear Results |
| dbClearResult-method | Clear Results |
| dbColumnInfo | Information about result types |
| dbColumnInfo-method | Information about result types |
| dbConnect | Connect to Athena using python's sdk boto3 |
| dbConnect-method | Connect to Athena using python's sdk boto3 |
| dbConvertTable | Simple wrapper to convert Athena backend file types |
| dbConvertTable-method | Simple wrapper to convert Athena backend file types |
| dbDataType | Determine SQL data type of object |
| dbDataType-method | Determine SQL data type of object |
| dbDisconnect | Disconnect (close) an Athena connection |
| dbDisconnect-method | Disconnect (close) an Athena connection |
| dbExecute-method | Execute a query on Athena |
| dbExistsTable | Does Athena table exist? |
| dbExistsTable-method | Does Athena table exist? |
| dbFetch | Fetch records from previously executed query |
| dbFetch-method | Fetch records from previously executed query |
| dbGetInfo | Get DBMS metadata |
| dbGetInfo-method | Get DBMS metadata |
| dbGetPartition | Athena table partitions |
| dbGetPartition-method | Athena table partitions |
| dbGetQuery | Send query, retrieve results and then clear result set |
| dbGetQuery-method | Send query, retrieve results and then clear result set |
| dbGetStatement | Get the statement associated with a result set |
| dbGetStatement-method | Get the statement associated with a result set |
| dbGetTables | List Athena Schema, Tables and Table Types |
| dbGetTables-method | List Athena Schema, Tables and Table Types |
| dbHasCompleted | Completion status |
| dbHasCompleted-method | Completion status |
| dbIsValid | Is this DBMS object still valid? |
| dbIsValid-method | Is this DBMS object still valid? |
| dbListFields | List Field names of Athena table |
| dbListFields-method | List Field names of Athena table |
| dbListTables | List Athena Tables |
| dbListTables-method | List Athena Tables |
| dbplyr_edition | Declare which version of dbplyr API is being called. |
| dbplyr_edition.AthenaConnection | Declare which version of dbplyr API is being called. |
| dbQuote | Quote Identifiers |
| dbQuoteIdentifier-method | Quote Identifiers |
| dbQuoteString-method | Quote Identifiers |
| dbRemoveTable | Remove table from Athena |
| dbRemoveTable-method | Remove table from Athena |
| dbSendQuery-method | Execute a query on Athena |
| dbSendStatement-method | Execute a query on Athena |
| dbShow | Show Athena table's DDL |
| dbShow-method | Show Athena table's DDL |
| dbStatistics | Show AWS Athena Statistics |
| dbStatistics-method | Show AWS Athena Statistics |
| dbWriteTable-method | Convenience functions for reading/writing DBMS tables |
| db_compute | S3 implementation of 'db_compute' for Athena |
| db_compute.AthenaConnection | S3 implementation of 'db_compute' for Athena |
| db_connection_describe | S3 implementation of 'db_connection_describe' for Athena (api version 2). |
| db_connection_describe.AthenaConnection | S3 implementation of 'db_connection_describe' for Athena (api version 2). |
| db_copy_to | S3 implementation of 'db_copy_to' for Athena |
| db_copy_to.AthenaConnection | S3 implementation of 'db_copy_to' for Athena |
| db_desc | S3 implementation of 'db_desc' for Athena (api version 1). |
| db_desc.AthenaConnection | S3 implementation of 'db_desc' for Athena (api version 1). |
| db_explain.AthenaConnection | Athena S3 implementation of dbplyr backend functions (api version 1). |
| db_query_fields.AthenaConnection | Athena S3 implementation of dbplyr backend functions (api version 1). |
| delete_work_group | Athena Work Groups |
| get_session_token | Get Session Tokens for Boto3 Connection |
| get_work_group | Athena Work Groups |
| install_boto | Install Amazon SDK boto3 for Athena connection |
| list_work_groups | Athena Work Groups |
| Query | Execute a query on Athena |
| RAthena | RAthena: a DBI interface into Athena using Boto3 SDK |
| RAthena_options | A method to configure RAthena backend options. |
| session_token | Get Session Tokens for Boto3 Connection |
| sqlCreateTable | Creates query to create a simple Athena table |
| sqlCreateTable-method | Creates query to create a simple Athena table |
| sqlData | Converts data frame into suitable format to be uploaded to Athena |
| sqlData-method | Converts data frame into suitable format to be uploaded to Athena |
| sql_escape_date.AthenaConnection | Athena S3 implementation of dbplyr backend functions (api version 2). |
| sql_escape_datetime.AthenaConnection | Athena S3 implementation of dbplyr backend functions (api version 2). |
| sql_escape_string.AthenaConnection | AWS Athena backend dbplyr version 1 and 2 |
| sql_query_explain.AthenaConnection | Athena S3 implementation of dbplyr backend functions (api version 2). |
| sql_query_fields.AthenaConnection | Athena S3 implementation of dbplyr backend functions (api version 2). |
| sql_translate_env | AWS Athena backend dbplyr version 1 and 2 |
| sql_translate_env.AthenaConnection | AWS Athena backend dbplyr version 1 and 2 |
| sql_translation.AthenaConnection | AWS Athena backend dbplyr version 1 and 2 |
| tag_options | Athena Work Groups |
| update_work_group | Athena Work Groups |
| work_group | Athena Work Groups |