Skip to content

MotherDuck (Destination)

Loads data into MotherDuck.

Configuration

yaml
warehouse:
  kind: motherduck
  motherduck_token: ${MOTHERDUCK_TOKEN}
  database: my_database
  schema: main
FieldDefaultDescription
motherduck_token(required)MotherDuck token (or set MOTHERDUCK_TOKEN)
databaseDatabase name
schemaTarget schema

CLI

bash
skippr connect warehouse motherduck \
  --motherduck-token "$MOTHERDUCK_TOKEN" \
  --database my_database \
  --schema main
FlagDescription
--motherduck-token(required) MotherDuck token (or set MOTHERDUCK_TOKEN)
--databaseDatabase name
--schemaTarget schema (default: main)

CDC

MotherDuck supports CDC with DuckDB MERGE semantics. Skippr automatically creates _skippr_order_token columns and tombstone tables.

See CDC Destinations -- MotherDuck for details.