{
"_id": "6a102975acfb0bcc41c9165a",
"Package": "noctua",
"Type": "Package",
"Title": "Connect to 'AWS Athena' using R 'AWS SDK' 'paws' ('DBI'\nInterface)",
"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 the\n'R' 'AWS' Software Development Kit ('SDK') 'paws'\n is used as a driver.",
"VignetteBuilder": "knitr",
"License": "MIT + file LICENSE",
"Encoding": "UTF-8",
"RoxygenNote": "7.3.3",
"URL": "https://dyfanjones.github.io/noctua/,\nhttps://github.com/DyfanJones/noctua",
"BugReports": "https://github.com/DyfanJones/noctua/issues",
"Collate": "'utils.R' 'dplyr_integration.R' 'noctua.R' 'Driver.R'\n'Connection.R' 'DataTypes.R' 'File_Parser.R' 'Options.R'\n'fetch_utils.R' 'Result.R' 'Table.R' 'View.R'\n'athena_low_api.R' 'column_parser.R' 'sql_translate_utils.R'\n'sql_translate_env.R' 'zzz.R'",
"Roxygen": "list(markdown = TRUE)",
"Config/pak/sysreqs": "libxml2-dev libssl-dev",
"Repository": "https://dyfanjones.r-universe.dev",
"Date/Publication": "2025-09-15 19:01:43 UTC",
"RemoteUrl": "https://github.com/DyfanJones/noctua",
"RemoteRef": "HEAD",
"RemoteSha": "fdb0b87acf4dc3c59a61cadfd4a11d71b3a93615",
"NeedsCompilation": "no",
"Packaged": {
"Date": "2026-05-13 07:37:22 UTC",
"User": "root"
},
"Author": "Dyfan Jones [aut, cre]",
"Maintainer": "Dyfan Jones ",
"MD5sum": "50bb7463a6976b7c7bda86c2a0477ccf",
"_user": "dyfanjones",
"_type": "src",
"_file": "noctua_2.6.3.tar.gz",
"_fileid": "f24e280c90cbd1f97b3c955998905ecc5fbe9dc579a5788682279fbcd60f4848",
"_filesize": 619635,
"_sha256": "f24e280c90cbd1f97b3c955998905ecc5fbe9dc579a5788682279fbcd60f4848",
"_created": "2026-05-13T07:37:22.000Z",
"_published": "2026-05-22T10:01:25.262Z",
"_distro": "noble",
"_jobs": [
{
"job": 77357617429,
"time": 157,
"config": "linux-devel-x86_64",
"r": "4.7.0",
"check": "OK",
"artifact": "6964261970"
},
{
"job": 77357617353,
"time": 161,
"config": "linux-release-x86_64",
"r": "4.6.0",
"check": "OK",
"artifact": "6964262997"
},
{
"job": 77357617485,
"time": 111,
"config": "macos-oldrel-arm64",
"r": "4.5.3",
"check": "OK",
"artifact": "6964248718"
},
{
"job": 77357617312,
"time": 91,
"config": "macos-release-arm64",
"r": "4.6.0",
"check": "OK",
"artifact": "6964242905"
},
{
"job": 77357616893,
"time": 219,
"config": "source",
"r": "4.6.0",
"check": "OK",
"artifact": "6964214811"
},
{
"job": 77357616762,
"time": 130,
"config": "wasm-release",
"r": "4.6.0",
"check": "OK",
"artifact": "7157853689"
},
{
"job": 77357617107,
"time": 106,
"config": "windows-devel",
"r": "4.7.0",
"check": "OK",
"artifact": "6964247040"
},
{
"job": 77357617243,
"time": 107,
"config": "windows-oldrel",
"r": "4.5.3",
"check": "OK",
"artifact": "6964248099"
},
{
"job": 77357617069,
"time": 138,
"config": "windows-release",
"r": "4.6.0",
"check": "OK",
"artifact": "6964256601"
}
],
"_buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/25785136558",
"_status": "success",
"_host": "GitHub-Actions",
"_upstream": "https://github.com/DyfanJones/noctua",
"_commit": {
"id": "fdb0b87acf4dc3c59a61cadfd4a11d71b3a93615",
"author": "dyfan.jones ",
"committer": "dyfan.jones ",
"message": "Fix urls\n",
"time": 1757962903
},
"_maintainer": {
"name": "Dyfan Jones",
"email": "dyfan.r.jones@gmail.com",
"login": "dyfanjones",
"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": "paws",
"version": ">= 0.2.0",
"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": ">= 1.0.0",
"role": "Suggests"
},
{
"package": "dbplyr",
"version": ">= 2.3.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-37",
"n": 1
},
{
"week": "2025-38",
"n": 1
}
],
"_tags": [
{
"name": "v2.6.3",
"date": "2025-09-15"
}
],
"_topics": [
"athena",
"aws",
"database"
],
"_stars": 46,
"_contributors": [
{
"user": "dyfanjones",
"count": 281,
"uuid": 23235152
},
{
"user": "ossilehtinen",
"count": 5,
"uuid": 16836852
},
{
"user": "pegeler",
"count": 1,
"uuid": 32426645
},
{
"user": "olivroy",
"count": 1,
"uuid": 52606734
}
],
"_userbio": {
"uuid": 23235152,
"type": "user",
"name": "Larefly"
},
"_downloads": {
"count": 1253,
"source": "https://cranlogs.r-pkg.org/downloads/total/last-month/noctua"
},
"_devurl": "https://github.com/dyfanjones/noctua",
"_pkgdown": "https://dyfanjones.github.io/noctua/",
"_searchresults": 65,
"_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/noctua.html",
"extra/readme.html",
"extra/readme.md",
"manual.pdf"
],
"_homeurl": "https://github.com/dyfanjones/noctua",
"_realowner": "dyfanjones",
"_cranurl": true,
"_releases": [
{
"version": "1.0.0",
"date": "2019-10-20"
},
{
"version": "1.1.0",
"date": "2019-10-23"
},
{
"version": "1.2.0",
"date": "2019-11-14"
},
{
"version": "1.2.1",
"date": "2019-11-29"
},
{
"version": "1.3.0",
"date": "2019-12-06"
},
{
"version": "1.4.0",
"date": "2019-12-19"
},
{
"version": "1.5.0",
"date": "2020-01-08"
},
{
"version": "1.5.1",
"date": "2020-02-16"
},
{
"version": "1.6.0",
"date": "2020-03-17"
},
{
"version": "1.7.0",
"date": "2020-05-14"
},
{
"version": "1.7.1",
"date": "2020-07-02"
},
{
"version": "1.8.0",
"date": "2020-08-10"
},
{
"version": "1.8.1",
"date": "2020-09-25"
},
{
"version": "1.9.0",
"date": "2020-11-11"
},
{
"version": "1.9.1",
"date": "2020-11-17"
},
{
"version": "1.10.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.2",
"date": "2023-08-08"
},
{
"version": "2.6.3",
"date": "2025-09-15"
}
],
"_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",
"list_work_groups",
"noctua_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": "noctua-package",
"title": "noctua: a DBI interface into Athena using paws SDK",
"topics": [
"noctua-package",
"noctua"
]
},
{
"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",
"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",
"AthenaResult-class",
"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",
"topics": [
"backend_dbplyr",
"sql_escape_date.AthenaConnection",
"sql_escape_datetime.AthenaConnection",
"sql_query_explain.AthenaConnection",
"sql_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 R's sdk paws",
"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": "noctua_options",
"title": "A method to configure noctua backend options.",
"topics": [
"noctua_options"
]
},
{
"page": "session_token",
"title": "Get Session Tokens for PAWS 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"
]
}
],
"_pkglogo": "https://github.com/DyfanJones/noctua/raw/HEAD/man/figures/logo.png",
"_readme": "https://github.com/DyfanJones/noctua/raw/HEAD/README.md",
"_rundeps": [
"askpass",
"base64enc",
"cli",
"curl",
"data.table",
"DBI",
"digest",
"glue",
"httr2",
"jsonlite",
"lifecycle",
"magrittr",
"openssl",
"paws",
"paws.analytics",
"paws.application.integration",
"paws.common",
"paws.compute",
"paws.cost.management",
"paws.customer.engagement",
"paws.database",
"paws.developer.tools",
"paws.end.user.computing",
"paws.machine.learning",
"paws.management",
"paws.networking",
"paws.security.identity",
"paws.storage",
"R6",
"rappdirs",
"Rcpp",
"rlang",
"sys",
"uuid",
"vctrs",
"withr",
"xml2"
],
"_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-02 19:12:21",
"modified": "2020-04-21 15:34:25",
"commits": 5
},
{
"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-06 09:04:00",
"modified": "2021-11-24 17:34:32",
"commits": 5
},
{
"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-06 18:20:39",
"modified": "2025-09-15 19:01:43",
"commits": 3
},
{
"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-06 18:20:39",
"modified": "2022-05-18 17:36:00",
"commits": 3
},
{
"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",
"noctua'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 15:34:25",
"modified": "2025-09-15 19:01:43",
"commits": 2
},
{
"source": "getting_started.Rmd",
"filename": "getting_started.html",
"title": "Getting Started",
"author": "Dyfan Jones",
"engine": "knitr::rmarkdown",
"headings": [
"Installing noctua:",
"Docker Example:",
"Usage:",
"Low - Level API:",
"DBI:",
"dplyr:",
"Useful Links:"
],
"created": "2020-03-06 18:20:39",
"modified": "2023-08-07 15:53:18",
"commits": 4
},
{
"source": "how_to_retry.Rmd",
"filename": "how_to_retry.html",
"title": "How to Retry?",
"author": "Dyfan Jones",
"engine": "knitr::rmarkdown",
"headings": [
"How to handle noctua's retry?",
"Configure",
"Requests",
"Reading material"
],
"created": "2020-04-16 11:59:29",
"modified": "2020-05-14 14:23:37",
"commits": 2
}
],
"_score": 7.8958415540525,
"_indexed": true,
"_nocasepkg": "noctua",
"_universes": [
"dyfanjones"
],
"_binaries": [
{
"r": "4.7.0",
"os": "linux",
"version": "2.6.3",
"date": "2026-05-13T07:39:51.000Z",
"distro": "noble",
"commit": "fdb0b87acf4dc3c59a61cadfd4a11d71b3a93615",
"fileid": "57abfc5df08e56f3b27632b1f65b8a8b5b4de9a09c9ddf68c27ba459382c1667",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/25785136558"
},
{
"r": "4.6.0",
"os": "linux",
"version": "2.6.3",
"date": "2026-05-13T07:39:55.000Z",
"distro": "noble",
"commit": "fdb0b87acf4dc3c59a61cadfd4a11d71b3a93615",
"fileid": "57724010134e10cd5e26c95f544f24039c0b7b6cea65d4dc1114dfc7de071492",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/25785136558"
},
{
"r": "4.5.3",
"os": "mac",
"version": "2.6.3",
"date": "2026-05-13T07:39:11.000Z",
"commit": "fdb0b87acf4dc3c59a61cadfd4a11d71b3a93615",
"fileid": "8dd818ea3f5c9a4868267bc852aea6afc88e3b6e7c50e2abccd9670cc472e9d2",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/25785136558"
},
{
"r": "4.6.0",
"os": "mac",
"version": "2.6.3",
"date": "2026-05-13T07:38:54.000Z",
"commit": "fdb0b87acf4dc3c59a61cadfd4a11d71b3a93615",
"fileid": "c236547fc197bb7d706d2e7d0658d9093ba33af050e58709cd04a971384ea2d3",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/25785136558"
},
{
"r": "4.7.0",
"os": "win",
"version": "2.6.3",
"date": "2026-05-13T07:38:52.000Z",
"commit": "fdb0b87acf4dc3c59a61cadfd4a11d71b3a93615",
"fileid": "7bf185e9424d9479d8e04d2fdce521f45607230c733913c823eed2e05ed5c65e",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/25785136558"
},
{
"r": "4.5.3",
"os": "win",
"version": "2.6.3",
"date": "2026-05-13T07:38:55.000Z",
"commit": "fdb0b87acf4dc3c59a61cadfd4a11d71b3a93615",
"fileid": "21053ad2cc28351adfe60dcde40dac657e8f714222246588d80de264035697ed",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/25785136558"
},
{
"r": "4.6.0",
"os": "win",
"version": "2.6.3",
"date": "2026-05-13T07:39:24.000Z",
"commit": "fdb0b87acf4dc3c59a61cadfd4a11d71b3a93615",
"fileid": "229c9ab36d82077c5b33a166d6a4b57bd1c6e842ec2a2028689ce4cbd36ba154",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/25785136558"
},
{
"r": "4.6.0",
"os": "wasm",
"version": "2.6.3",
"date": "2026-05-22T10:00:43.000Z",
"commit": "fdb0b87acf4dc3c59a61cadfd4a11d71b3a93615",
"fileid": "81c88535dc21aad1e704d8c026aab74face70e5e95af50e2e571dcb8fda76cb0",
"status": "success",
"buildurl": "https://github.com/r-universe/dyfanjones/actions/runs/25785136558"
}
]
}