MotherDuck

MotherDuck is a managed cloud service built on DuckDB, designed for fast analytics and data processing in the cloud.

omniload supports MotherDuck as both a source and destination.

URI format

The URI format for MotherDuck is as follows:

motherduck://<database-name>?token=<your-token>

Alternatively, you can use the md:// scheme:

md://<database-name>?token=<your-token>

URI parameters:

  • database-name: the name of your MotherDuck database (optional, can be omitted for default connection)

  • token: your MotherDuck authentication token

Authentication

Using Token in URI

Include the token directly in the URI:

md://<database-name>?token=<your-token>

Connection without Database Name

If you want to connect without specifying a specific database:

md://?token=<your-token>

Getting Your Token

  1. Go to the MotherDuck UI

  2. Click on your organization name in the top left and select “Settings”

  3. Click “+ Create token”

  4. Specify a name for the token

  5. Choose between Read/Write or Read Scaling token type

  6. Set expiration if desired and click “Create token”

  7. Copy the generated token

The same URI structure can be used both for sources and destinations. You can read more about MotherDuck’s connection options in their official documentation.