Back to source list
Official
Premium
ClickHouse source integration documentation
Sync from ClickHouse to any destination
Publisher
cloudquery
Latest version
v1.2.28
Type
Source
Platforms
Date Published
Loading plugin documentation
Sync from ClickHouse to any destination
Publisher
cloudquery
Latest version
v1.2.28
Type
Source
Platforms
Date Published
Loading plugin documentation
We use tracking cookies to understand how you use the product and help us improve it. Please accept cookies to help us improve. You can always opt out later via the link in the footer.
24.2
kind: source
spec:
name: "clickhouse"
path: "cloudquery/clickhouse"
registry: "cloudquery"
version: "v1.2.28"
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: "v1.2.28"
tables: ["*"]
spec:
connection_string: "clickhouse://${CH_USER}:${CH_PASSWORD}@localhost:9000/${CH_DATABASE}?debug=true"