Clickhouse
ClickHouse is an open-source column-oriented database management system that enables high-performance real-time data analysis. As a development environment in Paradime, ClickHouse enables dbt™️ development from Paradime's Code IDE.
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.
Setup Instructions
Click the gear Icon (⚙️) on the top right of the Paradime interface to access Account Settings
In the left sidebar, click "Connections"
Click "Add New" next to the Code IDE section
Select "ClickHouse"
In the Profile Configuration field, add at least these required parameters. For additional configuration options, see the Profile Fields Reference section below:
After adding the configuration, ensure it's properly formatted using a YAML formatter like YAML Formatter.
Provide a dbt™ Profile Name (This should match with the profile name set in your
dbt_project.yml
).In the Target field, enter "dev". This is the default target your dbt project will use for development work.
The Threads value is pre-configured to 1, but you can adjust this number to specify how many parallel operations your dbt project can run.
Example Profile Configuration
Profile Fields Reference
schema
ClickHouse database name for models. This is 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
❌
Last updated