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.