ClickHouse - Paradime

ClickHouse is an open-source column-oriented database management system that enables high-performance real-time data analysis. 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.

IP restrictionsMake sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.See also: Paradime IP addresses.

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 ClickHouse.
In the Profile Configuration field, add at least the required parameters. For additional configuration options, see the Profile fields reference section below.
Provide a dbt™ Profile Name (this should match the profile name set in your dbt_project.yml).
In the Target field, enter the target for the environment you are configuring: dev for Code IDE, prod for Bolt, or dinoai for the Agent.
The Threads value is pre-configured to 1, but you can adjust this to specify how many parallel operations your dbt™ project can run.

After adding the configuration, ensure it’s properly formatted using a YAML formatter like YAML Formatter.

Profile configuration

schema: dbt_transformations                    # Database
host: clickhouse.internal.company.com          # Internal hostname
port: 9000                                     # Native protocol port
user: dbt_user                                 # Database user
password: clickhouse_pass_456                  # User password
secure: false                                  # Internal traffic
driver: native                                 # Native protocol

Profile fields reference

Field	Description	Default Value	Required
`schema`	ClickHouse database name for models. Configured in the UI “Schema” field.	None	✅
`driver`	Connection protocol (http or native)	`http`	❌
`host`	ClickHouse server hostname	`localhost`	❌
`port`	Connection port number	http: `8123/8443` · native: `9000/9440`	❌
`user`	Database user name	None	✅
`password`	Database user password	None	✅
`cluster`	Name of ClickHouse cluster for distributed operations	None	❌
`verify`	Whether to validate TLS certificate	`True`	❌
`secure`	Enable TLS/HTTPS connections	`False`	❌
`retries`	Number of connection retry attempts	None	❌
`compression`	Type of data compression to use	`False`	❌
`connect_timeout`	Seconds to wait for connection	`10`	❌
`send_receive_timeout`	Seconds to wait for data transfer	`300` (5 minutes)	❌
`cluster_mode`	Settings for replicated databases	`False`	❌
`use_lw_deletes`	Enable lightweight delete operations	`False`	❌
`check_exchange`	Check support for atomic table exchange	`True`	❌
`local_suffix`	Suffix for local table names	`_local`	❌
`local_db_prefix`	Prefix for local database names	None	❌
`allow_automatic_deduplication`	Enable automatic data deduplication	`False`	❌

Optional connection attributes

Set additional profiles.yml attributes for this connection.

​Add a connection

​Profile configuration

​Profile fields reference

​Related

Optional connection attributes

Add a connection

Profile configuration

Profile fields reference

Related