MotherDuck

Connect to a MotherDuck database

Setup

The following credentials keys are accepted:

• database (required) -> The motherduck database name

• motherduck_token (required) -> The service token. See here for instructions on getting it.

• schema (optional) -> The default schema to use.

• duckdb_version (optional) -> The CLI version of DuckDB to use. You can also specify the env. variable DUCKDB_VERSION.

• read_only (optional) -> Whether to open the connection in readonly mode. Accepts true or false. Default is false.

• interactive (optional) -> Whether to communicate to the DuckDB CLI via interactive mode instead of reopening the connection each time. Accepts true or false. Default is true.

Here is an example of setting a connection named MOTHERDUCK:

export MOTHERDUCK='motherduck://my_db?motherduck_token=xxxxxxxxxxxx'

Potential Issue

If you have a .duckdbrc file, which runs commands whenever the DuckDB CLI is invoked, this may interfere with normal dbNet querying. If you are facing weird issues and have this file, try again after deleting it.