MotherDuck

MotherDuck

IP RESTRICTIONS

Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.

👉 See also: Paradime IP addresses.

Add the DinoAI agent environment connection

1. Click Settings in the top menu bar of the Paradime interface to access Account Settings

2. In the left sidebar, click Connections

3. Click Add New next to the DinoAI Background Agent Environment section

4. Select MotherDuck and fill out the corresponding fields.

Configuration for a MotherDuck connection

In the DinoAI agent environment setup screen, fill in the form with the connection details DinoAI will use to run dbt™ models against a MotherDuck database.

In this example we are connecting to s3 to read/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 DinoAI agent environment connection. See more here.	dinoai	🏢 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 loaded extensions.	extensions: - httpfs - parquet path: md:jaffle_shop_prod 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") }}'	👥 User level
MotherDuck access token	The MotherDuck service token used by the DinoAI agent for authentication. See more here. Stored as motherduck_token in your environment variables.	eyJhb.....0LXgyJFE695yrZx40UhAOF9JIFX8jNLf1WOAPO42Q
Schema	The default schema used to build dbt™ objects during DinoAI background agent sessions.	dbt_dinoai	👥 User level
Threads	The number of threads used in this connection. See more here.	8	👥 User level

Authenticating to MotherDuck

When using MotherDuck, you need to create and persist a MotherDuck service token for the DinoAI agent to authenticate.

To create an access token:

1. Go to the MotherDuck UI

2. In the top left, click on your organisation name and then Settings

3. Click + Create token

4. Specify a name for the token (e.g. "Paradime DinoAI")

5. Choose whether you want the token to expire and click Create token

6. Copy the access token to your clipboard

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