Pandahouse
Pandas interface for Clickhouse HTTP API
Install
pip install pandahouseUsage
Writing dataframe to clickhouse
connection = {'host': 'http://clickhouse-host:8123',
'database': 'test'}
affected_rows = to_clickhouse(df, table='name', connection=connection)Reading arbitrary clickhouse query to pandas
df = read_clickhouse('SELECT * FROM {db}.table', index_col='id',
connection=connection)