DuckDB - Paradime

DuckDB is an in-process analytical database for storing and querying your data. Connect it to Paradime to run dbt™ from the Code IDE, deploy production jobs with Bolt, and let the DinoAI background agent work against your database.

Available in: Code IDE, Bolt, and Agent environments.

Add a connection

Click Settings in the top menu bar of the Paradime interface to access Workspace Settings.
In the left sidebar, click Environments.
Click Add New next to the section for the environment you are configuring:
- Code IDE for the Code IDE connection
- Bolt for the Bolt connection
- Agent for the Agent connection
Select DuckDB and fill out the corresponding fields.

Configuration

In the connection setup screen, 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 you connect to s3 to read and 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 the fields and examples to create a connection.

Field	Description	Example	Level
Profile Name	The profile name set in your `dbt_project.yaml`. See more here.	`dbt-duckdb`	Workspace level
Target	The target name used to identify the connection. See more here.	`dev`	Workspace level
Profile Configuration	Define the path to the DuckDB database where dbt™ will run. Configure any supported DuckDB extensions by listing them in the `extensions` field. Set additional DuckDB configuration options via the `settings` field, including options supported by loaded extensions.	See the example below.	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.	`8`	User level

Example profile configuration:

extensions:
  - httpfs
  - parquet
path: ./dbt.duckdb
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") }}'

For additional supporting docs see the DuckDB SQL reference.

Explore data in your DuckDB database from Paradime

Paradime integrates with Harlequin out of the box, with no installation required. Check our integration guide to see how you can query data directly from the Paradime terminal.

Harlequin

Optional connection attributes

Set additional profiles.yml attributes for this connection.

​Add a connection

​Configuration

​Field details

​Explore data in your DuckDB database from Paradime

Harlequin

​Related

Optional connection attributes

Add a connection

Configuration

Field details

Explore data in your DuckDB database from Paradime

Related