motherduck0.2.0 package

Utilities for Managing a 'Motherduck' Database

alter_table_schema

Move Tables from One Schema to Another

cd

Change Active Database and Schema

cli_create_obj

Database, Schema, and Table Creator

cli_delete_obj

CLI print deleted objects

cli_show_db

Catalog Report Generator

cli_show_user

User Information Report

configure_md_user_settings

Configure a MotherDuck user's settings

connect_to_motherduck

Create connection to motherduck

convert_table_to_sql_id

Convert Table Metadata to SQL Identifiers

copy_tables_to_new_location

Copy Tables to a New Database/Schema

create_database

Create (If Not Exists) and Switch to a Database

create_if_not_exists_share

Create a MotherDuck database share if it does not exist

create_md_access_token

Create a MotherDuck access token

create_md_user

Create a new MotherDuck user

create_or_replace_share

Create or replace a MotherDuck database share

create_schema

Create a Schema in a Database if It Does Not Exist

create_table_dbi

Create a Database Table from a DBI Object

create_table_tbl

Overwrite or Append a Local Tibble to a Database Table

create_table

Create or Append a Table from a Tibble or DBI-Backed Table

delete_and_create_schema

Drop and Recreate a Schema in a MotherDuck / DuckDB Database

delete_database

Drop a Database

delete_md_access_token

Delete a MotherDuck user's access token

delete_md_user

Delete a MotherDuck user

delete_schema

Drop a Schema from a Database

delete_table

Drop a Table

describe_share

Describe a MotherDuck share

drop_share

Drop a MotherDuck share

install_extensions

Install DuckDB/MotherDuck Extensions

launch_ui

Launch the DuckDB UI in your browser

list_all_databases

List Databases Visible to the Connection

list_all_tables

List All Tables Visible to the Connection

list_current_schemas

List Schemas in the Current Database

list_current_tables

List Tables in the Current Database and Schema

list_extensions

List MotherDuck/DuckDB Extensions

list_fns

List Database Functions (DuckDB/MotherDuck)

list_md_active_accounts

List active MotherDuck accounts

list_md_user_instance

List a MotherDuck user's instance settings

list_md_user_tokens

List a MotherDuck user's tokens

list_owned_shares

List all shares owned by the current user

list_setting

List Database Settings

list_shared_with_me_shares

List all shares shared with the current user

list_shares

List MotherDuck Shares

load_extensions

Load and Install DuckDB/MotherDuck Extensions

pwd

Print Current MotherDuck Database Context

read_csv

Read a CSV file into a DuckDB/MotherDuck table

read_excel

Read an Excel file into a DuckDB/MotherDuck table

show_current_user

Show current database user

show_motherduck_token

Show Your MotherDuck Token

summary

Summarize a Lazy DBI Table

upload_database_to_md

Upload a Local Database to MotherDuck

validate_and_print_database_loction

validate and Pprint your database location

validate_con

Validate connection is DuckDB

validate_extension_install_status

Validate Installed MotherDuck/DuckDB Extensions

validate_extension_load_status

Validate Loaded MotherDuck/DuckDB Extensions

validate_md_connection_status

Validate Mother Duck Connection Status

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/>).