When click the button ADD DATABASE, it will respond status code 500 with this error message:

{"errors": [{"message": "module 'sqlalchemy_clickhouse.base' has no attribute 'name'", "error_type": "GENERIC_BACKEND_ERROR", "level": "error", "extra": {"issue_codes": [

{"code": 1011, "message": "Issue 1011 - Superset encountered an unexpected error."}

]}}]}

if goes to the container log, it shows stack trace:

2021-11-11 22:19:36,244:ERROR:superset.views.base:module 'sqlalchemy_clickhouse.base' has no attribute 'name' Traceback (most recent call last): File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1950, in full_dispatch_request rv = self.dispatch_request() File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1936, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/security/decorators.py", line 67, in wraps return f(self, *args, **kwargs) File "/usr/local/lib/python3.8/site-packages/superset/views/base_api.py", line 85, in wraps raise ex File "/usr/local/lib/python3.8/site-packages/superset/views/base_api.py", line 82, in wraps duration, response = time_function(f, self, *args, **kwargs) File "/usr/local/lib/python3.8/site-packages/superset/utils/core.py", line 1428, in time_function response = func(*args, **kwargs) File "/usr/local/lib/python3.8/site-packages/superset/utils/log.py", line 241, in wrapper value = f(*args, **kwargs) File "/usr/local/lib/python3.8/site-packages/superset/databases/api.py", line 923, in available for engine_spec, drivers in get_available_engine_specs().items(): File "/usr/local/lib/python3.8/site-packages/superset/db_engine_specs/_init_.py", line 130, in get_available_engine_specs backend = dialect.name AttributeError: module 'sqlalchemy_clickhouse.base' has no attribute 'name'

Problem

https://github.com/apache/superset/issues/16492

 

Impact

it can load not add any databases in superset 1.3.0 because it used a broken dialect for clickhouse. Which means I can not connect to any database in superset installed within ODH.

Expected pip3 package: clickhouse-sqlalchemy>=0.1.4, <0.2
Actual package installed in quay.io/opendatahub/superset:1.3.0: sqlalchemy-clickhouse==0.1.5.post0 (broken one)