MotherDuck Store

Create a new database

To create a new database in MotherDuck, follow these steps:

1. Go to https://app.motherduck.com/home and log in to your MotherDuck account if you're not already logged in.
2. Look for the "Attached databases" section in the left sidebar.
3. Click on the + ("Add database") button.
4. Enter a name (e.g. meltano) for your database and click "Create database".
5. Copy the name of your database.

Create an access token

To create an access token for your MotherDuck database, follow these steps:

1. Go to https://app.motherduck.com/settings/tokens and log in to your MotherDuck account if you're not already logged in.
2. Click "Create token".
3. Enter a name and optional expiration date for your token and click "Create".
4. Copy the token and store it securely.

Configure Meltano

To configure your Meltano Workspace to use your MotherDuck database, follow these steps:

1. Add a new store to your Meltano Workspace using the motherduck store type.
2. Use md:<your-database> as the connection string, replacing <your-database> with the name of your database.
3. Paste in the access token you copied from the MotherDuck settings page.

BATCH ingestion

Taps that emit Arrow- or JSONL-encoded Singer BATCH messages are loaded natively by target-motherduck, with no configuration required. Metadata columns and hard delete aren't applied to BATCH-sourced records.

See Arrow BATCH Support for supported extractors and how to enable Arrow output on the tap.