DuckDB

Integrate Duckdb with Paradime to enables deploying dbt™ in production with Bolt

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 the DinoAI agent environment connection

To add the DuckDB DinoAI agent environment connection, follow these instructions:

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 DinoAI Background Agent Environment section

4. Select DuckDB and fill out the corresponding fields.

Configuration for a DuckDB connection

In the DinoAI agent environment setup screen, fill in the form with the connection details DinoAI will 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

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 DinoAI agent environment connection. See more here.	dinoai	🏢 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.	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") }}'	👥 User level
Schema	The default schema used to build dbt™ objects during DinoAI background agent sessions.	dbt_dinoai	👥 User level
Threads	The number of threads used in this connection. See more here.	8	👥 User level

For additional supporting docs see the DuckDB SQL reference.