# Clickhouse dbt connection error (http driver error)

**URL:** <https://discourse.getdbt.com/t/clickhouse-dbt-connection-error-http-driver-error/10758>\
**Category:** Help\
**Tags:** dbt-core\
**Created:** [November 13, 2023, 5:27pm UTC](https://discourse.getdbt.com/t/clickhouse-dbt-connection-error-http-driver-error/10758 "2023-11-13T17:27:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![katoo2706](https://avatars.discourse-cdn.com/v4/letter/k/a8b319/32.png) [@katoo2706](https://discourse.getdbt.com/u/katoo2706)\
**Post date:** [November 13, 2023, 5:27pm UTC](https://discourse.getdbt.com/t/clickhouse-dbt-connection-error-http-driver-error/10758/1 "2023-11-13T17:27:33Z")

</div>

## Clickhouse connection to dbt error

## I have a profiles.yml

```auto
# profiles.yml
config:
  send_anonymous_usage_stats: False
  use_colors: True
  partial_parse: True

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

```

When I tried to run `dbt debug`

## It shows this error

```auto
>Database Error
  Error HTTPSConnectionPool(host='118.70.33.114', 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 https://118.70.33.114:8123

Check your database credentials and try again. For more information, visit:
https://docs.getdbt.com/docs/configure-your-profile

```

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

Please help me

---

<div class="post-metadata">

**Author:** ![Bora](https://avatars.discourse-cdn.com/v4/letter/b/e56c9b/32.png) [@Bora](https://discourse.getdbt.com/u/Bora)\
**Post date:** [December 9, 2023, 7:58pm UTC](https://discourse.getdbt.com/t/clickhouse-dbt-connection-error-http-driver-error/10758/2 "2023-12-09T19:58:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/getdbt/original/1X/a7a7ca1fe379aaf90952b0e13118a817babcd14f.png) [@system](https://discourse.getdbt.com/u/system)\
**Post date:** [December 16, 2023, 7:59pm UTC](https://discourse.getdbt.com/t/clickhouse-dbt-connection-error-http-driver-error/10758/3 "2023-12-16T19:59:29Z")

</div>

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