superset: can't connect clickhouse db using superset occur ERROR: Could not load database driver: clickhouse
URI String is : clickhouse://gpsec:xxx@xxx:8858/sec
docker-compose logs -f -t superset
uperset_app | 2021-02-02T03:23:36.323066230Z 172.17.0.233 - - [02/Feb/2021 03:23:36] “GET /api/v1/database/_info?q=(keys:!(permissions)) HTTP/1.1” 200 - superset_app | 2021-02-02T03:23:36.323076390Z INFO:werkzeug:172.17.0.233 - - [02/Feb/2021 03:23:36] “GET /api/v1/database/_info?q=(keys:!(permissions)) HTTP/1.1” 200 - superset_app | 2021-02-02T03:23:36.377123020Z 172.17.0.233 - - [02/Feb/2021 03:23:36] “GET /static/assets/images/favicon.png HTTP/1.1” 200 - superset_app | 2021-02-02T03:23:36.377136655Z INFO:werkzeug:172.17.0.233 - - [02/Feb/2021 03:23:36] “GET /static/assets/images/favicon.png HTTP/1.1” 200 - superset_app | 2021-02-02T03:23:48.713990050Z DEBUG:superset.models.core:Database.get_sqla_engine(). Masked URL: clickhouse://gpsec:XXXXXXXXXX@10.200.xx.xx:8858/sec superset_app | 2021-02-02T03:23:48.716697915Z DEBUG:superset.stats_logger:[stats_logger] (incr) DatabaseRestApi.test_connection.error superset_app | 2021-02-02T03:23:48.716723303Z DEBUG:superset.stats_logger:[stats_logger] (timing) DatabaseRestApi.test_connection.time | 7.412515580654144 superset_app | 2021-02-02T03:23:48.717956405Z 172.17.0.233 - - [02/Feb/2021 03:23:48] “POST /api/v1/database/test_connection HTTP/1.1” 422 - superset_app | 2021-02-02T03:23:48.717973565Z INFO:werkzeug:172.17.0.233 - - [02/Feb/2021 03:23:48] “POST /api/v1/database/test_connection HTTP/1.1” 422 -
what you expected to happen.
Actual results
what actually happens.
Screenshots
If applicable, add screenshots to help explain your problem.

How to reproduce the bug
- Go to ‘…’
- Click on ‘…’
- Scroll down to ‘…’
- See error
Environment
(please complete the following information):
- superset version:
superset version - python version:
python --version - node.js version:
node -v
Checklist
Make sure to follow these steps before submitting your issue - thank you!
- I have checked the superset logs for python stacktraces and included it here as text if there are any.
- I have reproduced the issue with at least the latest released version of superset.
- I have checked the issue tracker for the same issue and I haven’t found one similar.
Additional context
Add any other context about the problem here.
About this issue
- Original URL
- State: closed
- Created 3 years ago
- Reactions: 2
- Comments: 15 (3 by maintainers)
There’s info for how to add python db drivers in the docker docs
https://github.com/apache/superset/blob/676e0bb28211ec8e588abb8898924771d3dd6f32/docker/README.md#local-packages
If you use a password for the default user in clickhouse, you need a different infi.clickhouse_orm version
pip uninstall infi.clickhouse_orm pip install infi.clickhouse_orm==1.0.4