Package: noctua 2.6.3

noctua: Connect to 'AWS Athena' using R 'AWS SDK' 'paws' ('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 the 'R' 'AWS' Software Development Kit ('SDK') 'paws' <https://github.com/paws-r/paws> is used as a driver.

Authors:Dyfan Jones [aut, cre]

noctua_2.6.3.tar.gz
noctua_2.6.3.zip(r-4.7)noctua_2.6.3.zip(r-4.6)noctua_2.6.3.zip(r-4.5)
noctua_2.6.3.tgz(r-4.6-any)noctua_2.6.3.tgz(r-4.5-any)
noctua_2.6.3.tar.gz(r-4.7-any)noctua_2.6.3.tar.gz(r-4.6-any)
noctua_2.6.3.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
noctua/json (API)

# Install 'noctua' in R:
install.packages('noctua', repos = c('https://dyfanjones.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/dyfanjones/noctua/issues

Pkgdown/docs site:https://dyfanjones.github.io

On CRAN:

Conda:

athenaawsdatabase

7.97 score 46 stars 91 scripts 1.1k downloads 52 exports 37 dependencies

Last updated from:fdb0b87acf. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK143
source / vignettesOK206
linux-release-x86_64OK163
macos-release-arm64OK135
macos-oldrel-arm64OK114
windows-develOK112
windows-releaseOK87
windows-oldrelOK95
wasm-releaseOK122

Exports:assume_roleathenaAthenaListObjectsAthenaPreviewObjectcreate_work_groupdb_compute.AthenaConnectiondb_copy_to.AthenaConnectiondbBegindbClearResultdbColumnInfodbCommitdbConnectdbConvertTabledbDataTypedbDisconnectdbExecutedbExistsTabledbFetchdbGetInfodbGetPartitiondbGetQuerydbGetStatementdbGetTablesdbHasCompleteddbIsValiddbListFieldsdbListTablesdbplyr_edition.AthenaConnectiondbQuoteIdentifierdbQuoteStringdbRemoveTabledbRollbackdbSendQuerydbSendStatementdbShowdbStatisticsdbWriteTabledelete_work_groupget_session_tokenget_work_grouplist_work_groupsnoctua_optionsshowsql_escape_date.AthenaConnectionsql_escape_datetime.AthenaConnectionsql_query_save.AthenaConnectionsql_translate_env.AthenaConnectionsql_translation.AthenaConnectionsqlCreateTablesqlDatatag_optionsupdate_work_group

Dependencies:askpassbase64encclicurldata.tableDBIdigestgluehttr2jsonlitelifecyclemagrittropensslpawspaws.analyticspaws.application.integrationpaws.commonpaws.computepaws.cost.managementpaws.customer.engagementpaws.databasepaws.developer.toolspaws.end.user.computingpaws.machine.learningpaws.managementpaws.networkingpaws.security.identitypaws.storageR6rappdirsRcpprlangsysuuidvctrswithrxml2

AWS S3 Backend
AWS S3 Structures | File Types | Useful links
Rendered fromaws_s3_backend.Rmdusingknitr::rmarkdown

Last update: 2025-09-15
Started: 2020-03-06

Convert and Save Cost
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
Rendered fromconvert_and_save_cost.Rmdusingknitr::rmarkdown

Last update: 2025-09-15
Started: 2020-04-21

Getting Started
Installing noctua: | Docker Example: | Usage: | Low - Level API: | DBI: | dplyr: | Useful Links:
Rendered fromgetting_started.Rmdusingknitr::rmarkdown

Last update: 2023-08-07
Started: 2020-03-06

Changing Backend File Parser
Intro | Change back to data.table | Swapping on the fly | Why should you consider vroom?
Rendered fromchanging_backend_file_parser.Rmdusingknitr::rmarkdown

Last update: 2022-05-18
Started: 2020-03-06

AWS Athena Unload
Pros and Cons | unload=FALSE (Default) | unload=TRUE | Performance comparison: | Set unload = TRUE on package level:
Rendered fromaws_athena_unload.Rmdusingknitr::rmarkdown

Last update: 2021-11-24
Started: 2021-10-06

How to Retry?
How to handle noctua's retry? | Configure | Requests | Reading material
Rendered fromhow_to_retry.Rmdusingknitr::rmarkdown

Last update: 2020-05-14
Started: 2020-04-16

AWS Athena Query Caching
Intro | Caching benefits | Caching weakness | Cache memory | Clear down cache
Rendered fromaws_athena_query_caching.Rmdusingknitr::rmarkdown

Last update: 2020-04-21
Started: 2020-03-02

Readme and manuals

Help Manual

Help pageTopics
noctua: a DBI interface into Athena using paws SDKnoctua-package noctua
Assume AWS ARN Roleassume_role
Athena Driverathena
Athena Connection MethodsAthenaConnection 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
Athena Result MethodsAthenaResult 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
Convenience functions for reading/writing DBMS tablesAthenaWriteTables dbWriteTable,AthenaConnection,character,data.frame-method dbWriteTable,AthenaConnection,Id,data.frame-method dbWriteTable,AthenaConnection,SQL,data.frame-method
Athena S3 implementation of dbplyr backend functionsbackend_dbplyr sql_escape_date.AthenaConnection sql_escape_datetime.AthenaConnection sql_query_explain.AthenaConnection sql_query_fields.AthenaConnection
S3 implementation of 'db_compute' for Athenadb_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 Athenadb_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 R's sdk pawsdbConnect dbConnect,AthenaDriver-method
dbConvertTable aws s3 backend file types.dbConvertTable dbConvertTable,AthenaConnection-method
List Athena TablesdbListTables dbListTables,AthenaConnection-method
Declare which version of dbplyr API is being called.dbplyr_edition dbplyr_edition.AthenaConnection
A method to configure noctua backend options.noctua_options
Get Session Tokens for PAWS Connectionget_session_token session_token
AWS Athena backend dbplyr version 1 and 2sql_translate_env sql_translate_env.AthenaConnection sql_translation.AthenaConnection
Creates query to create a simple Athena tablesqlCreateTable sqlCreateTable,AthenaConnection-method
Converts data frame into suitable format to be uploaded to AthenasqlData sqlData,AthenaConnection-method
Athena Work Groupscreate_work_group delete_work_group get_work_group list_work_groups tag_options update_work_group work_group