Package: motherduck 0.2.4

motherduck: Utilities for Managing a 'Motherduck' Database

Provides helper functions, metadata utilities, and workflows for administering and managing 'DuckDB' databases on the 'MotherDuck' cloud platform. Some features require a 'MotherDuck' account (<https://motherduck.com/>). Note: Windows is not supported; use 'WSL' (Windows Subsystem for Linux) instead (<https://motherduck.com/docs/integrations/language-apis-and-drivers/r/>).

Authors:Alejandro Hagan [aut, cre]

motherduck_0.2.4.tar.gz
motherduck_0.2.4.zip(r-4.7)motherduck_0.2.4.zip(r-4.6)motherduck_0.2.4.zip(r-4.5)
motherduck_0.2.4.tgz(r-4.6-any)motherduck_0.2.4.tgz(r-4.5-any)
motherduck_0.2.4.tar.gz(r-4.7-any)motherduck_0.2.4.tar.gz(r-4.6-any)
motherduck_0.2.4.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
motherduck/json (API)

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

Bug tracker:https://codeberg.org/usrbinr/motherduck

Datasets:

On CRAN:

Conda:

3.74 score 1 stars 2 scripts 495 downloads 50 exports 36 dependencies

Last updated from:fe5e4dd6d8. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK150
source / vignettesOK173
linux-release-x86_64OK155
macos-release-arm64OK145
macos-oldrel-arm64OK148
windows-develOK97
windows-releaseOK102
windows-oldrelOK1710
wasm-releaseOK131

Exports:alter_table_schemacdconfigure_md_user_settingsconnect_to_motherduckcopy_tables_to_new_locationcreate_databasecreate_if_not_exists_sharecreate_md_access_tokencreate_md_usercreate_or_replace_sharecreate_r2_secretcreate_s3_secretcreate_schemacreate_tabledelete_and_create_schemadelete_databasedelete_md_access_tokendelete_md_userdelete_schemadelete_tabledescribe_sharedrop_shareinstall_extensionslaunch_uilist_all_databaseslist_all_tableslist_current_schemaslist_current_tableslist_extensionslist_fnslist_md_active_accountslist_md_user_instancelist_md_user_tokenslist_owned_shareslist_settinglist_shared_with_me_shareslist_sharesload_extensionspwdread_csvread_excelshow_current_usershow_information_schemashow_motherduck_tokenupload_database_to_mdvalidate_database_existsvalidate_database_schema_existsvalidate_extension_install_statusvalidate_extension_load_statusvalidate_md_connection_status

Dependencies:askpassassertthatblobclicpp11curlDBIdbplyrdplyrduckdbgenericsgluehmshttr2janitorlifecyclelubridatemagrittropensslpillarpkgconfigpurrrR6rappdirsrlangsnakecasestringistringrsystibbletidyrtidyselecttimechangeutf8vctrswithr

Readme and manuals

Help Manual

Help pageTopics
Move Tables from One Schema to Anotheralter_table_schema
Change Active Database and Schemacd
DuckDB CSV read configuration (config_csv)config_csv
DuckDB runtime database configuration (config_db)config_db
DuckDB Excel read configuration (config_excel)config_excel
DuckDB Parquet read configuration (config_parquet)config_parquet
Configure a MotherDuck user's settingsconfigure_md_user_settings
Create connection to motherduckconnect_to_motherduck
Copy Tables to a New Database/Schemacopy_tables_to_new_location
Create (If Not Exists) and Switch to a Databasecreate_database
Create a MotherDuck database share if it does not existcreate_if_not_exists_share
Create a MotherDuck access tokencreate_md_access_token
Create a new MotherDuck usercreate_md_user
Create or replace a MotherDuck database sharecreate_or_replace_share
Register a Cloudflare R2 secret on a connectioncreate_r2_secret
Register a generic S3 (S3-compatible) secret on a connectioncreate_s3_secret
Create a Schema in a Database if It Does Not Existcreate_schema
Create or Append a Table from a Tibble or DBI-Backed Tablecreate_table
Drop and Recreate a Schema in a MotherDuck / DuckDB Databasedelete_and_create_schema
Drop a Databasedelete_database
Delete a MotherDuck user's access tokendelete_md_access_token
Delete a MotherDuck userdelete_md_user
Drop a Schema from a Databasedelete_schema
Drop a Tabledelete_table
Describe a MotherDuck sharedescribe_share
Drop a MotherDuck sharedrop_share
Install DuckDB/MotherDuck Extensionsinstall_extensions
Launch the DuckDB UI in your browserlaunch_ui
List Databases Visible to the Connectionlist_all_databases
List All Tables Visible to the Connectionlist_all_tables
List Schemas in the Current Databaselist_current_schemas
List Tables in the Current Database and Schemalist_current_tables
List MotherDuck/DuckDB Extensionslist_extensions
List Database Functions (DuckDB/MotherDuck)list_fns
List active MotherDuck accountslist_md_active_accounts
List a MotherDuck user's instance settingslist_md_user_instance
List a MotherDuck user's tokenslist_md_user_tokens
List all shares owned by the current userlist_owned_shares
List Database Settingslist_setting
List all shares shared with the current userlist_shared_with_me_shares
List MotherDuck Shareslist_shares
Load and Install DuckDB/MotherDuck Extensionsload_extensions
Print Current MotherDuck Database Contextpwd
Read a CSV file into a DuckDB/MotherDuck tableread_csv
Read an Excel file into a DuckDB/MotherDuck tableread_excel
Show current database usershow_current_user
Show Information Schema Schemasshow_information_schema
Show Your MotherDuck Tokenshow_motherduck_token
Summarize a Lazy DBI Tablesummary summary.tbl_lazy
Upload a Local Database to MotherDuckupload_database_to_md
Validate connection is DuckDBvalidate_con
Check if a Database Existsvalidate_database_exists
Check if a Schema Exists in a Databasevalidate_database_schema_exists
Validate Installed MotherDuck/DuckDB Extensionsvalidate_extension_install_status
Validate Loaded MotherDuck/DuckDB Extensionsvalidate_extension_load_status
Validate Mother Duck Connection Statusvalidate_md_connection_status