MotherDuck (Source)

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy

Reads from a MotherDuck database.

Configuration

source:
  kind: motherduck_source
  motherduck_token: ${MOTHERDUCK_TOKEN}
  database: my_database
  tables:
    - raw.events

Field	Default	Description
motherduck_token	(required)	MotherDuck token (or set MOTHERDUCK_TOKEN)
database		Database name
tables	(optional)	Tables to extract
query		Custom SQL query (overrides tables)

CLI

skippr connect source motherduck-source \
  --motherduck-token "$MOTHERDUCK_TOKEN" \
  --database my_db \
  --tables main.customers,main.orders

Flag	Description
--motherduck-token	(required) MotherDuck token (or set MOTHERDUCK_TOKEN)
--database	Database name
--tables	Comma-separated list of tables
--query	SQL query instead of table list

Authentication

For security best practices, we strongly advise against storing the token in skippr.yaml. Use environment variable interpolation instead: replace the motherduck_token value with your own ${ENV_VAR} reference.

The relevant part of skippr.yaml looks like this:

source:
  kind: motherduck_source
  motherduck_token: ${MOTHERDUCK_TOKEN}

Set the env var before running skippr:

macOS / Linux

export MOTHERDUCK_TOKEN="md:..."

Windows PowerShell

$env:MOTHERDUCK_TOKEN = "md:..."

Windows Command Prompt

set MOTHERDUCK_TOKEN=md:...

export MOTHERDUCK_TOKEN="md:..."

Permissions or Network Requirements

The token must have access to the selected MotherDuck database and tables. The machine running skippr also needs outbound network access to MotherDuck.

Troubleshooting

Symptom	Fix
authentication failed	Verify MOTHERDUCK_TOKEN and confirm the token still has access to the selected database.
tables not found	Check the database name and table list or query.

Next steps

• Pair this source with a destination from Destination Connectors.
• See How It Works for the end-to-end pipeline flow.

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy