Package: RAthena 2.6.3
RAthena: Connect to 'AWS Athena' using 'Boto3' ('DBI' Interface)
Designed to be compatible with the R package 'DBI' (Database Interface) when connecting to Amazon Web Service ('AWS') Athena <https://aws.amazon.com/athena/>. To do this 'Python' 'Boto3' Software Development Kit ('SDK') <https://boto3.amazonaws.com/v1/documentation/api/latest/index.html> is used as a driver.
Authors:
RAthena_2.6.3.tar.gz
RAthena_2.6.3.zip(r-4.7)RAthena_2.6.3.zip(r-4.6)RAthena_2.6.3.zip(r-4.5)
RAthena_2.6.3.tgz(r-4.6-any)RAthena_2.6.3.tgz(r-4.5-any)
RAthena_2.6.3.tar.gz(r-4.7-any)RAthena_2.6.3.tar.gz(r-4.6-any)
RAthena_2.6.3.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
RAthena/json (API)
NEWS
| # Install 'RAthena' in R: |
| install.packages('RAthena', repos = c('https://dyfanjones.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/dyfanjones/rathena/issues
Pkgdown/docs site:https://dyfanjones.github.io
Last updated from:bfff31bbeb. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 190 | ||
| source / vignettes | OK | 223 | ||
| linux-release-x86_64 | OK | 210 | ||
| macos-release-arm64 | OK | 123 | ||
| macos-oldrel-arm64 | OK | 135 | ||
| windows-devel | OK | 243 | ||
| windows-release | OK | 173 | ||
| windows-oldrel | OK | 202 | ||
| wasm-release | OK | 122 |
Exports:assume_roleathenaAthenaListObjectsAthenaPreviewObjectcreate_work_groupdb_compute.AthenaConnectiondb_copy_to.AthenaConnectiondbBegindbClearResultdbColumnInfodbCommitdbConnectdbConvertTabledbDataTypedbDisconnectdbExecutedbExistsTabledbFetchdbGetInfodbGetPartitiondbGetQuerydbGetStatementdbGetTablesdbHasCompleteddbIsValiddbListFieldsdbListTablesdbplyr_edition.AthenaConnectiondbQuoteIdentifierdbQuoteStringdbRemoveTabledbRollbackdbSendQuerydbSendStatementdbShowdbStatisticsdbWriteTabledelete_work_groupget_session_tokenget_work_groupinstall_botolist_work_groupsRAthena_optionsshowsql_escape_date.AthenaConnectionsql_escape_datetime.AthenaConnectionsql_query_save.AthenaConnectionsql_translate_env.AthenaConnectionsql_translation.AthenaConnectionsqlCreateTablesqlDatatag_optionsupdate_work_group
Dependencies:data.tableDBIherejsonlitelatticeMatrixpngrappdirsRcppRcppTOMLreticulaterlangrprojrootuuidwithr
AWS Athena Query Caching
Rendered fromaws_athena_query_caching.Rmdusingknitr::rmarkdownon May 27 2026.Last update: 2020-04-21
Started: 2020-03-03
AWS Athena Unload
Rendered fromaws_athena_unload.Rmdusingknitr::rmarkdownon May 27 2026.Last update: 2022-05-19
Started: 2021-10-07
AWS S3 Backend
Rendered fromaws_s3_backend.Rmdusingknitr::rmarkdownon May 27 2026.Last update: 2025-09-29
Started: 2020-03-08
Changing Backend File Parser
Rendered fromchanging_backend_file_parser.Rmdusingknitr::rmarkdownon May 27 2026.Last update: 2022-05-18
Started: 2020-03-04
Convert and Save Cost
Rendered fromconvert_and_save_cost.Rmdusingknitr::rmarkdownon May 27 2026.Last update: 2025-09-29
Started: 2020-04-21
Getting Started
Rendered fromgetting_started.Rmdusingknitr::rmarkdownon May 27 2026.Last update: 2025-09-29
Started: 2020-03-08
How to Retry?
Rendered fromhow_to_retry.Rmdusingknitr::rmarkdownon May 27 2026.Last update: 2022-05-19
Started: 2020-04-16
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| RAthena: a DBI interface into Athena using Boto3 SDK | RAthena-package RAthena |
| Assume AWS ARN Role | assume_role |
| Athena Driver | athena |
| Athena Connection Methods | AthenaConnection AthenaConnection-class AthenaResult-class dbBegin,AthenaConnection-method dbCommit,AthenaConnection-method dbDataType,AthenaConnection,ANY-method dbDataType,AthenaConnection,data.frame-method dbDisconnect,AthenaConnection-method dbExecute,AthenaConnection,character-method dbExistsTable,AthenaConnection,character-method dbExistsTable,AthenaConnection,Id-method dbGetInfo,AthenaConnection-method dbGetPartition dbGetPartition,AthenaConnection-method dbGetQuery,AthenaConnection,character-method dbGetTables dbGetTables,AthenaConnection-method dbIsValid,AthenaConnection-method dbListFields,AthenaConnection,character-method dbQuoteIdentifier,AthenaConnection,SQL-method dbQuoteString,AthenaConnection,character-method dbQuoteString,AthenaConnection,Date-method dbQuoteString,AthenaConnection,POSIXct-method dbRemoveTable,AthenaConnection,character-method dbRemoveTable,AthenaConnection,Id-method dbRollback,AthenaConnection-method dbSendQuery,AthenaConnection,character-method dbSendStatement,AthenaConnection,character-method dbShow dbShow,AthenaConnection-method show,AthenaConnection-method |
| Athena Result Methods | AthenaResult dbClearResult,AthenaResult-method dbColumnInfo,AthenaResult-method dbFetch,AthenaResult-method dbGetInfo,AthenaResult-method dbGetStatement,AthenaResult-method dbHasCompleted,AthenaResult-method dbIsValid,AthenaResult-method dbStatistics dbStatistics,AthenaResult-method |
| Convenience functions for reading/writing DBMS tables | AthenaWriteTables dbWriteTable,AthenaConnection,character,data.frame-method dbWriteTable,AthenaConnection,Id,data.frame-method dbWriteTable,AthenaConnection,SQL,data.frame-method |
| Athena S3 implementation of dbplyr backend functions (api version 2). | backend_dbplyr sql_escape_date.AthenaConnection sql_escape_datetime.AthenaConnection sql_query_explain.AthenaConnection sql_query_fields.AthenaConnection |
| Athena S3 implementation of dbplyr backend functions (api version 1). | backend_dbplyr_v1 db_explain.AthenaConnection db_query_fields.AthenaConnection |
| S3 implementation of 'db_compute' for Athena | db_compute db_compute.AthenaConnection sql_query_save.AthenaConnection |
| S3 implementation of 'db_connection_describe' for Athena (api version 2). | db_connection_describe db_connection_describe.AthenaConnection |
| S3 implementation of 'db_copy_to' for Athena | db_copy_to db_copy_to.AthenaConnection |
| S3 implementation of 'db_desc' for Athena (api version 1). | db_desc db_desc.AthenaConnection |
| Connect to Athena using python's sdk boto3 | dbConnect dbConnect,AthenaDriver-method |
| dbConvertTable aws s3 backend file types. | dbConvertTable dbConvertTable,AthenaConnection-method |
| List Athena Tables | dbListTables dbListTables,AthenaConnection-method |
| Declare which version of dbplyr API is being called. | dbplyr_edition dbplyr_edition.AthenaConnection |
| Install Amazon SDK boto3 for Athena connection | install_boto |
| A method to configure RAthena backend options. | RAthena_options |
| Get Session Tokens for Boto3 Connection | get_session_token session_token |
| AWS Athena backend dbplyr version 1 and 2 | sql_translate_env sql_translate_env.AthenaConnection sql_translation.AthenaConnection |
| Creates query to create a simple Athena table | sqlCreateTable sqlCreateTable,AthenaConnection-method |
| Converts data frame into suitable format to be uploaded to Athena | sqlData sqlData,AthenaConnection-method |
| Athena Work Groups | create_work_group delete_work_group get_work_group list_work_groups tag_options update_work_group work_group |
