Skip to main content
Version: 1.1.0 (latest)

destinations.impl.clickhouse.configuration

ClickHouseCredentials Objects

@configspec(init=False)
class ClickHouseCredentials(ConnectionStringCredentials)

[view_source]

host

Host with running ClickHouse server.

port

Native port ClickHouse server is bound to. Defaults to 9440.

http_port

HTTP Port to connect to ClickHouse server's HTTP interface. The HTTP port is needed for non-staging pipelines. Defaults to 8123.

username

Database user. Defaults to 'default'.

database

database connect to. Defaults to 'default'.

secure

Enables TLS encryption when connecting to ClickHouse Server. 0 means no encryption, 1 means encrypted.

connect_timeout

Timeout for establishing connection. Defaults to 10 seconds.

send_receive_timeout

Timeout for sending and receiving data. Defaults to 300 seconds.

gcp_access_key_id

When loading from a gcp bucket, you need to provide gcp interoperable keys

gcp_secret_access_key

When loading from a gcp bucket, you need to provide gcp interoperable keys

ClickHouseClientConfiguration Objects

@configspec
class ClickHouseClientConfiguration(
DestinationClientDwhWithStagingConfiguration)

[view_source]

dataset_table_separator

Separator for dataset table names, defaults to '', i.e. 'database.datasettable'.

table_engine_type

The default table engine to use. Defaults to 'merge_tree'. Other implemented options are 'shared_merge_tree' and 'replicated_merge_tree'.

dataset_sentinel_table_name

Special table to mark dataset as existing

fingerprint

def fingerprint() -> str

[view_source]

Returns a fingerprint of the host part of a connection string.

This demo works on codespaces. Codespaces is a development environment available for free to anyone with a Github account. You'll be asked to fork the demo repository and from there the README guides you with further steps.
The demo uses the Continue VSCode extension.

Off to codespaces!

DHelp

Ask a question

Welcome to "Codex Central", your next-gen help center, driven by OpenAI's GPT-4 model. It's more than just a forum or a FAQ hub – it's a dynamic knowledge base where coders can find AI-assisted solutions to their pressing problems. With GPT-4's powerful comprehension and predictive abilities, Codex Central provides instantaneous issue resolution, insightful debugging, and personalized guidance. Get your code running smoothly with the unparalleled support at Codex Central - coding help reimagined with AI prowess.