Database addition error with superset about clickhouse-sqlalchemy

[xzkostyan]

Hi!

How can I exactly reproduce the problem?

[hemantjadon]

You can reproduce this by simply trying to add a clickhouse database to superset. There is no error on stack trace. Using this dialect. The code is going haywire at base.py line 463.
Here https://github.com/xzkostyan/clickhouse-sqlalchemy/blob/master/clickhouse_sqlalchemy/drivers/base.py#L463

See right hand side debug trace.

[xzkostyan]

Can you provide small piece of code that reproduce the problem, please?

[hemantjadon]

What I did was:

• Run superset, (in dev mode)
• Try to connect to clickhouse clichouse://default:@<host>:<port>
• The error appears.

What I have found out is that, on L463, it should be self._execute() instead of connection.execute(), I tried and the db got successfully added.

[xzkostyan]

I suppose we can close issue. Follow official superset guide for ClickHouse: https://superset.apache.org/docs/databases/clickhouse/