Skip to main content
You need to make sure the Less IPs are whitelisted from your ClickHouse database. You can find the IPs here.

​
Setup

To connect to a ClickHouse database, the easiest is to find your connection string. You can find this by Clicking “Connect” in your Clickhouse environment. Then download the connection string. It should look something like this: 
<config>
    <connections_credentials>
        <connection>
            <name>default</name>
            <hostname>hostname</hostname>
            <port>8443</port>
            <secure>1</secure>
            <user>default</user>
            <password>password</password>
            <!-- <history_file></history_file> -->
            <!-- <history_max_entries></history_max_entries> -->
            <!-- <accept-invalid-certificate>false</accept-invalid-certificate> -->
            <!-- <prompt></prompt> -->
        </connection>
    </connections_credentials>
</config>
Save those values for the steps below.
1

Account

The first step is input server address, port (almost always 8443), and the name of the database you want to extract data from.
2

Credentials

Input your username and password from the connection string you found above.
3

SSH

We recommend trying without SSH first if you’re in doubt. If you are using a database that requires SSH, you can use the SSH connection method.Input your SSH host, SSH port, SSH username, and SSH password from the database’s settings.You can also choose to use a private key instead of a password. Just check the “I want to use an SSH Key” checkbox and upload your private key file.
4

Tables

Once you have input your account and credential information, you need to validate your connection on the Tables tab. Click “Connect” to continue. Note that we do not change error message coming from the database.If you can successfully connect to the database, you can now select the tables you want to extract data from. Alternatively, you can switch to the “query-based” tab to write one or more SQL queries to extract data from the database.
You can select either Table or Query-based. You cannot select both.