MotherDuck
Last updated
Was this helpful?
Last updated
Was this helpful?
IP RESTRICTION
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.
Click Settings in the top menu bar of the Paradime interface to access Account Settings
In the left sidebar, click "Connections"
Click "Add New" next to the Bolt Schedules section
Select "MotherDuck" and fill out the corresponding fields.
In the Scheduler connection setup screen, you will need to fill in the form with the details of the connection you want to 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.
Below are list of fields and example to create a connection.
Profile Name
dbt-motherduck
Target
prod
Profile Configuration
Here is where you can define the path to the MotherDuck database where the dbt™️ will run.
MotherDuck access token
eyJhb.....0LXgyJFE695yrZx40UhAOF9JIFX8jNLf1WOAPO42Q
Schema
The default schema used to build dbt™️ objects at runtime.
dbt_prod
Threads
8
When using MotherDuck we will need to persist your MotherDuck service token for authentication.
To create an access token:
Go to the MotherDuck UI
In top left click on organization name and then Settings
Click + Create token
Specify a name for the token that you'll recognize (like "Paradime")
Choose whether you want the token to expire and then click on Create token
Copy the access token token to your clipboard by clicking on the copy icon
For additional supporting docs, check MotherDuck Key features, MotherDuck SQL reference and DuckDB SQL reference.
The profile name set in your dbt_project.yaml . See more .
The target name used to identify the connection. See more .
Additionally you will be able to configure any supported by listing them in the extensions
You can also set any additional via the settings field, including options that are supported in any loaded extensions.
The MotherDuck service token for authentication, see more .
This will be stored with the name motherduck_tokenin your .
The number of threads used in this connection. See more .
