ClickHouse Data Source
Connect a dedicated database user for read-only SELECT queries. Access follows your ClickHouse permissions, and connections are private by default.
SELECT 1 A successful check returns 1. Your database user controls which tables you can query.
Connect a read-only ClickHouse user
Use your service's HTTPS host and port, database, username and password. The connection checks access before you run a query. Use a dedicated user with SELECT permission only on the intended data.
Query the data your user can read
Use POST SQL requests through the existing Discovery interface. The source lists visible databases as accounts, excluding system and information_schema. The connection database remains the Discovery default. No preset extraction datasets are included.
ClickHouse source questions
Does this source change my ClickHouse data?
Use a dedicated SELECT-only ClickHouse user with readonly=1 configured in its database settings profile. ClickHouse enforces the connected user's grants and profile; those database permissions determine what requests can do.
Which connection protocols are supported?
HTTPS is supported, commonly on port 443 or 8443. The source does not use the native ClickHouse protocol or unencrypted HTTP.
Are scheduled extraction reports included?
This connection provides read-only Discovery and lists visible databases as accounts. It does not include preset extraction datasets.
What are the query limits?
The connection requests JSON output, a 30-second execution limit, 10,000 result rows and 10,000,000 result bytes. Your server profile may impose additional restrictions. ClickHouse enforces the connected user's permissions and settings profile; use a SELECT-only user with readonly=1 configured by your administrator.
Prepare your ClickHouse connection
Get the HTTPS endpoint and a dedicated read-only database user from your administrator.
Open the setup guide