Authenticatintg with SSH key instead of password?

[babaMar]

I'd like to authenticate to ClickHouse via SSH key instead of password. I already have multiple users that have been created without password (... IDENTIFIED BY ssh_key ...) that needs to run user and role creation statements.

I tried to use SSH tunnel, but the port 22 is not open on the ClickHouse server, so all I'm thinking is to replicate the native client behavior.

I tried this:

chc = Client(
    host='<host>',
    secure=True,
    user='<user>',
    keyfile='<myprivatekey>'
)

chc.execute('SHOW DATABASES')

which gives:

DB::Exception: securityadmin: Authentication failed: password is incorrect, or there is no user with such name.. Stack trace:

but I suspect that keyfile is for mutual TLS, not SSH authentication.

I could help with this if you can point me to the right direction.