Connect to 'AWS Athena' using 'Boto3' ('DBI' Interface)
Overview
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.
Bug Fix:
- Unload option returns null results when s3_staging_dir is a bucket only (#214) thanks to @dfsnow for implementing solution
- Add support for describe (noctua # 218) thanks to @tyner for raising issue
- Add support for
EXPLAIN (TYPE validate)(noctua # 225) thanks to @tyner for raising issue - Fix link for document
dbSendQuery(noctua # 223) thanks to @tyner for raising issue - Return athena option environment from
RAthena_options(noctua # 226) thanks to @tyner for raising issue - Support
SelectedEngineVersioninupdate_work_group(noctua # 224) thanks to @tyner for raising issue
From NEWS.md in the release
Install
Health
- OK13 OK2026-09-08
- ERROR12 OK, 1 ERROR2026-09-07
- OK13 OK2026-08-05
- NOTE12 OK, 1 NOTE2026-08-01
- OK14 OK2026-03-10
Documentation
- Help pages
- 26 (3 internal)includes a package overview page
- Examples that run
- 10%1 run in a plain check · 9 never run
- Exported functions with examples
- 38%
- Documented parameters
- 100%
- Return-value docs
- 94%
- Help pages citing references
- 0%
- AWS Athena Query Caching HTML
- AWS Athena Unload HTML
- AWS S3 Backend HTML
- Changing Backend File Parser HTML
- Convert and Save Cost HTML
- Getting Started HTML
- How to Retry? HTML
Downloads
Repository
- PRs merged (all time)
- 99%
- Median days to close, 50 most recently updated closed issues
- 2
- Median days to close, 50 most recently updated closed PRs
- 0
Stars over time
Forks over time
Releases over time
Issues over time
PRs over time
7 development-tooling and community-health practices detected across 6 families in the upstream repository
Checks run against github.com/dyfanjones/rathena on 2026-10-22.
The R CMD check workflow runs on Linux
GitHub Pages site last deployed 2025-09-29
Show all practicesHide 2 practices
Dependencies
Installing RAthena adds 13 packages (9 with compiled code, 12 MB of source tarballs). Heaviest: data.table 5.7 MB, Rcpp 1.8 MB, reticulate 1.6 MB.
Code & Tests
People & History
Pick two releases to compare their code metrics.
- RR 4.6.0 released · 2026-04-24
- 2.6.3Latest2025-09-29 · current release · diff ↗ ·
removed 1 export
sql_escape_string.AthenaConnectionadded 5 exports
AthenaListObjects, AthenaPreviewObject, db_compute.AthenaConnection, db_copy_to.AthenaConnection, sql_query_save.AthenaConnection - RR 4.5.0 released · 2025-04-11
- RR 4.4.0 released · 2024-04-24
- RR 4.3.0 released · 2023-04-21
- 2.6.12022-12-20 · diff ↗
- 2.6.02022-05-20 · diff ↗
- RR 4.2.0 released · 2022-04-22
- 2.5.12022-01-26 · diff ↗
- 2.5.02022-01-17 · diff ↗
- 2.4.02021-11-26 · diff ↗ ·
added 4 exports
dbplyr_edition.AthenaConnection, sql_escape_date.AthenaConnection, sql_escape_datetime.AthenaConnection, sql_translation.AthenaConnection - 2.3.02021-10-26 · diff ↗
- 2.2.02021-09-23 · diff ↗
- 2.1.02021-07-27 · diff ↗
- RR 4.1.0 released · 2021-05-18
- 2.0.12021-02-25 · diff ↗
Show 19 earlier eventsHide 19 earlier events
- 2.0.02021-02-22 · diff ↗
- 1.12.02021-01-20 · diff ↗
- 1.11.12020-11-17 · diff ↗
- 1.11.02020-11-11 · diff ↗
- 1.10.12020-09-27 · diff ↗
- 1.10.02020-08-06 · diff ↗
- 1.9.12020-07-02 · diff ↗
- 1.9.0
- RR 4.0.0 released · 2020-04-24
- 1.8.02020-03-17 · diff ↗
- 1.7.1
- 1.7.0
- 1.6.02019-12-19 · diff ↗
- 1.5.0
- 1.4.12019-11-28 · diff ↗
- 1.4.02019-11-14 · diff ↗
- 1.3.02019-10-23 · diff ↗
- 1.2.02019-10-14
- RR 3.6.0 released · 2019-04-26
Package metadata
- First published
- 2019-10-14
- Total releases
- 27 / 7 yrs
- License
- MIT + file LICENSE OSI
- Minimum R
- ≥ 3.2.0
- Download size
- 342 KB
Cite
Cite this package
Run in R for the authors' preferred citation:
citation("RAthena")This package has no citation file, so citation() returns this entry built from DESCRIPTION.
Cite the R Observatory
For a number measured here: a download total, a coverage figure, an archival date.
From data release v2026-10-23, which the citation names so these numbers can be found later. More on citing and the projects behind them.