Package: noctua 2.6.2

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.2.tar.gz
noctua_2.6.2.zip(r-4.5)noctua_2.6.2.zip(r-4.4)noctua_2.6.2.zip(r-4.3)
noctua_2.6.2.tgz(r-4.4-any)noctua_2.6.2.tgz(r-4.3-any)
noctua_2.6.2.tar.gz(r-4.5-noble)noctua_2.6.2.tar.gz(r-4.4-noble)
noctua_2.6.2.tgz(r-4.4-emscripten)noctua_2.6.2.tgz(r-4.3-emscripten)
noctua.pdf |noctua.html
noctua/json (API)
NEWS

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

Peer review:

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

On CRAN:

athenaawsdatabase

51 exports 45 stars 3.19 score 32 dependencies 1.1k downloads

Last updated 2 months agofrom:23a4cfbf537407c7a1547fc13ba771ba2eb098e0

Exports:assume_roleathenacreate_work_groupdb_compute.AthenaConnectiondb_copy_to.AthenaConnectiondbBegindbClearResultdbColumnInfodbCommitdbConnectdbConvertTabledbDataTypedbDisconnectdbExecutedbExistsTabledbFetchdbGetInfodbGetPartitiondbGetQuerydbGetStatementdbGetTablesdbHasCompleteddbIsValiddbListFieldsdbListTablesdbplyr_edition.AthenaConnectiondbQuoteIdentifierdbQuoteStringdbRemoveTabledbRollbackdbSendQuerydbSendStatementdbShowdbStatisticsdbWriteTabledelete_work_groupget_session_tokenget_work_grouplist_work_groupsnoctua_optionsshowsql_escape_date.AthenaConnectionsql_escape_datetime.AthenaConnectionsql_escape_string.AthenaConnectionsql_query_save.AthenaConnectionsql_translate_env.AthenaConnectionsql_translation.AthenaConnectionsqlCreateTablesqlDatatag_optionsupdate_work_group

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

AWS Athena Query Caching

Rendered fromaws_athena_query_caching.Rmdusingknitr::rmarkdownon Jun 09 2024.

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

AWS Athena Unload

Rendered fromaws_athena_unload.Rmdusingknitr::rmarkdownon Jun 09 2024.

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

AWS S3 Backend

Rendered fromaws_s3_backend.Rmdusingknitr::rmarkdownon Jun 09 2024.

Last update: 2020-04-16
Started: 2020-03-06

Changing Backend File Parser

Rendered fromchanging_backend_file_parser.Rmdusingknitr::rmarkdownon Jun 09 2024.

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

Convert and Save Cost

Rendered fromconvert_and_save_cost.Rmdusingknitr::rmarkdownon Jun 09 2024.

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

Getting Started

Rendered fromgetting_started.Rmdusingknitr::rmarkdownon Jun 09 2024.

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

How to Retry?

Rendered fromhow_to_retry.Rmdusingknitr::rmarkdownon Jun 09 2024.

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

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
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 functions (api version 1).backend_dbplyr_v1 db_explain.AthenaConnection db_query_fields.AthenaConnection
Athena S3 implementation of dbplyr backend functions (api version 2).backend_dbplyr_v2 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
Clear ResultsdbClearResult dbClearResult,AthenaResult-method
Information about result typesdbColumnInfo dbColumnInfo,AthenaResult-method
Connect to Athena using R's sdk pawsdbConnect dbConnect,AthenaDriver-method
Simple wrapper to convert Athena backend file typesdbConvertTable dbConvertTable,AthenaConnection-method
Determine SQL data type of objectdbDataType dbDataType,AthenaConnection,ANY-method dbDataType,AthenaConnection,data.frame-method dbDataType,AthenaDriver,ANY-method dbDataType,AthenaDriver,list-method
Disconnect (close) an Athena connectiondbDisconnect dbDisconnect,AthenaConnection-method
Does Athena table exist?dbExistsTable dbExistsTable,AthenaConnection,character-method dbExistsTable,AthenaConnection,Id-method
Fetch records from previously executed querydbFetch dbFetch,AthenaResult-method
Get DBMS metadatadbGetInfo dbGetInfo,AthenaConnection-method dbGetInfo,AthenaResult-method
Athena table partitionsdbGetPartition dbGetPartition,AthenaConnection-method
Send query, retrieve results and then clear result setdbGetQuery dbGetQuery,AthenaConnection,character-method
Get the statement associated with a result setdbGetStatement dbGetStatement,AthenaResult-method
List Athena Schema, Tables and Table TypesdbGetTables dbGetTables,AthenaConnection-method
Completion statusdbHasCompleted dbHasCompleted,AthenaResult-method
Is this DBMS object still valid?dbIsValid dbIsValid,AthenaConnection-method dbIsValid,AthenaResult-method
List Field names of Athena tabledbListFields dbListFields,AthenaConnection,character-method
List Athena TablesdbListTables dbListTables,AthenaConnection-method
Declare which version of dbplyr API is being called.dbplyr_edition dbplyr_edition.AthenaConnection
Quote IdentifiersdbQuote dbQuoteIdentifier,AthenaConnection,SQL-method dbQuoteString,AthenaConnection,character-method dbQuoteString,AthenaConnection,Date-method dbQuoteString,AthenaConnection,POSIXct-method
Remove table from AthenadbRemoveTable dbRemoveTable,AthenaConnection,character-method dbRemoveTable,AthenaConnection,Id-method
Show Athena table's DDLdbShow dbShow,AthenaConnection-method
Show AWS Athena StatisticsdbStatistics dbStatistics,AthenaResult-method
A method to configure noctua backend options.noctua_options
Execute a query on AthenadbExecute,AthenaConnection,character-method dbSendQuery,AthenaConnection,character-method dbSendStatement,AthenaConnection,character-method Query
Get Session Tokens for PAWS Connectionget_session_token session_token
AWS Athena backend dbplyr version 1 and 2sql_escape_string.AthenaConnection sql_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