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:
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')) |
Bug tracker:https://github.com/dyfanjones/noctua/issues
Last updated 8 months agofrom:23a4cfbf53. Checks:OK: 3 NOTE: 4. Indexed: yes.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Nov 06 2024 |
| R-4.5-win | NOTE | Nov 06 2024 |
| R-4.5-linux | NOTE | Nov 06 2024 |
| R-4.4-win | NOTE | Nov 06 2024 |
| R-4.4-mac | NOTE | Nov 06 2024 |
| R-4.3-win | OK | Nov 06 2024 |
| R-4.3-mac | OK | Nov 06 2024 |
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 Nov 06 2024.Last update: 2020-04-21
Started: 2020-03-02
AWS Athena Unload
Rendered fromaws_athena_unload.Rmdusingknitr::rmarkdownon Nov 06 2024.Last update: 2021-11-24
Started: 2021-10-06
AWS S3 Backend
Rendered fromaws_s3_backend.Rmdusingknitr::rmarkdownon Nov 06 2024.Last update: 2020-04-16
Started: 2020-03-06
Changing Backend File Parser
Rendered fromchanging_backend_file_parser.Rmdusingknitr::rmarkdownon Nov 06 2024.Last update: 2022-05-18
Started: 2020-03-06
Convert and Save Cost
Rendered fromconvert_and_save_cost.Rmdusingknitr::rmarkdownon Nov 06 2024.Last update: 2020-04-21
Started: 2020-04-21
Getting Started
Rendered fromgetting_started.Rmdusingknitr::rmarkdownon Nov 06 2024.Last update: 2023-08-07
Started: 2020-03-06
How to Retry?
Rendered fromhow_to_retry.Rmdusingknitr::rmarkdownon Nov 06 2024.Last update: 2020-05-14
Started: 2020-04-16
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| noctua: a DBI interface into Athena using paws SDK | noctua-package noctua |
| Assume AWS ARN Role | assume_role |
| Athena Driver | athena |
| Convenience functions for reading/writing DBMS tables | AthenaWriteTables 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 Athena | db_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 Athena | db_copy_to db_copy_to.AthenaConnection |
| S3 implementation of 'db_desc' for Athena (api version 1). | db_desc db_desc.AthenaConnection |
| Clear Results | dbClearResult dbClearResult,AthenaResult-method |
| Information about result types | dbColumnInfo dbColumnInfo,AthenaResult-method |
| Connect to Athena using R's sdk paws | dbConnect dbConnect,AthenaDriver-method |
| Simple wrapper to convert Athena backend file types | dbConvertTable dbConvertTable,AthenaConnection-method |
| Determine SQL data type of object | dbDataType dbDataType,AthenaConnection,ANY-method dbDataType,AthenaConnection,data.frame-method dbDataType,AthenaDriver,ANY-method dbDataType,AthenaDriver,list-method |
| Disconnect (close) an Athena connection | dbDisconnect dbDisconnect,AthenaConnection-method |
| Does Athena table exist? | dbExistsTable dbExistsTable,AthenaConnection,character-method dbExistsTable,AthenaConnection,Id-method |
| Fetch records from previously executed query | dbFetch dbFetch,AthenaResult-method |
| Get DBMS metadata | dbGetInfo dbGetInfo,AthenaConnection-method dbGetInfo,AthenaResult-method |
| Athena table partitions | dbGetPartition dbGetPartition,AthenaConnection-method |
| Send query, retrieve results and then clear result set | dbGetQuery dbGetQuery,AthenaConnection,character-method |
| Get the statement associated with a result set | dbGetStatement dbGetStatement,AthenaResult-method |
| List Athena Schema, Tables and Table Types | dbGetTables dbGetTables,AthenaConnection-method |
| Completion status | dbHasCompleted dbHasCompleted,AthenaResult-method |
| Is this DBMS object still valid? | dbIsValid dbIsValid,AthenaConnection-method dbIsValid,AthenaResult-method |
| List Field names of Athena table | dbListFields dbListFields,AthenaConnection,character-method |
| List Athena Tables | dbListTables dbListTables,AthenaConnection-method |
| Declare which version of dbplyr API is being called. | dbplyr_edition dbplyr_edition.AthenaConnection |
| Quote Identifiers | dbQuote dbQuoteIdentifier,AthenaConnection,SQL-method dbQuoteString,AthenaConnection,character-method dbQuoteString,AthenaConnection,Date-method dbQuoteString,AthenaConnection,POSIXct-method |
| Remove table from Athena | dbRemoveTable dbRemoveTable,AthenaConnection,character-method dbRemoveTable,AthenaConnection,Id-method |
| Show Athena table's DDL | dbShow dbShow,AthenaConnection-method |
| Show AWS Athena Statistics | dbStatistics dbStatistics,AthenaResult-method |
| A method to configure noctua backend options. | noctua_options |
| Execute a query on Athena | dbExecute,AthenaConnection,character-method dbSendQuery,AthenaConnection,character-method dbSendStatement,AthenaConnection,character-method Query |
| Get Session Tokens for PAWS Connection | get_session_token session_token |
| AWS Athena backend dbplyr version 1 and 2 | sql_escape_string.AthenaConnection sql_translate_env sql_translate_env.AthenaConnection sql_translation.AthenaConnection |
| Creates query to create a simple Athena table | sqlCreateTable sqlCreateTable,AthenaConnection-method |
| Converts data frame into suitable format to be uploaded to Athena | sqlData sqlData,AthenaConnection-method |
| Athena Work Groups | create_work_group delete_work_group get_work_group list_work_groups tag_options update_work_group work_group |
