{
"_id": "6a16a614acfb0bcc41d82455",
"Package": "RAthena",
"Type": "Package",
"Title": "Connect to 'AWS Athena' using 'Boto3' ('DBI' Interface)",
"Version": "2.6.3",
"Authors@R": "person(\"Dyfan\", \"Jones\", email=\"dyfan.r.jones@gmail.com\", \nrole= c(\"aut\", \"cre\"))",
"Description": "Designed to be compatible with the R package 'DBI'\n(Database Interface) when connecting to Amazon Web Service\n('AWS') Athena . To do this\n'Python' 'Boto3' Software Development Kit ('SDK')\n\nis used as a driver.",
"SystemRequirements": "Python and boto3 >= 1.14.0\n(https://aws.amazon.com/sdk-for-python)",
"VignetteBuilder": "knitr",
"License": "MIT + file LICENSE",
"Encoding": "UTF-8",
"RoxygenNote": "7.3.3",
"URL": "https://dyfanjones.github.io/RAthena/,\nhttps://github.com/DyfanJones/RAthena",
"BugReports": "https://github.com/DyfanJones/RAthena/issues",
"Collate": "'utils.R' 'dplyr_integration.R' 'RAthena.R' 'Driver.R'\n'Connection.R' 'DataTypes.R' 'File_Parser.R' 'Options.R'\n'fetch_utils.R' 'Result.R' 'View.R' 'athena_low_api.R'\n'column_parser.R' 'install.R' 'sql_translate_utils.R'\n'sql_translate_env.R' 'table.R' 'zzz.R'",
"Roxygen": "list(markdown = TRUE)",
"Config/pak/sysreqs": "libpng-dev python3",
"Repository": "https://dyfanjones.r-universe.dev",
"Date/Publication": "2025-09-29 17:04:38 UTC",
"RemoteUrl": "https://github.com/DyfanJones/RAthena",
"RemoteRef": "HEAD",
"RemoteSha": "bfff31bbeb1cc65f74171f7e798195029565d9fb",
"NeedsCompilation": "no",
"Packaged": {
"Date": "2026-05-27 08:01:55 UTC",
"User": "root"
},
"Author": "Dyfan Jones [aut, cre]",
"Maintainer": "Dyfan Jones ",
"MD5sum": "864b7a9a34963e31e0aaa0a3db71b96e",
"_user": "dyfanjones",
"_type": "src",
"_file": "RAthena_2.6.3.tar.gz",
"_fileid": "05208ad94cd82e2dba62ad95ebc7aa963b29fcdddc3da2a142140924f0dd6425",
"_filesize": 560936,
"_sha256": "05208ad94cd82e2dba62ad95ebc7aa963b29fcdddc3da2a142140924f0dd6425",
"_created": "2026-05-27T08:01:55.000Z",
"_published": "2026-05-27T08:06:43.988Z",
"_distro": "noble",
"_jobs": [
{
"job": 78033619644,
"time": 190,
"config": "linux-devel-x86_64",
"r": "4.7.0",
"check": "OK",
"artifact": "7235117875"
},
{
"job": 78033619636,
"time": 210,
"config": "linux-release-x86_64",
"r": "4.6.0",
"check": "OK",
"artifact": "7235124059"
},
{
"job": 78033619617,
"time": 135,
"config": "macos-oldrel-arm64",
"r": "4.5.3",
"check": "OK",
"artifact": "7235100342"
},
{
"job": 78033619575,
"time": 123,
"config": "macos-release-arm64",
"r": "4.6.0",
"check": "OK",
"artifact": "7235096613"
},
{
"job": 78033019592,
"time": 223,
"config": "source",
"r": "4.6.0",
"check": "OK",
"artifact": "7235056270"
},
{
"job": 78033619584,
"time": 122,
"config": "wasm-release",
"r": "4.6.0",
"check": "OK",
"artifact": "7235096826"
},
{
"job": 78033619657,
"time": 243,
"config": "windows-devel",
"r": "4.7.0",
"check": "OK",
"artifact": "7235135105"
},
{
"job": 78033619662,
"time": 202,
"config": "windows-oldrel",
"r": "4.5.3",
"check": "OK",
"artifact": "7235121928"
},
{
"job": 78033619622,
"time": 173,
"config": "windows-release",
"r": "4.6.0",
"check": "OK",
"artifact": "7235112242"
}
],
"_buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/26498620359",
"_status": "success",
"_host": "GitHub-Actions",
"_upstream": "https://github.com/DyfanJones/RAthena",
"_commit": {
"id": "bfff31bbeb1cc65f74171f7e798195029565d9fb",
"author": "dyfan.jones ",
"committer": "dyfan.jones ",
"message": "Update cran release notes\n",
"time": 1759165478
},
"_maintainer": {
"name": "Dyfan Jones",
"email": "dyfan.r.jones@gmail.com",
"login": "dyfanjones",
"description": "",
"uuid": 23235152
},
"_registered": true,
"_dependencies": [
{
"package": "R",
"version": ">= 3.2.0",
"role": "Depends"
},
{
"package": "data.table",
"version": ">= 1.12.4",
"role": "Imports"
},
{
"package": "DBI",
"version": ">= 0.7",
"role": "Imports"
},
{
"package": "methods",
"role": "Imports"
},
{
"package": "reticulate",
"version": ">= 1.13",
"role": "Imports"
},
{
"package": "stats",
"role": "Imports"
},
{
"package": "utils",
"role": "Imports"
},
{
"package": "uuid",
"version": ">= 0.1-4",
"role": "Imports"
},
{
"package": "arrow",
"role": "Suggests"
},
{
"package": "bit64",
"role": "Suggests"
},
{
"package": "dplyr",
"version": ">= 0.8.0",
"role": "Suggests"
},
{
"package": "dbplyr",
"version": ">= 1.4.3",
"role": "Suggests"
},
{
"package": "testthat",
"role": "Suggests"
},
{
"package": "tibble",
"role": "Suggests"
},
{
"package": "vroom",
"version": ">= 1.2.0",
"role": "Suggests"
},
{
"package": "covr",
"role": "Suggests"
},
{
"package": "knitr",
"role": "Suggests"
},
{
"package": "rmarkdown",
"role": "Suggests"
},
{
"package": "jsonify",
"role": "Suggests"
},
{
"package": "jsonlite",
"role": "Suggests"
}
],
"_owner": "dyfanjones",
"_selfowned": true,
"_usedby": 0,
"_updates": [
{
"week": "2025-40",
"n": 2
}
],
"_tags": [],
"_topics": [
"athena",
"aws",
"boto3",
"database"
],
"_stars": 37,
"_contributors": [
{
"user": "dyfanjones",
"count": 216,
"uuid": 23235152
},
{
"user": "olivroy",
"count": 1,
"uuid": 52606734
},
{
"user": "ras44",
"count": 1,
"uuid": 9282281
}
],
"_userbio": {
"uuid": 23235152,
"type": "user",
"name": "Larefly"
},
"_downloads": {
"count": 876,
"source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RAthena"
},
"_devurl": "https://github.com/dyfanjones/rathena",
"_pkgdown": "https://dyfanjones.github.io/RAthena/",
"_searchresults": 44,
"_rbuild": "4.6.0",
"_assets": [
"extra/citation.cff",
"extra/citation.html",
"extra/citation.json",
"extra/citation.txt",
"extra/contents.json",
"extra/NEWS.html",
"extra/NEWS.txt",
"extra/RAthena.html",
"extra/readme.html",
"extra/readme.md",
"manual.pdf"
],
"_homeurl": "https://github.com/dyfanjones/rathena",
"_realowner": "dyfanjones",
"_cranurl": true,
"_releases": [
{
"version": "1.2.0",
"date": "2019-10-14"
},
{
"version": "1.3.0",
"date": "2019-10-23"
},
{
"version": "1.4.0",
"date": "2019-11-14"
},
{
"version": "1.4.1",
"date": "2019-11-28"
},
{
"version": "1.5.0",
"date": "2019-12-06"
},
{
"version": "1.6.0",
"date": "2019-12-19"
},
{
"version": "1.7.0",
"date": "2020-01-08"
},
{
"version": "1.7.1",
"date": "2020-02-16"
},
{
"version": "1.8.0",
"date": "2020-03-17"
},
{
"version": "1.9.0",
"date": "2020-05-14"
},
{
"version": "1.9.1",
"date": "2020-07-02"
},
{
"version": "1.10.0",
"date": "2020-08-06"
},
{
"version": "1.10.1",
"date": "2020-09-27"
},
{
"version": "1.11.0",
"date": "2020-11-11"
},
{
"version": "1.11.1",
"date": "2020-11-17"
},
{
"version": "1.12.0",
"date": "2021-01-20"
},
{
"version": "2.0.0",
"date": "2021-02-22"
},
{
"version": "2.0.1",
"date": "2021-02-25"
},
{
"version": "2.1.0",
"date": "2021-07-27"
},
{
"version": "2.2.0",
"date": "2021-09-23"
},
{
"version": "2.3.0",
"date": "2021-10-26"
},
{
"version": "2.4.0",
"date": "2021-11-26"
},
{
"version": "2.5.0",
"date": "2022-01-17"
},
{
"version": "2.5.1",
"date": "2022-01-26"
},
{
"version": "2.6.0",
"date": "2022-05-20"
},
{
"version": "2.6.1",
"date": "2022-12-20"
},
{
"version": "2.6.3",
"date": "2025-09-29"
}
],
"_exports": [
"assume_role",
"athena",
"AthenaListObjects",
"AthenaPreviewObject",
"create_work_group",
"db_compute.AthenaConnection",
"db_copy_to.AthenaConnection",
"dbBegin",
"dbClearResult",
"dbColumnInfo",
"dbCommit",
"dbConnect",
"dbConvertTable",
"dbDataType",
"dbDisconnect",
"dbExecute",
"dbExistsTable",
"dbFetch",
"dbGetInfo",
"dbGetPartition",
"dbGetQuery",
"dbGetStatement",
"dbGetTables",
"dbHasCompleted",
"dbIsValid",
"dbListFields",
"dbListTables",
"dbplyr_edition.AthenaConnection",
"dbQuoteIdentifier",
"dbQuoteString",
"dbRemoveTable",
"dbRollback",
"dbSendQuery",
"dbSendStatement",
"dbShow",
"dbStatistics",
"dbWriteTable",
"delete_work_group",
"get_session_token",
"get_work_group",
"install_boto",
"list_work_groups",
"RAthena_options",
"show",
"sql_escape_date.AthenaConnection",
"sql_escape_datetime.AthenaConnection",
"sql_query_save.AthenaConnection",
"sql_translate_env.AthenaConnection",
"sql_translation.AthenaConnection",
"sqlCreateTable",
"sqlData",
"tag_options",
"update_work_group"
],
"_help": [
{
"page": "RAthena-package",
"title": "RAthena: a DBI interface into Athena using Boto3 SDK",
"topics": [
"RAthena-package",
"RAthena"
]
},
{
"page": "assume_role",
"title": "Assume AWS ARN Role",
"topics": [
"assume_role"
]
},
{
"page": "athena",
"title": "Athena Driver",
"topics": [
"athena"
]
},
{
"page": "AthenaConnection",
"title": "Athena Connection Methods",
"topics": [
"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"
]
},
{
"page": "AthenaResult",
"title": "Athena Result Methods",
"topics": [
"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"
]
},
{
"page": "AthenaWriteTables",
"title": "Convenience functions for reading/writing DBMS tables",
"topics": [
"AthenaWriteTables",
"dbWriteTable,AthenaConnection,character,data.frame-method",
"dbWriteTable,AthenaConnection,Id,data.frame-method",
"dbWriteTable,AthenaConnection,SQL,data.frame-method"
]
},
{
"page": "backend_dbplyr",
"title": "Athena S3 implementation of dbplyr backend functions (api version 2).",
"topics": [
"backend_dbplyr",
"sql_escape_date.AthenaConnection",
"sql_escape_datetime.AthenaConnection",
"sql_query_explain.AthenaConnection",
"sql_query_fields.AthenaConnection"
]
},
{
"page": "backend_dbplyr_v1",
"title": "Athena S3 implementation of dbplyr backend functions (api version 1).",
"topics": [
"backend_dbplyr_v1",
"db_explain.AthenaConnection",
"db_query_fields.AthenaConnection"
]
},
{
"page": "db_compute",
"title": "S3 implementation of 'db_compute' for Athena",
"topics": [
"db_compute",
"db_compute.AthenaConnection",
"sql_query_save.AthenaConnection"
]
},
{
"page": "db_connection_describe",
"title": "S3 implementation of 'db_connection_describe' for Athena (api version 2).",
"topics": [
"db_connection_describe",
"db_connection_describe.AthenaConnection"
]
},
{
"page": "db_copy_to",
"title": "S3 implementation of 'db_copy_to' for Athena",
"topics": [
"db_copy_to",
"db_copy_to.AthenaConnection"
]
},
{
"page": "db_desc",
"title": "S3 implementation of 'db_desc' for Athena (api version 1).",
"topics": [
"db_desc",
"db_desc.AthenaConnection"
]
},
{
"page": "dbConnect-AthenaDriver-method",
"title": "Connect to Athena using python's sdk boto3",
"topics": [
"dbConnect",
"dbConnect,AthenaDriver-method"
]
},
{
"page": "dbConvertTable",
"title": "dbConvertTable aws s3 backend file types.",
"topics": [
"dbConvertTable",
"dbConvertTable,AthenaConnection-method"
]
},
{
"page": "dbListTables",
"title": "List Athena Tables",
"topics": [
"dbListTables",
"dbListTables,AthenaConnection-method"
]
},
{
"page": "dbplyr_edition",
"title": "Declare which version of dbplyr API is being called.",
"topics": [
"dbplyr_edition",
"dbplyr_edition.AthenaConnection"
]
},
{
"page": "install_boto",
"title": "Install Amazon SDK boto3 for Athena connection",
"topics": [
"install_boto"
]
},
{
"page": "RAthena_options",
"title": "A method to configure RAthena backend options.",
"topics": [
"RAthena_options"
]
},
{
"page": "session_token",
"title": "Get Session Tokens for Boto3 Connection",
"topics": [
"get_session_token",
"session_token"
]
},
{
"page": "sql_translate_env",
"title": "AWS Athena backend dbplyr version 1 and 2",
"topics": [
"sql_translate_env",
"sql_translate_env.AthenaConnection",
"sql_translation.AthenaConnection"
]
},
{
"page": "sqlCreateTable",
"title": "Creates query to create a simple Athena table",
"topics": [
"sqlCreateTable",
"sqlCreateTable,AthenaConnection-method"
]
},
{
"page": "sqlData",
"title": "Converts data frame into suitable format to be uploaded to Athena",
"topics": [
"sqlData",
"sqlData,AthenaConnection-method"
]
},
{
"page": "work_group",
"title": "Athena Work Groups",
"topics": [
"create_work_group",
"delete_work_group",
"get_work_group",
"list_work_groups",
"tag_options",
"update_work_group",
"work_group"
]
}
],
"_readme": "https://github.com/DyfanJones/RAthena/raw/HEAD/README.md",
"_rundeps": [
"data.table",
"DBI",
"here",
"jsonlite",
"lattice",
"Matrix",
"png",
"rappdirs",
"Rcpp",
"RcppTOML",
"reticulate",
"rlang",
"rprojroot",
"uuid",
"withr"
],
"_vignettes": [
{
"source": "aws_athena_query_caching.Rmd",
"filename": "aws_athena_query_caching.html",
"title": "AWS Athena Query Caching",
"author": "Dyfan Jones",
"engine": "knitr::rmarkdown",
"headings": [
"Intro",
"Caching benefits",
"Caching weakness",
"Cache memory",
"Clear down cache"
],
"created": "2020-03-03 10:02:18",
"modified": "2020-04-21 13:03:42",
"commits": 4
},
{
"source": "aws_athena_unload.Rmd",
"filename": "aws_athena_unload.html",
"title": "AWS Athena Unload",
"author": "Dyfan Jones",
"engine": "knitr::rmarkdown",
"headings": [
"Pros and Cons",
"unload=FALSE (Default)",
"unload=TRUE",
"Performance comparison:",
"Set unload = TRUE on package level:"
],
"created": "2021-10-07 13:43:45",
"modified": "2022-05-19 13:11:48",
"commits": 4
},
{
"source": "aws_s3_backend.Rmd",
"filename": "aws_s3_backend.html",
"title": "AWS S3 Backend",
"author": "Dyfan Jones",
"engine": "knitr::rmarkdown",
"headings": [
"AWS S3 Structures",
"File Types",
"Useful links"
],
"created": "2020-03-08 18:40:43",
"modified": "2025-09-29 17:03:43",
"commits": 4
},
{
"source": "changing_backend_file_parser.Rmd",
"filename": "changing_backend_file_parser.html",
"title": "Changing Backend File Parser",
"author": "Dyfan Jones",
"engine": "knitr::rmarkdown",
"headings": [
"Intro",
"Change back to data.table",
"Swapping on the fly",
"Why should you consider vroom?"
],
"created": "2020-03-04 16:55:11",
"modified": "2022-05-18 16:05:56",
"commits": 5
},
{
"source": "convert_and_save_cost.Rmd",
"filename": "convert_and_save_cost.html",
"title": "Convert and Save Cost",
"author": "Dyfan Jones",
"engine": "knitr::rmarkdown",
"headings": [
"Pricing Details",
"RAthena's help",
"Upload Data in delimited format",
"Convert Data into Parquet or ORC",
"Insert into table for ETL processes",
"dplyr method",
"Reading Material"
],
"created": "2020-04-21 13:03:42",
"modified": "2025-09-29 17:03:43",
"commits": 2
},
{
"source": "getting_started.Rmd",
"filename": "getting_started.html",
"title": "Getting Started",
"author": "Dyfan Jones",
"engine": "knitr::rmarkdown",
"headings": [
"Installing RAthena:",
"Python Environments:",
"Docker Example:",
"Usage:",
"Low - Level API:",
"DBI:",
"dplyr:",
"Useful Links:"
],
"created": "2020-03-08 18:40:43",
"modified": "2025-09-29 17:03:43",
"commits": 8
},
{
"source": "how_to_retry.Rmd",
"filename": "how_to_retry.html",
"title": "How to Retry?",
"author": "Dyfan Jones",
"engine": "knitr::rmarkdown",
"headings": [
"How to handle RAthena's retry?",
"Configure",
"Requests",
"Reading material"
],
"created": "2020-04-16 15:07:47",
"modified": "2022-05-19 13:11:48",
"commits": 3
}
],
"_score": 7.05675244056744,
"_indexed": true,
"_nocasepkg": "rathena",
"_universes": [
"dyfanjones"
],
"_binaries": [
{
"r": "4.7.0",
"os": "linux",
"version": "2.6.3",
"date": "2026-05-27T08:04:37.000Z",
"distro": "noble",
"commit": "bfff31bbeb1cc65f74171f7e798195029565d9fb",
"fileid": "6057bc91bca3d2e697dca3b994961e757d078df192f1debe299f1eec7bc0f875",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/26498620359"
},
{
"r": "4.6.0",
"os": "linux",
"version": "2.6.3",
"date": "2026-05-27T08:04:58.000Z",
"distro": "noble",
"commit": "bfff31bbeb1cc65f74171f7e798195029565d9fb",
"fileid": "11f7b514246fa558ec8773b9300b7eb011654c9767d824546e0b597de64e140b",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/26498620359"
},
{
"r": "4.5.3",
"os": "mac",
"version": "2.6.3",
"date": "2026-05-27T08:03:47.000Z",
"commit": "bfff31bbeb1cc65f74171f7e798195029565d9fb",
"fileid": "7696eb7d7028880d2aaf22f5881b9e00e1c26608c11cdd147969adcfd2380789",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/26498620359"
},
{
"r": "4.6.0",
"os": "mac",
"version": "2.6.3",
"date": "2026-05-27T08:03:38.000Z",
"commit": "bfff31bbeb1cc65f74171f7e798195029565d9fb",
"fileid": "daac52defab33ca50eb250e4f13be7fdcdb5d830889b1fa0ed8f8899bda1aef2",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/26498620359"
},
{
"r": "4.6.0",
"os": "wasm",
"version": "2.6.3",
"date": "2026-05-27T08:04:21.000Z",
"commit": "bfff31bbeb1cc65f74171f7e798195029565d9fb",
"fileid": "60633e78f15fe9af3425c119af3e96ecba6030b9f69ddd340feb554314cfa2a6",
"status": "success",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/26498620359"
},
{
"r": "4.7.0",
"os": "win",
"version": "2.6.3",
"date": "2026-05-27T08:04:19.000Z",
"commit": "bfff31bbeb1cc65f74171f7e798195029565d9fb",
"fileid": "6011c941d728450c4f6e75971f85ac54257bfd5c10d0587dc84d64b81b9312f2",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/26498620359"
},
{
"r": "4.5.3",
"os": "win",
"version": "2.6.3",
"date": "2026-05-27T08:03:26.000Z",
"commit": "bfff31bbeb1cc65f74171f7e798195029565d9fb",
"fileid": "7769fc1f1b8e0860dc769a96d685ab92d829269ef613638c8070bd6835f092be",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/26498620359"
},
{
"r": "4.6.0",
"os": "win",
"version": "2.6.3",
"date": "2026-05-27T08:03:23.000Z",
"commit": "bfff31bbeb1cc65f74171f7e798195029565d9fb",
"fileid": "e7cdb42404560c21d5ea6e3ca2ae216127d2d42194a6fa2282ac1abdb0f0a66e",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/26498620359"
}
]
}