Clickhouse dbt connection error (http driver error)

Help
1

Clickhouse connection to dbt error

I have a profiles.yml

# 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

>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

2

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

1 Like
3

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