首先下载源码git clone https://github.com/cloudflare/sqlalchemy-clickhouse.git
可以看到里面有个example.py写了使用例子
#!/usr/bin/env python
# Use connector directly
import connector
cursor = connector.connect('tools').cursor()
cursor.execute('SELECT * FROM users LIMIT 10')
print(cursor.fetchone())
# Register SQLAlchemy dialect
from sqlalchemy.dialects import registry
registry.register("clickhouse", "base", "dialect")
# Test engine and table
from sqlalchemy import *
from sqlalchemy.engine import create_engine
from sqlalchemy.schema import *
engine = create_engine('clickhouse://default:@192.168.1.22:8123/tools')
logs = Table('users', MetaData(bind=engine), autoload=True)
print(select([func.count('*')], from_obj=logs).scalar())
查看connector.connect方法