Overview
ClickHouse is an open-source column-oriented DBMS for online analytical processing that allows users to generate analytical reports using SQL queries in real-time.Authentication
This provider requires authentication.- username: Clickhouse username (required: True, sensitive: False)
- password: Clickhouse password (required: True, sensitive: True)
- host: Clickhouse hostname (required: True, sensitive: False)
- port: Clickhouse port (required: True, sensitive: False)
- database: Clickhouse database name (required: False, sensitive: False)
- protocol: Protocol (‘clickhouses’ for SSL, ‘clickhouse’ for no SSL, ‘http’ or ‘https’) (required: True, sensitive: False)
- verify: Enable SSL verification (required: False, sensitive: False)
- connect_to_server: The user can connect to the server (mandatory)
In workflows
This provider can be used in workflows. As “step” to query data, example:Connecting with the ClickHouse provider
- Obtain the required authentication parameters.
- Add ClickHouse provider to your keep account and configure with the above authentication parameters.