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.