How to connect with the multiple host

[anilvpatel21]

For HA for the databases, it recommends providing alt_hosts as a parameter to the connection string. The clickhouse drive in the pip install clickhouse-driver supports parameters to pass in the connection uri. But how to achieve it in sqlalchemy-clickhouse. So, Is there a way to pass parameters in create engine to support alt_hosts

alt_hosts – list of alternative hosts for connection. Example: clickhouse://username:password@host:port/database?alt_hosts=host1:port1,host2:port2

It will assure that if the host is failing it will connect to the alternate host for high availability.