> ## Documentation Index
> Fetch the complete documentation index at: https://docs.paradime.io/llms.txt
> Use this file to discover all available pages before exploring further.
# MotherDuck
> Paradime DuckDB & MotherDuck: Connect DuckDB and MotherDuck with Paradime for dbt™ projects. Ensure seamless data integration.
export const Arcade = ({src, title}) =>
;
**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](https://docs.paradime.io/app-help/app-settings/ip-restrictions).
## Add Code IDE Connection
You will be prompted to add a Development connection during the onboarding, or you can add more connections by completing the following steps:
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 Code IDE section
4. Select "MotherDuck"
## Configuration for a MotherDuck Connection
In the Development 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](/products/settings/environment-variables/code-ide-env-variables).
Below are list of fields and example to create a connection.
| Field | Description | Example | Level |
| ----------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------ |
| Profile Name | The profile name set in your `dbt_project.yaml` . See more [here](https://docs.getdbt.com/docs/core/connect-data-platform/connection-profiles). | **`dbt-motherduck`** | 🏢 Workspace level |
| Target | The target name used to identify the connection. See more [here](https://docs.getdbt.com/reference/dbt-jinja-functions/target). | **`dev`** | 🏢 Workspace level |
| Profile Configuration | • Here is where you can define the path to the MotherDuck database where the dbt™️ will run.• Additionally you will be able to configure any supported [DuckDB extensions](https://duckdb.org/docs/extensions/overview) by listing them in the `extensions`• You can also set any additional [DuckDB configuration options](https://duckdb.org/docs/sql/configuration) via the `settings` field, including options that are supported in any loaded extensions. | `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") }}'` | 👥 User level |
| MotherDuck access token | The MotherDuck service token for authentication, see more [here](https://motherduck.com/docs/key-tasks/authenticating-to-motherduck/#authentication-using-an-access-token).This will be stored with the name `motherduck_token`in your [user environment variables](/products/settings/environment-variables/code-ide-env-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](https://docs.getdbt.com/docs/running-a-dbt-project/using-threads). | **`8`** | 👥 User level |
### Authenticating to MotherDuck
When using MotherDuck we will need to persist your MotherDuck service token for authentication.
To create an access token:
* Go to the [MotherDuck UI](https://app.motherduck.com/)
* 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
### Check you are able to connect to MotherDuck
To test you connection to MotherDuck:
1. To launch the DuckDB CLI and connect to MotherDuck using Paradime terminal by running the following command:
```bash theme={"system"}
duckdb "md:"
```
2. Test your MotherDuck connection using the following command. It will run in the cloud to display a list of your MotherDuck databases.
```bash theme={"system"}
show all databases;
```
For additional supporting docs, check [MotherDuck Key Features](https://motherduck.com/docs/category/key-tasks),[ MotherDuck SQL reference](https://motherduck.com/docs/category/motherduck-sql-reference) and [DuckDB SQL reference](https://motherduck.com/docs/category/duckdb-sql-reference)
## Explore data in your MotherDuck database from Paradime
Paradime integrates with Harlequin out of the box - no installation required. Check our integration guide on how you can query where you can query data directly from the Paradime Terminal.
## Related topics
- [MotherDuck](/products/settings/connections/scheduler-environment/motherduck.md)
- [Harlequin](/integrations/harlequin.md)
- [DuckDB](/products/settings/connections/development-environment/duckdb.md)
- [Scheduler environment](/products/settings/connections/scheduler-environment/index.md)