DuckDB
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 Development Connection
You will be prompted to add a Development connection during the onboarding, or you can add more connections by going to account settings > connections, select Development Environment and enter the required fields.
Configuration for a DuckDB 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 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 |
For additional supporting docs see DuckDB SQL reference.
Explore data in your DuckDB 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.
HarlequinLast updated