destinations.impl.clickhouse.configuration
ClickHouseCredentials Objects
@configspec(init=False)
class ClickHouseCredentials(ConnectionStringCredentials)
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)
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
Returns a fingerprint of the host part of a connection string.