DuckDB & MotherDuck connection
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.
Add Production Connection
To add the DuckDB or MotherDuck Production connection, go to account settings > connections, select Production Environment and enter the required fields.
Configuration for a DuckDB Connection
In the Production 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 DuckDB 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
Below are list of fields and example to create a connection.
Field | Description | Example | Level |
---|---|---|---|
Profile Name | The profile name set in your |
| 🏢 Workspace level |
Target | The target name used to identify the connection. See more here. |
| 🏢 Workspace level |
Profile Configuration |
| 👥 User level | |
Schema | The default schema used to build dbt™️ objects at runtime. |
| 👥 User level |
Threads | The number of threads used in this connection. See more here. |
| 👥 User level |
Configuration for a MotherDuck Connection
In the Production 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.
Field Details
Below are list of fields and example to create a connection.
Field | Description | Example | Level |
---|---|---|---|
Profile Name | The profile name set in your |
| 🏢 Workspace level |
Target | The target name used to identify the connection. See more here. |
| 🏢 Workspace level |
Profile Configuration |
| 👥 User level | |
Schema | The default schema used to build dbt™️ objects at runtime. |
| 👥 User level |
Threads | The number of threads used in this connection. See more here. |
| 👥 User level |
Authenticating to MotherDuck
When using MotherDuck we will need to persist your MotherDuck service token for authentication.
Fetching the service token
To fetch your service token:
Go to the MotherDuck UI
In top right click on user profile and then
Settings
Copy the service token to your clipboard by clicking on "Copy token"
Storing the service token as a workspace environment variable
You can save the service token as motherduck_token
in your workspace environment variables in Paradime by navigating to your workspace settings.
For additional supporting docs, check MotherDuck Key features, MotherDuck SQL reference and DuckDB SQL reference.
Last updated