Skip to main content

MotherDuck

IP RESTRICTIONSMake 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

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.