Connections

Connections allow you to manage which Clickhouse server to connect to and the associated Clickhouse credentials. After creating a connection, the database and table information can be managed in a source.

A connection stores a few details about the Clickhouse connection:

1. Name: A name for the connection user to identify it later.
2. Host: The HTTP(S) connection string for the server including port
3. Username: The database user to authenticate as.
4. Password: The corresponding password to authenticate with.

User Permissions

The Clickhouse user only needs to be a readonly user with access to change the following settings:

• max_rows_to_read (at least up to 1 million)
• read_overflow_mode
• cancel_http_readonly_queries_on_client_close
• wait_end_of_query

By default the default user over the HTTP interface will have these permissions available but you may need to create a new user with these permissions if you are using a different user.

ClickHouse Cloud

If you are using ClickHouse Cloud, you can create a user by running the following SQL commands in the console:

CREATE USER hyperdx IDENTIFIED WITH sha256_password BY '<YOUR_PASSWORD>' SETTINGS PROFILE 'readonly';
GRANT sql_console_read_only TO hyperdx;

To find the host, navigate to the ClickHouse Cloud console and click the Connect button on the sidebar.