Connect to ClickHouse Managed ClickHouse in Yandex.Cloud with JetBrains DataGrip, PyCharm

Question

How could I connect to ClickHouse in Managed instance on Yandex.Cloud with JetBrains DataGrip or PyCharm using HTTP API and clickhouse-driver JDBC?

There are no direct instructions on ClickHouse site or JetBrains site.

Answer 1

1. hit the + and select clickhouse

image1

2. SSH setup - its most likely at your click house server set up on a remote linux server. So you need to setup this up in order to connect to clickHouse

image2

3. Add you clickhouse address, port number and password

image3