Documentation

Start typing to search.

ClickHouse Data Source

Updated on Nov 17, 2026

Description

ClickHouse is a column-oriented database for analytical SQL workloads, available as a managed cloud service and a self-managed database.

Setup guide

Ask your ClickHouse administrator for a dedicated user with SELECT access only to the data you intend to query and readonly=1 configured in the user's database settings profile. The database user's grants and settings profile control what requests may do. Obtain the HTTPS hostname, port, database name, username and password from your service connection details. The endpoint must be reachable over the public internet with a valid TLS certificate.

In the authorization form, enter the hostname in Host, without https://, a port or a path. Enter the HTTPS Port supplied for your service; leaving it blank uses 443. Some services use 8443. Fill in Database, Username and Password, then click Connect.

Use the connection for read-only Discovery. Connections are private by default. The connection check verifies the endpoint and credentials; individual tables still require SELECT permission.

See the ClickHouse HTTP authentication documentation and query permissions for administrator setup.

Schema information

The source lists databases visible to your ClickHouse user as accounts, excluding system and information_schema regardless of letter case. Database visibility does not grant SELECT access to every table. There are no preset extraction datasets; Discovery queries determine the returned columns.

The Database field on your connection remains the default database for Discovery. Selecting an account does not change that default. Qualify table names in SQL when querying another database your user can access.

Limits

  • HTTPS only. Native and unencrypted HTTP connections are not supported.
  • Use the existing Discovery interface to send POST requests with SQL in the query parameter. ClickHouse enforces the connected user's database permissions and settings profile.
  • Use a dedicated SELECT-only database user with readonly=1 in its database profile.
  • The connection requests JSON output, a 30-second execution limit, 10,000 result rows and 10,000,000 result bytes, with an error when a result limit is exceeded. Your server profile may impose additional restrictions. Narrow the query or aggregate its result when necessary.

Release notes

See the official ClickHouse release notes.

Was this article helpful?

Questions? The Improvado team is always happy to help. Send us an email, contact your Customer Success Manager, or raise a request in the Improvado Service Desk.