Clickhouse dbt connection error (http driver error)

Clickhouse connection to dbt error

I have a profiles.yml

# profiles.yml
  send_anonymous_usage_stats: False
  use_colors: True
  partial_parse: True

  target: dev
      driver: http
      cluster: cluster_1S_2R
      type: clickhouse
      schema: imdb_dbt  # create by dbt
      user: admin
      password: ***
      port: 8123
      retries: 1
      verify: False
      secure: True
      connect_timeout: 10

When I tried to run dbt debug

It shows this error

>Database Error
  Error HTTPSConnectionPool(host='', port=8123): Max retries exceeded with url: /?wait_end_of_query=1 (Caused by SSLError(SSLError(1, '[SSL: WRONG_VERSION_NUMBER] wrong version number (_ssl.c:1002)'))) executing HTTP request attempt 1

Check your database credentials and try again. For more information, visit:

I tried to upgrade all dependencies but I didn’t work. I also can connect to clickhouse with my provided credentials

Please help me

Hello! I’ve solved this issue.
Try secure: False

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.