MotherDuck
Connect & Ingest data from / to a MotherDuck database
Setup
The following credentials keys are accepted:
database
(required) -> The motherduck database namemotherduck_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. variableDUCKDB_VERSION
.read_only
(optional) -> Whether to open the connection inreadonly
mode. Acceptstrue
orfalse
. Default isfalse
.interactive
(optional) -> Whether to communicate to the DuckDB CLI via interactive mode instead of reopening the connection each time. Acceptstrue
orfalse
. Default istrue
.
Using sling conns
sling conns
Here are examples of setting a connection named MOTHERDUCK
. We must provide the type=motherduck
property:
Environment Variable
Sling Env File YAML
See here to learn more about the sling env.yaml
file.
Specifying a DuckDB version
If you would like to use a specific DuckDB version, you can specify this way:
If you are facing issues connecting, please reach out to us at support@slingdata.io, on discord or open a Github Issue here.
Potential Issue
If you have a .duckdbrc
file, which runs commands whenever the DuckDB CLI is invoked, this may interfere with normal Sling operation. If you are facing weird issues and have this file, try again after deleting it.
Last updated