脚本连接方法

Python

clickhouse-driver

pip install clickhouse-driver

# -*- coding: utf-8 -*-

from clickhouse_driver import Client

client = Client(host='127.0.0.1',port='9000',user=clickhouse_user ,password=clickhouse_pwd)
sql = 'SHOW DATABASES'
res = client.execute(sql)
print(res)