DuckDB

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

circle-exclamation

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 settingsarrow-up-right.

Field details

Field
Description
Example
Level

Profile Name

The profile name set in your dbt_project.yaml. See more herearrow-up-right.

dbt-duckdb

🏢 Workspace level

Target

The target name used to identify the DinoAI agent environment connection. See more herearrow-up-right.

dinoai

🏢 Workspace level

Profile Configuration

👥 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 herearrow-up-right.

8

👥 User level
circle-info

For additional supporting docs see the DuckDB SQL referencearrow-up-right.

Last updated

Was this helpful?