question: How to connect target-clickhouse with SSL certificate?

[AndreiPetrukhin]

I am not sure about settings for clickhouse and have pretty the following settings:

loaders:

• name: target-clickhouse
  variant: shaped-ai
  pip_url: git+https://github.com/shaped-ai/target-clickhouse.git
  config:
  database: holding_test
  default_target_schema: holding_test
  host: rc1a-hqgn203ff9jog6cr.mdb.yandexcloud.net
  load_method: upsert
  port: 8443
  table_name: test
  username: user1
  verify: true
  cert: "/home/andrew_petrukhin_vlad/.dbt/RootCA.pem"

trying to upload data into Clickhouse db and get the following error:
File "/home/andrew_petrukhin_vlad/meltano-projects/dbt-gbq-clickhouse/.meltano/loaders/target-clickhouse/venv/lib/python3.9/site-packages/requests/sessions.py", line 637, in post
return self.request("POST", url, data=data, json=json, **kwargs)
File "/home/andrew_petrukhin_vlad/meltano-projects/dbt-gbq-clickhouse/.meltano/loaders/target-clickhouse/venv/lib/python3.9/site-packages/requests/sessions.py", line 589, in request
resp = self.send(prep, **send_kwargs)
File "/home/andrew_petrukhin_vlad/meltano-projects/dbt-gbq-clickhouse/.meltano/loaders/target-clickhouse/venv/lib/python3.9/site-packages/requests/sessions.py", line 703, in send
r = adapter.send(request, **kwargs)
File "/home/andrew_petrukhin_vlad/meltano-projects/dbt-gbq-clickhouse/.meltano/loaders/target-clickhouse/venv/lib/python3.9/site-packages/requests/adapters.py", line 501, in send
raise ConnectionError(err, request=request)
requests.exceptions.ConnectionError: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))

[dror-g]

I think you might be missing secure: true.
For me it works when it's included, but I'm not using a custom cert (maybe remove verify to ignore that?).

Also I'm using just this config line, not broken:
sqlalchemy_url: clickhouse+native://default:<yourpassword>@aeopdsaday.us-east-1.aws.clickhouse.cloud?secure=true

Notice I use clickhouse+native. you can set that with driver option.
https is not a valid driver, only http is, but won't connect over SSL.

(sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:clickhouse.https )