ClickHouse

ClickHouse#

  • Official client driver with clickhouse-rs.

  • Currently only support HTTP driver.

  • Another way to connect to ClickHouse is through MySQL.

ClickHouse Connection#

Hint

Adding protocol=https to connection uri parameter use SSL connection. Example: postgresql://username:password@host:port/db?protocol=https.

import connectorx as cx
conn = 'clickhouse://username:password@server:port/database'    # connection token
query = 'SELECT * FROM table'                                   # query string
cx.read_sql(conn, query)                                        # read data from ClickHouse
Contents