ducklake: Interact with 'DuckLake' from R

A 'tidyverse'-friendly interface to 'DuckLake' <https://ducklake.select/>, the 'DuckDB' lakehouse format. Attach versioned data lakes from R and work with them using familiar 'dplyr' verbs, with support for ACID transactions, time travel queries, snapshot audit trails, data inlining, encrypted storage, multiple catalog backends ('DuckDB', 'PostgreSQL', 'SQLite', 'MySQL'), and remote access over the 'Quack' protocol from 'DuckDB'.

Version: 0.6.0
Depends: R (≥ 4.1)
Imports: cli, DBI, dbplyr (≥ 2.5.0), dplyr, duckdb (≥ 1.5.1)
Suggests: admiral, DiagrammeR, fs, ggplot2, jsonlite, knitr, lubridate, pharmaversesdtm, purrr, rmarkdown, spelling, stringr, testthat (≥ 3.0.0), tidyr
Published: 2026-09-09
DOI: 10.32614/CRAN.package.ducklake (may not be active yet)
Author: Travis Gerke [aut, cre], Stefan Linner [ctb], Javier Orraca-Deatcu [ctb]
Maintainer: Travis Gerke <travisgerke at gmail.com>
BugReports: https://github.com/tgerke/ducklake-r/issues
License: MIT + file LICENSE
URL: https://tgerke.github.io/ducklake-r/, https://github.com/tgerke/ducklake-r
NeedsCompilation: no
Language: en-US
Materials: README, NEWS
CRAN checks: ducklake results

Documentation:

Reference manual: ducklake.html , ducklake.pdf
Vignettes: Clinical Trial Data Lake with ducklake (source, R code)
Data Inlining (source, R code)
ducklake Cookbook (source, R code)
Modifying Tables with Version Control (source, R code)
Quack Remote Access (source, R code)
Storage and Backup Management (source, R code)
Time Travel Queries (source, R code)
Working with Transactions (source, R code)
Visualizing Your Lake (source, R code)

Downloads:

Package source: ducklake_0.6.0.tar.gz
Windows binaries: r-devel: not available, r-release: not available, r-oldrel: not available
macOS binaries: r-release (arm64): not available, r-oldrel (arm64): not available, r-release (x86_64): not available, r-oldrel (x86_64): not available

Linking:

Please use the canonical form https://CRAN.R-project.org/package=ducklake to link to this page.