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.
|
Create an ClickhouseClient for use with Ibis. |
Close Clickhouse connection and drop any temporary objects |
|
|
Determine if the indicated table or view exists |
Checks if a given database exists |
|
|
Return a Schema object for the indicated table and database |
Set the default database scope for client |
|
|
List databases in the Clickhouse cluster. |
|
List tables in the current (or indicated) database. |