Package: ckdata 0.1.0

Adam Blake

ckdata: Query Amazon Athena

A read-only DBI and dbplyr interface to Amazon Athena. A shared Rust core executes Athena queries through Parquet and returns Arrow results, including schemas for empty results. Researchers can use lazy dplyr queries, SQL, temporary saved results and reproducible snapshots.

Authors:Adam Blake [aut, cre], CourseKata [cph]

ckdata_0.1.0.tar.gz
ckdata_0.1.0.zip(r-4.7-x86_64)ckdata_0.1.0.zip(r-4.7-arm64)ckdata_0.1.0.zip(r-4.6-x86_64)ckdata_0.1.0.zip(r-4.6-arm64)ckdata_0.1.0.zip(r-4.5-x86_64)
ckdata_0.1.0.tgz(r-4.6-x86_64)ckdata_0.1.0.tgz(r-4.6-arm64)ckdata_0.1.0.tgz(r-4.5-x86_64)ckdata_0.1.0.tgz(r-4.5-arm64)
ckdata_0.1.0.tar.gz(r-4.7-arm64)ckdata_0.1.0.tar.gz(r-4.7-x86_64)ckdata_0.1.0.tar.gz(r-4.6-arm64)ckdata_0.1.0.tar.gz(r-4.6-x86_64)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
ckdata/json (API)

# Install 'ckdata' in R:

install.packages('ckdata', repos = c('https://coursekata.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/coursekata/ckdata/issues

On CRAN:

rust cargo

2.18 score 7 scripts 44 exports 37 dependencies

Last updated from:c5e7a0a9fb (on v0.1.0). Checks:14 OK, 1 FAIL. Indexed: yes.

Target	Result	Time
linux-devel-arm64	OK	381
linux-devel-x86_64	OK	506
source / vignettes	OK	513
linux-release-arm64	OK	383
linux-release-x86_64	OK	480
macos-release-arm64	OK	499
macos-release-x86_64	OK	1016
macos-oldrel-arm64	OK	624
macos-oldrel-x86_64	OK	882
windows-devel-arm64	OK	1023
windows-devel-x86_64	OK	872
windows-release-arm64	OK	1018
windows-release-x86_64	OK	854
windows-oldrel-x86_64	OK	772
wasm-release	FAIL	128

Exports:approx_median approx_quantile ckdata ckdata_schema collect_saved daily_at dbBegin dbBind dbBindArrow dbClearResult dbColumnInfo dbCommit dbConnect dbDataType dbDisconnect dbExistsTable dbFetch dbFetchArrow dbFetchArrowChunk dbGetInfo dbGetQuery dbGetQueryArrow dbGetRowCount dbGetRowsAffected dbGetStatement dbHasCompleted dbIsReadOnly dbIsValid dbListFields dbListObjects dbListTables dbQuoteIdentifier dbQuoteLiteral dbQuoteString dbRollback dbSendQuery dbSendQueryArrow dbSendStatement dbUnloadDriver freshness_check lake_disconnect lake_query lake_tbl show

Dependencies:arrow assertthat bit bit64 blob cachem cli cpp11 DBI dbplyr digest dplyr fastmap fs generics glue jsonlite lifecycle lubridate magrittr nanoarrow pillar pkgconfig processx ps purrr R6 rlang stringi stringr tibble tidyr tidyselect timechange utf8 vctrs withr

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Explicit approximate summaries for remote queries	approx_median approx_quantile
A read-only DBI driver for Amazon Athena	CkConnection-class ckdata CkDriver-class CkResult-class CkResultArrow-class dbBegin,CkConnection-method dbBind,CkResult-method dbBindArrow,CkResult-method dbClearResult,CkResult-method dbColumnInfo,CkResult-method dbCommit,CkConnection-method dbConnect,CkDriver-method dbDataType,CkConnection-method dbDataType,CkDriver-method dbDisconnect,CkConnection-method dbExistsTable,CkConnection,character-method dbExistsTable,CkConnection,Id-method dbFetch,CkResult-method dbFetchArrow,CkResultArrow-method dbFetchArrowChunk,CkResultArrow-method dbGetInfo,CkConnection-method dbGetInfo,CkDriver-method dbGetInfo,CkResultArrow-method dbGetQuery,CkConnection,character-method dbGetQueryArrow,CkConnection,character-method dbGetRowCount,CkResult-method dbGetRowsAffected,CkResult-method dbGetStatement,CkResult-method dbHasCompleted,CkResult-method dbIsReadOnly,CkConnection-method dbIsReadOnly,CkDriver-method dbIsReadOnly,CkResult-method dbIsValid,CkConnection-method dbIsValid,CkDriver-method dbIsValid,CkResult-method dbListFields,CkConnection,character-method dbListFields,CkConnection,Id-method dbListObjects,CkConnection-method dbListTables,CkConnection-method dbQuoteIdentifier,CkConnection,character-method dbQuoteIdentifier,CkConnection,SQL-method dbQuoteLiteral,CkConnection-method dbQuoteString,CkConnection,character-method dbQuoteString,CkConnection,SQL-method dbRollback,CkConnection-method dbSendQuery,CkConnection,character-method dbSendQueryArrow,CkConnection,character-method dbSendStatement,CkConnection,character-method dbUnloadDriver,CkDriver-method show,CkConnection-method
Options that control ckdata	ckdata_options
The database lake_tbl() reads from by default	ckdata_schema
Connection settings	ckdata_settings
Result types and ordering	ckdata_types
Collect a query with temporary reuse or an indefinite Parquet snapshot	collect_saved
Reuse results until a daily refresh or a source revision changes	daily_at freshness_check
Close the managed lake session	lake_disconnect
Execute SQL through the shared query core	lake_query
A lazy table in Amazon Athena	lake_tbl