MotherDuck - Paradime

MotherDuck is a cloud data warehouse built on DuckDB. Connect it to Paradime to run dbt™ from the Code IDE, deploy production jobs with Bolt, and let the DinoAI background agent work against your MotherDuck database.

IP restrictionsAllow traffic from one of the Paradime IPs in your firewall, depending on the data location selected.See also: Paradime IP addresses.

Available in: Code IDE, Bolt, and Agent environments.

Add a connection

Click Settings in the top menu bar of the Paradime interface to access Workspace Settings.
In the left sidebar, click Environments.
Click Add New next to the section for the environment you are configuring:
- Code IDE for the Code IDE connection
- Bolt for the Bolt connection
- Agent for the Agent connection
Select MotherDuck and fill out the corresponding fields.

Configuration

In the connection setup screen, fill in the form with the details Paradime will use to run dbt™ models against a MotherDuck database. In this example you connect to s3 to read and write parquet files using an AWS access key and secret. These secrets can be stored in the user environment variable settings.

Field details

Field	Description	Example	Level
Profile Name	The profile name set in your `dbt_project.yaml`. See more here.	`dbt-motherduck`	Workspace level
Target	The target name used to identify the connection. See more here.	`dev`	Workspace level
Profile Configuration	Define the path to the MotherDuck database where dbt™ will run. Configure any supported DuckDB extensions by listing them in the `extensions` field. Set additional DuckDB configuration options via the `settings` field, including options supported by any loaded extensions.	See the example below.	User level
MotherDuck access token	The MotherDuck service token for authentication. See more here. This is stored with the name `motherduck_token` in your user environment variables.	`eyJhb.....0LXgyJFE695yrZx40UhAOF9JIFX8jNLf1WOAPO42Q`	User level
Schema	The default schema used to build dbt™ objects at runtime.	`dbt_john`	User level
Threads	The number of threads used in this connection. See more here.	`8`	User level

Example Profile Configuration:

extensions:
  - httpfs
  - parquet
path: md:jaffle_shop_dev
settings:
  s3_access_key_id: '{{ env_var("S3_ACCESS_KEY_ID") }}'
  s3_region: '{{ env_var("S3_REGION", "us-west-1") }}'
  s3_secret_access_key: '{{ env_var("S3_SECRET_ACCESS_KEY") }}'

For the Bolt connection, set the target to prod and the schema to dbt_prod. The MotherDuck access token is stored in your Bolt Environment Variables. For the Agent connection, set the target to dinoai and the schema to dbt_dinoai.

Authenticating to MotherDuck

When using MotherDuck, you need to create and persist a MotherDuck service token for authentication. To create an access token:

Go to the MotherDuck UI.
In the top left, click on your organization name and then Settings.
Click + Create token.
Specify a name for the token that you will recognize (like “Paradime”).
Choose whether you want the token to expire and then click Create token.
Copy the access token to your clipboard by clicking on the copy icon.

Check you are able to connect to MotherDuck

To test your connection to MotherDuck:

Launch the DuckDB CLI and connect to MotherDuck using the Paradime terminal by running the following command:

duckdb "md:"

Test your MotherDuck connection using the following command. It runs in the cloud to display a list of your MotherDuck databases.

show all databases;

For additional supporting docs, check MotherDuck key features, MotherDuck SQL reference, and DuckDB SQL reference.

Explore data in your MotherDuck database from Paradime

Paradime integrates with Harlequin out of the box, with no installation required. Check our integration guide on how you can query data directly from the Paradime terminal.

Harlequin

Optional connection attributes

Set additional profiles.yml attributes for this connection.

​Add a connection

​Configuration

​Field details

​Authenticating to MotherDuck

​Check you are able to connect to MotherDuck

​Explore data in your MotherDuck database from Paradime

Harlequin

​Related

Optional connection attributes

Add a connection

Configuration

Field details

Authenticating to MotherDuck

Check you are able to connect to MotherDuck

Explore data in your MotherDuck database from Paradime

Related