Clickhouse

Install dependencies for Ibis’s Clickhouse dialect(minimal supported version is 0.1.3):

pip install 'ibis-framework[clickhouse]'

Create a client by passing in database connection parameters such as host, port, database, and user to ibis.clickhouse.connect():

con = ibis.clickhouse.connect(host='clickhouse', port=9000)

API

The ClickHouse client is accessible through the ibis.clickhouse namespace.

Use ibis.clickhouse.connect to create a client.

Backend.connect([host, port, database, ...])	Create an ClickhouseClient for use with Ibis.
ClickhouseClient.close()	Close Clickhouse connection and drop any temporary objects
ClickhouseClient.exists_table(name[, database])	Determine if the indicated table or view exists
ClickhouseClient.exists_database(name)
ClickhouseClient.get_schema(table_name[, ...])	Return a Schema object for the indicated table and database
ClickhouseClient.list_databases([like])
ClickhouseClient.list_tables([like, database])