Setting up ClickHouse Credentials for a Local Connection

You’ll need access to your ClickHouse credentials.

These credentials generally look like this:

1. Host URL or IP: localhost
2. Port: 9000
3. Username: default
4. Password: YourPassword123@
5. SSL: Off

Note

You may have to deactivate SSL if you’re connecting to your local service.

Setting up ClickHouse Credentials for a Cloud Connection

You’ll need access to your ClickHouse credentials.

These credentials generally look like this:

1. Host URL or IP: abc123xyz.us-east-1.aws.clickhouse.cloud
2. Port: 9440
3. Username: default
4. Password: YourPassword123@
5. SSL: On

Note

You may have to activate SSL if you’re connecting to your Cloud service.

1. Open the External Accounts Window

To provide your credentials to Coco Alemana, open the External Accounts... pane, under the top-level Coco Alemana menu.

2. Add a new External Account

Press the “Add Account…” button, or the plus button on the bottom-left hand side of the window.

Select the “ClickHouse” option.

3. Connect Credentials

Provide your credentials through one of the many options available.