Back to source list
Official
Premium
ClickHouse source integration documentation
Sync from ClickHouse to any destination
Publisher
cloudquery
Latest version
v2.1.9
Type
Source
Platforms
Date Published
Loading plugin documentation
Sync from ClickHouse to any destination
Publisher
cloudquery
Latest version
v2.1.9
Type
Source
Platforms
Date Published
Loading plugin documentation
CloudQuery's use of cookies
We use tracking cookies to understand how you use the product and help us improve it. Your consent is required before we can enable these cookies. You can opt out via the link in the footer.
24.2kind: source
spec:
name: "clickhouse"
path: "cloudquery/clickhouse"
registry: "cloudquery"
version: "v2.1.9"
destinations: ["postgresql"]
tables: ["*"]
# Learn more about the configuration options at https://cql.ink/clickhouse_source
spec:
connection_string: "clickhouse://${CH_USER}:${CH_PASSWORD}@localhost:9000/${CH_DATABASE}"
# Optional parameters
# ca_cert: ""
# rows_per_record: 500
# concurrency: 100
# table_options:
# test_table:
# incremental_column: "created_at"
localhost:9000.
It expects CH_USER, CH_PASSWORD and CH_DATABASE environment variables to be set.
The (top level) spec section is described in the Source Spec Reference.connection_string (string) (required)ca_cert (string) (optional) (default: not used)rows_per_record (integer) (optional) (default: 500)concurrency (integer) (optional) (default: 100)table_options (object) (optional) (default: not used)secure=true parameter, username to default, and the port to 9440.
Use a connection string similar to: connection_string: "clickhouse://default:${CH_PASSWORD}@<your-server-id>.<region>.<provider>.clickhouse.cloud:9440/${CH_DATABASE}?secure=true"
debug=true option to connection_string.
See SDK documentation for more details.kind: source
spec:
name: "clickhouse"
path: "cloudquery/clickhouse"
registry: "cloudquery"
version: "v2.1.9"
tables: ["*"]
spec:
connection_string: "clickhouse://${CH_USER}:${CH_PASSWORD}@localhost:9000/${CH_DATABASE}?debug=true"