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.

connect([host, port, database, user, …])

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)

Checks if a given database exists

ClickhouseClient.get_schema(table_name[, …])

Return a Schema object for the indicated table and database

ClickhouseClient.set_database(name)

Set the default database scope for client

ClickhouseClient.list_databases([like])

List databases in the Clickhouse cluster.

ClickhouseClient.list_tables([like, database])

List tables in the current (or indicated) database.