Skip to content

motherduck

Utilities for Managing a 'Motherduck' Database

v0.2.1 · Dec 22, 2025 · MIT + file LICENSE

Description

Provides helper functions, metadata utilities, and workflows for administering and managing databases on the 'Motherduck' cloud platform. Some features require a 'Motherduck' account (<https://motherduck.com/>).

Downloads

713

Last 30 days

5164th

1.8K

Last 90 days

2.2K

Last year

Trend: +25.8% (30d vs prior 30d)

CRAN Check Status

1 ERROR
13 OK
Show all 14 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang ERROR
r-devel-linux-x86_64-fedora-gcc OK
r-devel-macos-arm64 OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK
Check details (1 non-OK)
ERROR r-devel-linux-x86_64-fedora-clang

tests

Running ‘testthat.R’ [26s/37s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional test configuration?
  > # Learn more about the roles of various files in:
  > # * https://r-pkgs.org/testing-design.html#sec-tests-files-overview
  > # * https://testthat.r-lib.org/articles/special-files.html
  > 
  > library(testthat)
  > library(motherduck)
  > library(DBI)
  > library(openxlsx)
  > 
  > test_check("motherduck")
  
  -- Status: ---------------------------------------------------------------------
  
  -- Connection Status Report: --
  
  ! You are not connected to MotherDuck
  
  -- User Report: --
  
  * User Name: "duckdb"
  * Role: "duckdb"
  
  -- Catalog Report: --
  
  * Current Database: "memory"
  * Current Schema: "main"
  * # Total Catalogs you have access to: 3
  * # Total Tables you have access to: 0
  * # Tot
...[truncated]...
"
  Saving _problems/test-motherduck-405.R
  [ FAIL 1 | WARN 0 | SKIP 1 | PASS 22 ]
  
  ══ Skipped tests (1) ═══════════════════════════════════════════════════════════
  • empty test (1): 'test-motherduck.R:259:3'
  
  ══ Failed tests ════════════════════════════════════════════════════════════════
  ── Error ('test-motherduck.R:405:7'): read_excel / successfully reads a excel and copies table to database ──
  <purrr_error_indexed/rlang_error/error/condition>
  Error in `purrr::map(ext_lst$valid_ext, function(x) DBI::dbExecute(.con, glue::glue("LOAD {x};")))`: i In index: 1.
  Caused by error in `duckdb_result()`:
  ! Invalid Error: Invalid Input Error: Initialization function "excel_duckdb_cpp_init" from file "/data/gannet/ripley/.local/share/R/duckdb/extensions/v1.5.1/linux_amd64/excel.duckdb_extension" threw an exception: "Missing DB manager"
  i Context: rapi_execute
  i Error type: INVALID
  
  [ FAIL 1 | WARN 0 | SKIP 1 | PASS 22 ]
  Error:
  ! Test failures.
  Execution halted

Check History

ERROR 13 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Mar 10, 2026
ERROR r-devel-linux-x86_64-fedora-clang

tests

Running ‘testthat.R’ [26s/37s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional 
...[truncated]...
share/R/duckdb/extensions/v1.4.4/linux_amd64/excel.duckdb_extension" threw an exception: "Missing DB manager"
  i Context: rapi_execute
  i Error type: INVALID
  
  [ FAIL 1 | WARN 0 | SKIP 1 | PASS 22 ]
  Error:
  ! Test failures.
  Execution halted

Dependency Network

Dependencies Reverse dependencies DBI assertthat cli dbplyr dplyr duckdb glue purrr stringr httr2 rlang janitor tibble motherduck

Version History

new 0.2.1 Mar 10, 2026
updated 0.2.1 ← 0.2.0 diff Dec 21, 2025
new 0.2.0 Dec 1, 2025